Just a small query problem. Easy one!

[McMaster]

Hi,

 

I am having a slight issue with a mysql query. I am getting the following error:

 

mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in ***

 

$sql = "SELECT * FROM inbox WHERE product_id = '".$_GET['id']."' AND from != 'admin'";

$res = mysql_query($sql);

$row = mysql_fetch_assoc($res);

 

Now you see, if I take away the 'from' part of the query I don't get this error. Is there any way to stop this error without having to change the from field in my database table?

 

Thanks guys!

[taquitosensei]

if this

$sql = "SELECT * FROM inbox WHERE product_id = '".$_GET['id']."' AND from != 'admin'";

works

 

Then so should this

$sql = "SELECT * FROM inbox WHERE product_id = '".$_GET['id']."'";

[de.monkeyz]

THe problem is that "from" is a keyword in mySQL. To stop the problem, surround from in backticks ``

 

$sql = "SELECT * FROM inbox WHERE product_id = '".$_GET['id']."' AND `from` != 'admin'";

 

[McMaster]

I know what you are saying but I really need to have it so it doesn't show the admin part. Is there anything I can do with the from field to make this work?

[de.monkeyz]

Oh, if you don't know where the back tick key is, it should be just below Escape.

[McMaster]

THe problem is that "from" is a keyword in mySQL. To stop the problem, surround from in backticks ``

 

$sql = "SELECT * FROM inbox WHERE product_id = '".$_GET['id']."' AND `from` != 'admin'";

 

This removed the error I was getting but the query still isn't working right Hmmm!

[de.monkeyz]

How is the query not working? Is it displaying admin entries? Or none at all?