Find out if insert is successful or not 1

[gmail2]

I'm writing a script which will upload a CSV file and insert the records into a mysql database. Is there any way if I can find out for each insert whether or not the insert statement was successful? That way the user can act on any unsuccessful inserts.

Thanks in advance

 

[lgarner]

From

http://us2.php.net/manual/en/function.mysql-query.php:

"For other type of SQL statements, UPDATE, DELETE, DROP, etc, mysql_query() returns TRUE on success or FALSE on error."

Try evaluating the return from mysql_query().

 

[gmail2]

Perfect - that's exactly what I was looking for. Thanks so much for that

 

[gmail2]

Sorry, I know this is an old post. Just wondered if there's any way of getting an error code if the insert isn't successful? I see in phpMyAdmin if you try something and it fails it will say MySQL said blah blah blah. So I presume there is some way, do you know how?

 

[sleipnir214]

If there was an error in the UPDATE query, then mysql_query() will return FALSE, and you can get the error number or string with mysql_errorno() and mysql_error(), respectively.



Want the best answers? Ask the best questions!

TANSTAAFL!!