Creating a variable by pulling a value from a MySQL database

[server]

I am using a MySQL table called "login" that includes fields called "username" and "subcheckr."I would like to run a PHP query to create a new variable equal to "subcheckr" in the table where "username" equals a variable called $u. Let's say I want to call the variable "$variable."How can I do this? The query below is what I have so far.Thanks in advance,John\[code\] $sqlStremail = "SELECT subcheckr FROM login WHERE username = '$u'";\[/code\]