Validation Problem

[Brazil]

Hi guys!

My script is working perfectly well except this problem:
I've got a form which allows users to add records and edit.The problem is you can insert any junk e.g where you are expected to insert a number you can insert string and vica versa,Of which is wrong.What i need is when you insert a something in the form it must be checked if it is valid and then be passed to the database.

Can i have an example of how to do that plz?

Thanx in advance!

[laserlight]

There are functions such as is_numeric() that you can use, or you can define your own functions to use.

[Brazil]

Can i have an example plz.

[laserlight]

A simplistic example would be:

if (is_numeric($_POST['money']) && $_POST['money] >= 0) {
	db_query("UPDATE moneytable SET money='" . $_POST['money'] . '" WHERE user_id='$user_id'");
}
else {
	echo "Sorry, you entered an invalid amount of money";
}