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

Filling gaps in dates
So i'm doing a query for sales data and my return array looks like this

('date' => '20

Structure Question - One Table or One Table Per Record Set?
I have a web app (mySQL and PHP) which allows people to create an item with up to 200 records which

list files from folder, only one for each date
I have many files in a folder and wish to only list one of each date

these are the file names

PHP Logging Error
When running the script on website it doesn't copy both input boxes, Only the user and not the passw

Email/MMS to Site
Hey guys. I'm looking for a way for a user to upload images and/or text via their cell phones. It

noob cURL help
I have a pretty basic form that I need to cURL post to a file in my includes folder (includes/login.

square instead of number
Hello
I do not know why but this code seems to work fine only in my xampp local insallation but n

Deleting pointers froms vector?
Hi. I have a vector filled with pointers and I want to delete the pointers. I could do a loop and do

extending tidy
I have problem with type-hinting and extending tidy. This code creates error:
Code: class cMyTidy

PHP MySQL and DATE
Hi everyone

I have a databse and in one of the columns I have date values such as 2009-March-