Re: oddity with insert multiple input fields to multipletables
| From: | Chip Wiegand | Date: | Mon, 19 Aug 2002 01:21:41 +0000 |
| Subject: | Re: oddity with insert multiple input fields to multipletables | ||
| References: | 1 2 3 4 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-21221@lists.php.net to get a copy of this message | ||
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-
I was looking at the php manual and noticed the function is actually
is_null, not isnull. Yet it still does not work, I tried this:
$sql_am = "insert into absmachine (today,exercise,reps,comments)
values
('$date_am','$exercise_am','$reps_am','$comments_am')";
if(!is_null($date_am))
mysql_query($sql_am) or die ("Error in this query >>$sql<< : "
.mysql_error());
And it still inserts the row no matter what, as long as submit is
pressed a row is written, with or without any data.
--
Chip