[SOLVED] How to shoy mysql_query success message

[abdfahim]

When I run any query using mysql_query, if any error occured, I can get the error message from mysql_error(). Is there any similar function which will result success message.

[Chris92]

No, what you can do is write it yourself:

<?php
if( mysql_query("UPDATE `table` SET `field` = 'update' WHERE `field` = 'needs updated'") )
{
    echo "Successfully updated field";
} else
{
    echo mysql_error();
}
?>

[abdfahim]

the main problem with this is, for the following code

 

REPLACE INTO `table1` SELECT * FROM `table2` WHERE CONDITION;

 

I cant know how many rows has been updated. In phpmyadmin, if you run this query in any program like phpmyadmin, you will see this count how many rows has been updated. If there is no built-in function for this, I have write some other quiries to get that fegure.

[PHP Monkeh]

You could take a look at :

 

http://uk.php.net/manual/en/function.mysql-affected-rows.php