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

generating all possible random letters
hi'

how can i randomize the letters a,b,c,d,e all possible ways, and i want to print the res

BackButton Behaviour in AJAX
I have an ASPX Page AJAX Enabled!The page has a gridView and a DDL for filtering on it. The Gridview

Multiple while loops
I have several DB queries that I know should be returning results and aren't. I have a feeling it ha

Multithreading design
Hi

I have come up with a Singleton class that manages a pool of database connections. Basical

HTML form problem
Ive made a form to that i want to send to my email via PHP. but when it send only the name's etc sen

Retreiving objects from Sessions
Hi all,

I am getting really frustrated with storing and retreiving objects from a session. Bu

SAP Project Module
I have seen in the SAP Project Module,plan cost and budget are not equal and even difference is sign

How can use this array as a key?
Say I have this array for example:


print_r($array);

Prints:
Code: [Select]Array

BSP Ext - tableView - Sort - NEWBIE
Hi,
I have been trying to get the sort to work. I have defined the column definitions by fillin

getting a website's source code as a variable? How?
Hey guys, is there any way for me to get the source code of a website as a variable for me to work w