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

Character increment
Hi,

I am facing a scenario like above,but in my case i want to show up like Col A,Col B etc..

Recording popularity by day, week.. all time?
Hey everyone, I'm creating a site designed around users uploading music. How can I implement a syste

Consuming third party Payment Gateway API from Procedure.
Hi All,

First of all i would like to thank all the people of the oracle forum for providi

how to query data from website using VC?
I want to query some datum from a website,so I need a program to read data from a .csv file, and ass

Bit manipulation program with binary operations
My homework is to create a program to scan in and add binary numbers and print them like so

chat
hello i'm amir i need a chat source code in asp.net 2.0 without Ajax. anybody can help me?

returning data from an ssh2_exec()
here's what i got.


$conn = ssh2_connect($this->_host);
ssh2_auth_password($c

Execure stored procedure on a timer
Can someone tell me an easier way to execute a stored procedure on a timer? I am using Oracle 10g R

Upload simple problem
Really confused!! I run once and it worked, but when i tried today...it didn't work

Which par

breaking a text file into paragraphs based on strings
I have a text file of email addresses that is all squished together. It looks like this:

abc