PHP mysql_query not processing

nro · 09-19-2004, 07:05 PM

I have what seems to be a very small problem, but what an annoyance.
I have a query line in the variable $finalQuery.

I have the following code:

Code:

$finalQuery = "INSERT INTO `manual` VALUES ('0', 'test', 'test');";
mysql_query($finalQuery);
print "Error: " . mysql_error();

The query is not processing and I am getting the following display on the web page:

Error: Query was empty

Any suggestions?

Thanks,
Mike

Sadrul · 09-19-2004, 09:43 PM

mysql-queries should not have semi-colons at the end when you execute them from php.

-- Adil