[nycphp-talk] Bizarro Bug trying to insert after using mysql_insert_row
Kristina Anderson
ka at kacomputerconsulting.com
Wed Apr 2 11:36:55 EDT 2008
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
>
>
More information about the talk
mailing list