Unknown column - which is actually there

[mschultem]

hi
i have a problem with the following code:

$query = "SELECT * FROM demography WHERE uid=".$pid;
$result=mysql_query($query)
or die ("Error - ".mysql_error()."");

$pid comes from a GET method
demography is the right name for the db, uid is the i right name for a table in demography

it actually works when i replace $pid with one of the values in uid ...
any suggestions?

thanks a log
m

[dreamcatcher]

Hi mschultem,

Try enclosing your var in single quotes:

$query = "SELECT * FROM demography WHERE uid='$pid'";

dc

[jatar_k]

can I just clarify, I assume by this

demography is the right name for the db, uid is the i right name for a table in demography

you mean

demography is the right name for the table, uid is the i right name for a column in demography

just checking

also, what is the exact error that is returned by your die?

[dreamcatcher]

demography is the right name for the table, uid is the i right name for a column in demography

Good catch j, I bet that is indeed the problem. Wrong naming conventions.

dc