I think I get how it works now:

mysql_affected_rows() checks that mysql_query($query) has been executed. If it has, then the value for mysql_affected_rows() becomes 1. Therefore (mysql_affected_rows() is going to be greater than 0 and should echo "You have inserted a new row into the database".

But for some reason it is echoing before the submit button is presses (value should be 0).

__________________
My Personal and Photo Blog