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
