| 
	
 | 
 Posted by casper christensen on 11/17/06 14:19 
Please do me a favour and try to add a link at my site, then you'll see 
what I need and you might be able to help me 
 
http://www.affiliatesjunction.net/directory.php?ax=add 
This will take you to the form 
 
 
casper 
 
 
Jerry Stuckle skrev: 
> casper christensen wrote: 
> > Well 
> > 
> > Using the insert tag, it returns the value"0", any idea why. Obviously 
> > it doesnt get the last inserted id (tried Last_insert_id.. too) 
> > 
> > casper 
> > 
> > Jerry Stuckle skrev: 
> > 
> >>casper christensen wrote: 
> >> 
> >>>I'm not asking you or anyone to go throught the entire code to find a 
> >>>bug. There is no bug! 
> >>>I need to know how to fetch the created Id. The must be some "standard" 
> >>>code to get "load" values from the database. 
> >>> 
> >>>casper 
> >>> 
> >> 
> >>I'm not sure what you mean by fetch the "created id".  Are you talking 
> >>about after your user adds a new row to the table?  If that's the case, 
> >>see http://www.php.net/manual/en/function.mysql-insert-id.php. 
> >> 
> >>But you're also not using "standard" MySQL functions.  MySQLQuery is not 
> >>a PHP function.  The one defined in PHP is mysql_query.  I have no idea 
> >>what your function is doing. 
> >> 
> >>-- 
> >>================== 
> >>Remove the "x" from my email address 
> >>Jerry Stuckle 
> >>JDS Computer Training Corp. 
> >>jstucklex@attglobal.net 
> >>================== 
> > 
> > 
> 
> First of all, does the table have an autonumber column?  Since you were 
> looking for an ID, I suspected it did, but my assumption may be wrong. 
> 
> Also, did you call it after making the insert, using the same connection 
> as the INSERT (and without closing the connection)? 
> 
> -- 
> ================== 
> Remove the "x" from my email address 
> Jerry Stuckle 
> JDS Computer Training Corp. 
> jstucklex@attglobal.net 
> ==================
 
  
Navigation:
[Reply to this message] 
 |