Bizarre MySQL Error

[propel]

I'm getting this a strange MySQL error that I have never seen before. I have the following code:

$labelQuery = "SELECT ID FROM labels WHERE name = $mylabel";
$labelResult = mysql_query($labelQuery) or die("Invalid query: " . mysql_error().__LINE__);

Which produces the following error message:

Invalid query: Unknown column '3p' in 'where clause'464

The strange thing is that '3p' is not the column name, but rather the criteria that i am using for the 'name' column. The $mylabel variable is fetched from another query run earlier as:

$mylabel = $row['label'];

Any ideas? Any help would be greatly appreciated! Thanks!!!

PS: The error shouldn't have to do with quotes used in the query string. I've tried every combination there.

[NogDog]

You need to quote non-numeric values in SQL:

$labelQuery = "SELECT ID FROM labels WHERE name = '$mylabel'";

[propel]

NogDog wrote:

You need to quote non-numeric values in SQL:

$labelQuery = "SELECT ID FROM labels WHERE name = '$mylabel'";

Tried that. Same result. 😕

[NogDog]

Let's make sure the value is "safe" with mysql_real_escape_string(), and also put the actual query in the error message so we can see exactly what was sent to MySQL if it still fails:

$labelQuery = sprintf("SELECT ID FROM labels WHERE name = '%s'",
                      mysql_real_escape_string($mylabel));
$labelResult = mysql_query($labelQuery) or die("Invalid query ($labelQuery): " . mysql_error().__LINE__);

[propel]

That did the trick. Thanks!! :-)

[bradgrafelman]

Don't forget to mark this thread resolved.