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

foreach iterator
Hi Guys
Does the foreach loop have an inbuilt iterator ?

Will an XHTML DOCTYPE interfere with my PHP if I'm not experienced enough?
I've read this article here: http://friendlybit.com/html/why-xhtml-is-a-bad-idea/

In a nutshe

URL Rewrite issue
Im created a series of Rewrites and on page checks to make sure the correct url is being called. But

ALV sum various columns problem
Hi all,
I'm doing a report on ABAP for a timesheet of the current month. The output i want is s

SuperCali PHP Event Calendar
does anyone have any experience with the SuperCali PHP Event Calendar? I could use some assistance

php multiple action on submit
I have a form which says:

<form enctype='multipart/form-data' method='post' action='pr

Collecting AOL Search Terms
I am attempting to collect AOL search terms. I know the code is correct (it works for google, bing,

please help me in this update statment
hi every one

if I have table and this data in it

id name
10

user data not transferring to new page
I'm a PHP learner. After an index.php page, the user goes to a login.php page. Both pages seem to

Different actions for different parts of a string
<?php
function dosomething($string, $else = '') {
if (empty($else))
$string