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

unexpected T_SL without a shift left token
Nothing too see here, I'm an idiot and resolved the problem.

shift numbers with paging
Hi

How would i be able to display 10 numbers 1 2 3 4 5 6 7 8 9 10
and when I click next

Material xxx does not exist in plant xxx
Dear All,

I am working for a steel project which is repetitive manufacturing.

http to https
Hi,

Is there any specific method/condition to move an http:// page to https:// ?

Breaking results into week blocks
I have a set of dates (and times), which are returned from a mySQL query.

These usually span

problem with GROUP BY and ORDER BY
i usually use this query to display the last 10 entries from a sql table:

Code: $query = &quo

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


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

Converting numbers to months
The porgram works -just need the last function(month_convert_ to convert numbers to months -thanks.

IS this code correct
The reason i ask is everything underneath it appears to be alink as well, tis blimmin annoying

Two fgetcsv related questions ;D
First of im trying to get a file from a merchants server but the directory is protected, I know the