Form variable looping and replacement of

hankster

null values in those variables. OK it occured to me that I have done this before but in ASP. I am collecting a fair sized form to eventually place the values into a mySQL DB. So I only have maybe 25% of the fields are required and the rest can be filled in or left alone. What I am trying to do is loop through the form variables and see if there is either no value or a null value and replace it with the text "Info not given". I could do it the "hard" way which is a bunch of "if" statements but I thought I could get some idea of how to do this better. Any and all help is greatly appreciated.

Hank

van__

ermm...

Why not have the DB do this for you?
There's a handy feature for fields called a 'DEFAULT' value.

Just go into your MySQL table and change the default value to whatever you want it to be and tehn when you insert data into the row and that value is not set, it will just insert the default automagically.

...of course you'll need to set the field to 'NOT NULL' as well...

hankster

Thanks Van, still learning the ins and outs of mySQL and PHP. I just did not want any null values floating around the DB.

thanks again!
Hank

Anon

You better use for loop
check it out
$myArray = $HTTP_POST_VARS;
for($i=0;$i<count($myArray);$i++)
{
if ($myArray[$i]=="")
{
$myArray[$i]="No info";
}

}

And I think you can get what is going on. You don't need to pass HTTP_POST_VARS to aother variable. You can directly use it for te loop and you can manage the database processes in the loop.