Store value from SELECT statement into variable

Programmer Question

How can i store the value from a SELECT MySQL statement into a PHP variable?
for example:

$myvariable = SELECT * FROM X WHERE id = X

Thanks

Find the answer here