NYCPHP Meetup

[Kristina Anderson]

114   jkljlk tyuti ttyut tyutu 0 NULL 0 [0 NULL ]
113   jkljlk tyuti ttyut tyutu 0 NULL 0 0 NULL 

Last two fields in row 114 s/b "113"....but.

Query as follows looks OK to me...

INSERT INTO who_we_are SET eid=113,eid2='113', empname ='jkljlk', 
title='tyuti', bodytext='ttyut tyutu', picture='' 

> Hi Kristina:
> 
> On Tue, Apr 01, 2008 at 07:57:48PM -0700, Kristina Anderson wrote:
> > I'm pulling out the ID of the previously inserted row and then 
> > inserting that as a lookup value in a duplicate row (two rows one 
for 
> > edit mode one for published mode).
> > 
> > Various other places in the app this works fine and there really 
isn't 
> > any reason this should be happening.
> > 
> > The query runs fine if I do it from within phpMyAdmin -- but from 
the 
> > PHP page the query does not error out but the value in the lookup 
field 
> > remains the default value
> 
> You say you're using "mysql_insert_row."  I assume you mean PHP's 
> mysql_insert_id() function.  If so, there are two possible bugs that 
come 
> to mind.
> 
> 1) The table in question does not have auto_increment set for the 
primary 
> key on that table.  If that's not it...
> 
> 2) The PHP code has a bug...
> 
> You say this same logic works on other parts of the site.  So, do the 
> various parts of the site use the _same_ _exact_ 
files/lines/functions or 
> do you have separate function/include/whatever for each section of 
the 
> application?
> 
> If you're using separate code for different sections, obviously the 
PHP 
> code you're using for the problematic insert is where the bug is.  
> Perhaps the variable you assign the id to is different than the 
variable 
> you're using as the lookup value in the second query.
> 
> Again, if you're using separate code, you should refactor the system 
to 
> allow you to use the same code for the same purpose throughout the 
> system.
> 
> --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
> 
>