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 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?
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))
as I said this will only work with an insert query for each field.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php