RE: [PHP] logging of sql queries - success/failed
| From: | Jim Moseby | Date: | Thu, 07 Jun 2007 19:14:24 +0000 |
| Subject: | RE: [PHP] logging of sql queries - success/failed | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-256310@lists.php.net to get a copy of this message | ||
> I've got a script that imports several CSV files via the Load
> Data File
> command.
>
> I need to know if each import query was successful or failed.
>
>
>
> Is there a way to log the success/failure of each query including how
> many rows were inserted?
>
>
>
I assum you are using MySQL, since you didn't specify. Typically,
mysql_query() will return false if the query failed, and
mysql_affected_rows() will return the number of rows affected.
JM