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 !== "") { $sql_am = "insert into absmachine (today,exercise,reps,comments) values ('$date_am','$exercise_am','$reps_am','$comments_am')"; mysql_query($sql_am) or die ("Error in this query >>$sql<< : " .mysql_error()); } and this - $sql_am = "insert into absmachine (today,exercise,reps,comments) values ('$date_am','$exercise_am','$reps_am','$comments_am')"; if ($date_am || $exercise_am || $reps_am !== "") { mysql_query($sql_am) or die ("Error in this query >>$sql<< : " .mysql_error()); } But I still get empty rows inserted into the tables. -- Chip > > > -----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 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 some of the fields, the database will > > > insert an empty row to all the effected tables that didn't have any data > > > from the input fields. > > > > > > > > > I have another page that generates graphs from the tables, the empty > > > rows show up as breaks in the graphs lines, if I manually delete all the > > > empty rows the graphs work fine. > > > > > > > > > > > > What do I need to do to prevent these empty rows from being written to > > > the tables? > > Open Source Software Systems Integrators > * Web Design & Hosting * Internet & Intranet Applications Development * > > > /* > Between grand theft and a legal fee, there only stands a law degree. > */ > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php