I am new to php so bear with me. I have a simple php file that tries to
insert data into a mySQL database table.

When I try to run it I get a "query was empty". I've googled this error
message and found many, many hits but I still can't figure out what's wrong
with my script.

Here's a snippet:
// Connect to db
$con=mysql_connect ("localhost", "<dbname>", "<password>") or die ('I cannot
connect to the database because: ' . mysql_error());
// Select db
mysql_select_db ("<table>");
echo(date("l dS \of F Y h:i:s A") . "<br />");

mysql_query("INSERT INTO person (FirstName, LastName, Age) VALUES('Jack',
'Bauer', '67')");
//Try to insert the record
if (!mysql_query($sql,$con))
  die('Error: ' . mysql_error());
echo "1 record added";
// Close the connection

This seems like it should be a simple thing to do but I can NOT figure it

Any help would be greatly appreciatetd.
View this message in context: 
Sent from the Php - Database mailing list archive at Nabble.com.

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to