YEP!!! That was exactly what it is. God I feel dumb!!! :) Oh well.
> Hi Kristina: > > On Wed, Apr 02, 2008 at 08:14:06AM -0700, Kristina Anderson wrote: > > > > The ID value is correctly returned and the INSERT string builds > > correctly, so those are not the problems. > ... snip ... > > My > > best guess is that it might be something in the table structure that > > I'm missing, > > I highly doubt that. It's a bug in the code. > > Perhaps the you're mistakenly running the initial SQL insert string again > as the second mysql_query() call? > > Perhpas the column names and values defined in the second SQL string are > misaligned? > > I'd delete all records from the table. Do a save from the web form (or > whatever). Then look at what shows up in the database VERY carefully. > > If that doesn't do it, if you haven't done so already, use your own > function for running the SQL rather than calling mysql_query() directly > throughout the code. Then your central function can have a > logging/debugging option. > > --Dan > > -- > T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y > data intensive web and database programming > http://www.AnalysisAndSolutions.com/ > 4015 7th Ave #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409 > _______________________________________________ > New York PHP Community Talk Mailing List > http://lists.nyphp.org/mailman/listinfo/talk > > NYPHPCon 2006 Presentations Online > http://www.nyphpcon.com > > Show Your Participation in New York PHP > http://www.nyphp.org/show_participation.php > > _______________________________________________ New York PHP Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
