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
> ==================

[Back to original message]