Re: [PHP-DB] oddity with insert multiple input fields tomultipletables

2002-08-18 Thread Chip Wiegand
On Sat, 2002-08-17 at 21:25, Jason Wong wrote: You have to check them before inserting. if ($value !== ) { insert_value(); } -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Okay, so I tried this - if ($date_am || $exercise_am || $reps_am !== ) {

Re: [PHP-DB] oddity with insert multiple input fields tomultipletables

2002-08-18 Thread Chip Wiegand
On Sun, 2002-08-18 at 01:20, Joni Järvinen wrote: if (!isnull($date_am || $exercise_am || $reps_am)) then mysql_query($sql_am) or die (Error in this query $sql : .mysql_error()); Try: if(!isnull($date_am) !isnull($exercise_am) !isnull($reps_am)) This should IMO work :) -Joni-

Re: [PHP-DB] oddity with insert multiple input fields tomultipletables

2002-08-18 Thread Chip Wiegand
On Sun, 2002-08-18 at 01:20, Joni Järvinen wrote: if (!isnull($date_am || $exercise_am || $reps_am)) then mysql_query($sql_am) or die (Error in this query $sql : .mysql_error()); Try: if(!isnull($date_am) !isnull($exercise_am) !isnull($reps_am)) This should IMO work :) -Joni-

Re: [PHP-DB] oddity with insert multiple input fields tomultipletables

2002-08-18 Thread John Coder
On Sun, 2002-08-18 at 21:21, Chip Wiegand wrote: On Sun, 2002-08-18 at 01:20, Joni Järvinen wrote: if (!isnull($date_am || $exercise_am || $reps_am)) then mysql_query($sql_am) or die (Error in this query $sql : .mysql_error()); Try: if(!isnull($date_am) !isnull($exercise_am)