PHP / MySQL Error Handling

[Anon]

Using HTML forms, PHP, and MySQL, I have managed to create a functional database with an HTML/PHP frontend which allows records to be added/modified/searched - HOWEVER - If someone is filling in a field and enters some kind of crazy data - for an extreme example, a date field is entered as 2000-09-111 - my page will indicate that the record was added, but it actually will not have been. I have tried something like:

$result = "UPDATE blah, blah";
if(!$result) {
echo "error";
exit();
} else {
blah, blah, blah...
You dig it I'm sure - but that doesn't seem to work. When I intentionally enter bad data, it never catches it. Please point me in the right direction.

[Anon]

Unfortunatly MySQL isn't very helpful about bad data being inserted into a date field. It just assignes the date to be 0000-00-00. You should validate the data before running the sql. Either in you script that updates the database, or as a javascript data validation in the entry page.

[Anon]

also, have a look at mysql_error()

--
rad