Check a couple of things:
1. Do you have a primary key with unique id? You could be getting a key violation.
2. Echo $query and confirm that it is as you expect.
3. Add code to trap for, or at least display any generated error.
4. Are you able to test this INSERT at the MySQL console?
If so, and it works, compare what works in 4. with what you have at 2.
At 08:41 PM 2/2/2003 -0500, Matt wrote:
Hi. I am having a problem with adding a record into a table of a database. I have attached the code I am using to accomplish this. It works if the table is empty, but if there is already a record in the table, it won't add anything. Could anyone help me out with this? Here is the code I am using:$query = "INSERT INTO TableName (SID,StudentLastName,StudentFirstName,StudentEmail,StudentLoginName,StudentP assword) VALUES ('$SID','$StudentLastName','$StudentFirstName','$StudentEmail','$StudentLogi nName','$StudentLoginPassword')"; $results = mysql_query($query); Like I said, this works if the table is totally empty, but if there is already an entry in there, it does nothing. Please help if you can. Thanks. Matt -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php