Conditional insert

Hi, i have a php table with 7 rows, which sometimes are not all required. Is it possible to do a conditional insert if fields not empty?

At the moment all 7 rows are inserted regardless of whether only 1 or 2 rows are filled.

PHP table?
Do you mean a MySQL table?

7 rows?
Do you mean columns?

LOL :S - yeah, sorry. I obviously need some sleep.

When you insert a row in a table, all columns are inserted. Of course, not all columns have to have a “meaningful” value, they may be NULL or spaces or zero.

Thanks. I am filtering !=’ ’ from the results, so nearly what i wanted.