NYCPHP Meetup

NYPHP.org

[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