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
Did you know?Explore Trending and Topic pages for more stories like this.
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?
No comments posted yet

Your Answer:

Login to answer
341 Like 48 Dislike
Previous forums Next forums
Other forums

Access website from only 1 computer...?
One of my customers wants his website to only be accessed by people in which they bought the website

Expandable Post Code
Hi,

Hope you can help. Which currently I haven't upgraded to connect to a mysql server, so i

How would I protect......
I have a from, actually, a good amount of forms. How can I make it so you can't type the characters:

Help with Contact Form
I have this Form on an html page and the associated code on page.php (below).
I keep getting the

trouble printing an array....
I'm having some trouble printing out an array forwards. I'm figuring out the high and low of an arra

Displaying Column Names
I have a question regarding the ability to show the column names from my table/query.
What I'm lo

Output Buffering question
Hi all,

I've been trying to wrap my head around output buffering. So far I've found tons of

Do While statement
hi guys,

This may sound trivial but im new to php and as part of an assignmenti have to const

timezone change with date()
so i put all my times for posts in my made from scratch forum(not phpbb3 or sm)
in my mysql db u

CE 7.1 and External GIS integration
Hi All,

We want to develop an application on CE 7.1 which uses GIS features from an exter

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash