MySql Error 'Unknown Column' from PHP variable

[Larry in Honolulu]

I'm getting an error message that makes no sense to me. I have a table with a
field named 'testkey' for a list of "keys" in the form of ABC10102. I have a
php variable holding a specific key number.

The relevant code is -
$_testkey = 'LAL10102';
$sql = "SELECT * FROM `pro_keys` WHERE `keynum`=`$_testkey`";
$result=mysql_query($sql,$db_conn);

echoing the $sql gives -
SELECT * FROM `pro_keys` WHERE `keynum`=`LAL10102`

But I get the following error -

MySQL error #1054 - Unknown column 'LAL10102' in 'where clause'

?????????

Thanks for any ideas,
Larry L

[Michael Fesser]

..oO(Larry in Honolulu)

>I'm getting an error message that makes no sense to me. I have a table with a
field named 'testkey' for a list of "keys" in the form of ABC10102. I have a
php variable holding a specific key number.

The relevant code is -
$_testkey = 'LAL10102';
$sql = "SELECT * FROM `pro_keys` WHERE `keynum`=`$_testkey`";
$result=mysql_query($sql,$db_conn);

Strings in an SQL query have to be quoted (and drop the backticks):

$sql = "SELECT * FROM pro_keys WHERE keynum = '$_testkey'";

Micha

[naixn]

Michael Fesser wrote :

.oO(Larry in Honolulu)

>I'm getting an error message that makes no sense to me. I have a table with a
field named 'testkey' for a list of "keys" in the form of ABC10102. I have a
php variable holding a specific key number.

The relevant code is -
$_testkey = 'LAL10102';
$sql = "SELECT * FROM `pro_keys` WHERE `keynum`=`$_testkey`";
$result=mysql_query($sql,$db_conn);

Strings in an SQL query have to be quoted (and drop the backticks):

$sql = "SELECT * FROM pro_keys WHERE keynum = '$_testkey'";

Micha

You have to remind that `` are used to define MySQL fields, databases, or
tables, not values ;)

--
Naixn
http://fma-fr.net

[Larry in Honolulu]

In article <fk********************************@4ax.com>, Michael Fesser <ne*****@gmx.dewrote:

>..oO(Larry in Honolulu)

>>I'm getting an error message that makes no sense to me. I have a table with a
field named 'testkey' for a list of "keys" in the form of ABC10102. I have a
php variable holding a specific key number.

The relevant code is -
$_testkey = 'LAL10102';
$sql = "SELECT * FROM `pro_keys` WHERE `keynum`=`$_testkey`";
$result=mysql_query($sql,$db_conn);

Strings in an SQL query have to be quoted (and drop the backticks):

$sql = "SELECT * FROM pro_keys WHERE keynum = '$_testkey'";

Micha

Thanks Michael,

I've been away from MySql for a while and forgot that. Oddly I have another
query on the same page (different fields and different variable) that uses the
same syntax, though with no backtics and no quotes of any kind that works just
fine.

Larry L

[Larry in Honolulu]

In article <45***********************@nan-newsreader-06.noos.net>, naixn <na***@won-fma.comwrote:

>
You have to remind that `` are used to define MySQL fields, databases, or
tables, not values ;)

I actually never knew that. I just have seen them used in many places, and
never had seen any documentation describing where they were appropriate.

Thanks much for my education.

Larry L

[Michael Fesser]

..oO(naixn)

>You have to remind that `` are used to define MySQL fields, databases, or
tables, not values ;)

You don't have to use them.

Micha