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

phpmailer class & pop.gmail.com?
Code: <?php
$mail->IsSMTP();
$mail->Host = "pop.gmail.com";

What do you call the "token" thing?
You know how some sites have links that run on tokens? Tokens are links that only stay alive for a c

Creating XML with php
I need to creat an XML with php and have successfully produced a valid output.
The problem I hav

Check Digits and extracting digits
I think I can figure out the code for this but I am having a very hard time getting past the first s

Could Someone Please Debug This?
I was wondering if someone could debug this script for me. I realize it's not the tidest script (and

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: [

Amatuer requiring assistance
Beginner and amateur in need of assistance

My Site - (Spare Parts for Domestic Appliances)

session_destroy();
new to php
I have a simple login and am trying to write a logout.
I set a $_SESSION var to 1 i

Can I call a class inside a function?
I have a class written in another file that handles my image resizing.

Can I do this (php say

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