SQL Query not working

[benjy355]

A query I'm using is returning no errors and no database update!

$qtxt = "INSERT INTO site_uploads (uid, title, desc, file, uploaded) VALUES ('" . $UserID . "', '" . $Data[1] . "', '" . $Data[2] . "', '" . $_FILES['uploaded']['name'] . "', '" . date("Y-m-d") . "')";mysql_query($qtxt) or CreateError("Could not query database: " . mysql_error());

Anybody know why this is happening? After I printed the query this was basically what came up: (no errors I can see)

INSERT INTO site_uploads (uid, title, desc, file, uploaded) VALUES ('1', 'Notepad 2', 'Try it!', 'Notepad 2.zip', '2006-08-03')

[aspnetguy]

are all sql fields of type text or varchar???I don't see anything wrong either

[justsomeguy]

What does CreateError do? Maybe just print mysql_error() regardless of what happens, and see if it ever shows anything.

[benjy355]

What does CreateError do? Maybe just print mysql_error() regardless of what happens, and see if it ever shows anything.

CreateError(); is a function I made for posting errors without stopping everything and ruining the page >_>The database structure is: (phpMyAdmin ftw!)

[justsomeguy]

Try pasting the generated query directly into phpMyAdmin and see if it works then.

[benjy355]

Mmkay...

MySQL said:#1064 - 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, file, uploaded) VALUES ('1', 'Notepad 2', 'It rocks your s

[justsomeguy]

There is a SQL tab in phpMyAdmin where you can just paste or write a query. Get the query that your page creates and paste it in there to see if it runs.

[The Reverend]

I don't know how it is on your server, but the one I use requires syntax using ` surrounding the table name and fields, like this:

INSERT INTO `site_uploads` (`uid`, `title`, `desc`, `file`, `uploaded`) VALUES ('1', 'Notepad 2', 'Try it!', 'Notepad 2.zip', '2006-08-03')

[justsomeguy]

Typically backquotes aren't required, but they can be used for clarification. For example, since "date" is a reserved SQL word, if you have a column named "date" you need to surround it with backquotes when you refer to it.

$me =& new SixPack();

You have turned yourself into a sixpack, dude!

[The Reverend]

I don't see anything wrong with it then. I setup a table to the same specs he's given on my XAMPP deal on my computer and ran the query, it works fine.I think of =& as buy in this case btw. My beer drinking class is a work in progress.

[benjy355]

It's working now I needed to fix that for my uploads page

[ThePsion5]

I think of =& as buy in this case btw. My beer drinking class is a work in progress.

I don't think that PHP5 supports operator overloading, lol. But while we're at it:

foreach($internet as $website){  if($website->doesSuck(array('standards', 'coding', 'content', 'design'))  {	self::optimize(website);	self::sendInvoice(website);	self::addToResume(website);  }}$income = self::getDisposableIncome();spend($income, array('videogames', 'computerstuff', 'ninjagear');self::increment1337();

[benjy355]

I don't think that PHP5 supports operator overloading, lol. But while we're at it:

foreach($internet as $website){  if($website->doesSuck(array('standards', 'coding', 'content', 'design'))  {	self::optimize(website);	self::sendInvoice(website);	self::addToResume(website);  }}$income = self::getDisposableIncome();spend($income, array('videogames', 'computerstuff', 'ninjagear');self::increment1337();

Hehehe,spend($income, array('videogames', 'computerstuff', 'ninjagear');PHP would return "Unexpected ';' expecting ')' on line 11 of omfglolwtfbbq.php"