[RESOLVED] Trying to insert data into a table... what am I doing wrong?

[TrickyPhillips]

<?php
$connection = mysql_connect("localhost", "******", "******");
if (!$connection)
{
	die('Could not connect: ' . mysql_error());
}

mysql_select_db("trickyph_testdb1", $connection) or die('Could not select DB.');
$query = "INSERT INTO users (FirsName, LastName, Address, City) VALUES ('Jimmy', 'Watts', '484 Wolfer Ln.', 'Springston')";
mysql_query($query, $connection);
mysql_close($connection);
?>

Executing the query in phpMyAdmin works fine, but when I try to use the example above, nothing happens. Any suggestions?

Thanks.

[sheephat]

mysql_query($query); i dont think having $connection is nessasary. ill be back after a read up.

[sheephat]

http://www.w3schools.com/php/php_mysql_insert.asp

[NogDog]

To get more debug info, try this pattern:

mysql_query($query, $connection) or die("Query failed ($query): " . mysql_error());

This way, if it fails you'll see the query exactly as it was sent to MySQL, plus the error message it returned.

[TrickyPhillips]

Haha. I had misspelled "FirstName." :o

Embarrassing. Thanks for the responses. 🙂

[sheephat]

Haha, not a problem, it can be an easy mistake..