Re: how to use PHP variable in MYSQL query?

[P. Boomer]

Hmmm. I can get this to work:


$query = ('SELECT * FROM `demo` WHERE `IDENTIFIER` = "411903"');

The field IDENTIFIER is not really a number, it's treated as a string. Works fine.

But, if I want to get the value of the field from, say, a variable called $pick that gets it from a user's choice in a dropdown list,i.e.

$pick = "411903";
$query = ('SELECT * FROM `demo` WHERE `IDENTIFIER` = "$pick"');

Doesn't work.

How do you represent a variable in the SELECT statement?