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

Gerenate tabel in Php
I whant to generate a tabel takeing data from database like this one so the results to be display on

data type in column definition
Hi,
I create a table with column called "Direction of Travel code ".
The travel codes in t

ORA-00932: inconsistent datatypes: expected - got CLOB
SO : windows xp
database : XE

there is a table (transito) with two fields of clob

How to create a static html menu from a database
Hi,

I have built a small cms which allows me to create simple html pages and then upload them

An odd assignment statement. Can someone explain this assignment to me?
What purpose is served by the bit of code between the two equal signs in the $installurl set? Is th

Whats wrong with my query?
I am trying to get this query to show the appropriate ticked vehicle roof height, unless no boxs are

How to convert this array to string
I am having problems converting this array to a string
using print_r($val[1]); I get:
Code: [

php redirecting
i wont open a new thread but i have a question about redirecting....
i wonder why my code doesnt

include function being weird?
I have a very simple system to grab an IP outputted by a PHP file.. (for a project I have) but it ou

captcha error
I have been trying to implement a captcha in php...

here is the code..
Code: (php) [Select