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 an array then plot from that.
ie get array of values 3,4,5,3,0,3,0,1 etc
work through array checking values each side
if a value is 0. Get the difference and replace
0 with the difference.
Hope that's makes sense. I'm only a beginner
is this area so someone else will probably
have a better way.
On Sat, 2002-08-17 at 15:44, Howard Picken wrote:
> What about setting all fields have a default value, say 0, that
> way you won't have a null but still a zero value.
That would just make the graphs drop to zero for those dates, which
would not look so great. Idealy, pressing submit on the web form would
send only the field(s) with data, and not empty fields.
> -----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
> 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?
> chip w
> [EMAIL PROTECTED]
> (my web server died and the hard drive crashed hard, and is running from
> an incomplete backup on another machine, what a drag) :-(
> 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