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)

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

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

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

2002-08-17 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 !== "")