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

Need help to identify this error please
:confused:Can anyone help me tell what this error message means? Maybe tell me where to look to fix

Script not running properly
Hello Everyone
This is a basic script for posting to a database. I'm not sure why it doesn't work

How to ... (FAQs)
... get e-mail notifications As several people asked how to get e-mail notifications when new posti

List/Menu Box
On an edit page when you want something to select what a user has previously selected from the datab

News script
Hi ...

I am not sure if this is the rite place to post this but if its not sorry

i am

Sequencing or queuing parallel process
Scenario is as follows
There is one parent process say P1 and 4 child processes say A B C D

Problem with HTTP Caching...?
Hi there, im trying to implement caching. But it doesn't always work.
I post it here because ther

MySQL Primary key gap
Alright, so I have a table with 26 entries in it (id, filename, caption) for my image randomiser (ht

Inserting a variable in a link
I have this code that I want to insert for my own variable but I have no idea how. This is what I wa

getting Vars to pass to next page.
Hello all,
I have a confusing situation on my hands, i am a member of a gaming community and we