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.
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.