Php mysql - select?

Posted on 16th Feb 2014 07:03 pm by admin

Hi i have this code:
Code: $iteminfo = mysql_query("SELECT desc FROM wc_items WHERE itemid = '$_GET[id]'")
or die(mysql_error());
And it gives me
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc FROM wc_items WHERE itemid = '103'' at line 1

What could be wrong?

Your Answer:

Login to answer

Other forums

RadioButtonList data selection
view plaincopy to clipboardprint?

Apart from cron
I need to run a php file every one hour. Is there any other solution apart from cron job?

Baffled by Undefined Index in Simple Array: Please Help!
Hello. I have a form which posts an array to this script. However, I can't seem to access the values

PHP Upload issue
Hi guys,

I have stumble across an interesting issue with my script and is doing my head in.

Update not working ... please help
Hi,

I am trying to update a row using an edit form by passing id of the row .. but it is not

Can't get the unicode character
I'm trying to get some text from various parts of a file. I have converted the file to hex (bin2hex)

how to load php class from another domain?
how to load php class from another domain?

PHP doesn't send my mail
Hi all, I found this and used it to send mail. Simple contact form with some required fields. The va

Displaying an image using echo command
I had done a query on my database, one of the fields being an image reference to a directory where a

reorder sql query
ok so i have this very simple code:
Code: $query = "SELECT search_keywords, COUNT(search_key