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

Giving the below syntax error
Dear Experts,

I have used 2 buttons in gui status as display and cjhange.When the user wi

How to assign a textbox value to PHP variable??
Hi ! Can any one help me out as quickly as possible. As I m new to PHP.
Plz tell me how to assign

Help on code output
My CODE:

Code: [Select] echo "<phone>".$line["phone"].&qu

Storing user data help?
Hey Guys,

I'm not use if this question is to broad but I can always give you more informatio

cyrillic string conversion question
Hello,

First time here...

I would like to know if there is a way to convert a

Applet JTextField Size Problem
Hello,

I recently started making an applet to calculate certain values for airplanes. However

function not returning the correct value
I have a program that needs to return a value from a function. I have an output statement inside the

do while conditions
i want to display 6 images in a 2x3 table
now what would be the correct logic to
count that th

PHP Code To Change Font Color in Table Cell
I would appreciate help with the following snippet of my php code. I am just trying to change the f

Ajax Error since Upgrading to 3.5
Ever since upgrading my site to .NET 3.5 (I needed LINQ), I've been getting this annoying error on o