Preventing blank entries

[tom11011]

How can I prevent a user from submitting a blank field in php or in the mysql database itself?

thanks.

 

[KarveR]

if(empty($field)){
echo "fill me in";
}

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[tom11011]

Hi, thanks for that, it works but continues down the script and adds the blank entry anyways. After it figures out it's blank, how do I prevent it from adding the blank entry into the database?

 

[KarveR]

well, after you figure out you have blanks

if(empty($field)){
$blanks++;
}

if ($blanks > 0 ){

// dont run the query, maybe submit the data back to the form and get it corrected

}else{

// do update as there areno blanks

}

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[tom11011]

hey thanks for that, it worked.

 

[KarveR]

glad to have helped

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.