Re: mySQL Problem
- From: John Murtari <jmurtari@xxxxxxxxxxx>
- Date: Wed, 07 Nov 2007 13:11:24 -0500
Einstein30000 <dominic_ernst@xxxxxx> writes:
in one of my php-scripts is the following query (with an already open
db-connection):
$q = "INSERT INTO main (name, img, descr, from, size, format, cat,
host, link, date) VALUES ('$name', '$img', '$descr', '$user', '$size',
'$format', '$cat', '$host', '$link', '$date')" or die(mysql_error());
And when the query gets executed i get back the following error:
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 'from, size, format, cat, host, link, date) VALUES ('bla', '-',
'keine', 'Holgi',' at line 1
FROM is a reserved word, you have to be careful on the column
names -- that is most likely the problem.
--
John
___________________________________________________________________
John Murtari Software Workshop Inc.
jmurtari@following domain 315.635-1968(x-211) "TheBook.Com" (TM)
http://thebook.com/
.
- References:
- mySQL Problem
- From: Einstein30000
- mySQL Problem
- Prev by Date: Re: Furthering my education in OOP - where/how can one learn professional skills?
- Next by Date: Re: Help Needed: Upgrade Fedora 4 / Apache 2 to PHP 5.2.x from 5.0.4
- Previous by thread: Re: mySQL Problem
- Next by thread: Re: mySQL Problem
- Index(es):
Relevant Pages
|
