Re: oddity with insert multiple input fields to multipletables
| From: | Jason Wong | Date: | Sun, 18 Aug 2002 04:25:40 +0000 |
| Subject: | Re: oddity with insert multiple input fields to multipletables | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-21202@lists.php.net to get a copy of this message | ||
> > -----Original Message-----
> > From: Chip Wiegand [mailto:chip@wiegand.org]
> > 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?
You have to check them before inserting.
if ($value !== "") {
insert_value();
}
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
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.
*/