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

PayPal Redirect Issue
When I have my paypal button set so that is redirects to http://empiremarketing.ca/order.php,it work

do while...woes
I'm sure this is childsplay but it is stumping me, everytime i try what I think would make this work

bind error during socket programming
i am kinda new to socket programming. wrote the below code for a server. but getting the bind error

explode() function problem maybe
Hi I'm having trouble searching my database. When I type two words in the search field it only searc

ctype() validation - allowing illegal characters
Hello,
I use ctype() to filter and validate a user form. However, I am trying to allow certain c

Select all entries from database that include a phrase
I have a database of clubs - one of the categories is meeting time and place
I would like to have

problem getting my contact form working
Yeah I know this is a pretty basic problem, but it's been a while since I've worked with PHP and I'm

image upload script not working with png
The basic process of this php code is to take the submitted file, convert it to a small JPG thumbnai

Shuffle between users ??
I have multiple $users in table. I need to send them $message.

I need to send the next messag

Please help - should be a simple fix.. driving me nuts
Everything seemed to be working fine. I have a table, it alphabetically lists a bunch of cities and