using variables in WHERE strings?

strunkwriter

What is the proper syntax for using a variable in the WHERE string?

When I use this code:

$query = 'SELECT * FROM props WHERE id=1';

all is well. But, if I switch to this:

$q1 = 1;
$query = 'SELECT * FROM props WHERE id=$q1';

I get a variety of error messages, depending on whether I put the $q1 in quotes or parenthesis or leave it alone. I'm just at a loss on how to handle the $q1 in the WHERE string.

TIA
StrunkWriter

prashant0812

Generally I am using following syntax for PHP - Database query ...
for example

"SELECT t1.* FROM ett_m_training t1 WHERE t1.traingcode = '$traingcode'"

Pur php variable in single quotes and query in double quotes. I am using php & postgresql.

strunkwriter

Thanks, prashant, but I am using MySQL. (Sorry, I should have mentioned that earlier, but I forgot.) Anyone know the right syntax for php/MySQL?

TIA - Again.

strunkwriter

I swear, i tried this syntax before, but it didn't work....

$q1=1;
$query1 = "SELECT * FROM props WHERE id='$q1'";

But, for some reason, I just decided to replace the q1 with a longer variable and replaced it with smu (I know foo is the preferred generic variable, but I thought I'd be different). The end result was:

$smu=1;
$query1 = "SELECT * FROM props WHERE id='$smu'";

Perhaps variables need to be three characters long? I seem to vaguely recall this from when I first learned perl, a millennia ago.

tsinka

Hi,

in your first post you had

$query = 'SELECT * FROM props WHERE id=$q1';

variables are not parsed in single quote strings so the above becomes

SELECT * FROM props WHERE id=$q1

Either use double quotes or do the following (which I would recommend):

$query = 'SELECT * FROM props WHERE id='.$q1;

Thomas