> 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-
--
// Joni Järvinen
// [EMAIL PROTECTED]
// htt
On Sunday 18 August 2002 13:40, Chip Wiegand wrote:
> Okay, so I tried this -
>
> if ($date_am || $exercise_am || $reps_am !== "")
> {
> $sql_am = "insert into absmachine (today,exercise,reps,comments)
> values ('$date_am','$exercise_am','$reps_am','$comments_am')";
> mysql_query($s
On Sat, 2002-08-17 at 19:49, John Coder wrote:
>
> This may or may not work but what the h***. If you have multiple insets
> commands test for ! isnull() on each input field ,i.e. variable.
>
> if (! isnull($input_field))
> then "insert_query"
>
> as I said this will only work with an insert
> > -Original Message-
> > From: Chip Wiegand [mailto:[EMAIL PROTECTED]]
> > Sent: Sunday, 18 August 2002 7:08 AM
> > To: phpdb
> > Subject: [PHP-DB] oddity with insert multiple input fields to multiple
> > tables
> >
> >
> >
> > I have a web page interface to a mysql database. In this we
On Sat, 2002-08-17 at 17:08, Chip Wiegand wrote:
> I have a web page interface to a mysql database. In this web page I have
> about a dozen form input fields. On submit these are submitted to
> multiple tables, a differant table for each input field. If I leave any
> fields blank, and insert only
Hmmm... OK this may a long way around but if when you
are generating your graph, if the value returned is
then get the next value minus it from the last good
value and store it as a value. Get the last the
last good, minus the calculated value and use that
as the missing value.
Put this all into
