Posted by Jeff North on 11/17/06 07:13

On 16 Nov 2006 18:07:37 -0800, in comp.lang.php "casper christensen"
<tjenpengemensdusover@gmail.com>
<1163729257.158721.161250@e3g2000cwe.googlegroups.com> wrote:

>| Hi
>|
>| When someone fills the form on my site, and id is created in my
>| database. (see below)
>|
>| http://www.affiliatesjunction.net/directory.php?ax=out&id=XXX
>|
>| after submitting the form they are directed to a "thank you page". Now
>| I need to show the above link in a textfield with the newly created id.
>|
>| How can I "fetch" this id from the database.?
>|

I presume that id is a primary key with auto_increment.

Once you've saved the record use last_insert_id() to return the newly
inserted PK. Then you can redirect to your next page using that
information.
---------------------------------------------------------------
jnorthau@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------

• Next in forum: Re: Database class allowing saving data to (XML?) file
• Prev in forum: Re: what is the easiest way to compare strings for alphabeticalness?
• Thread view: Re: How to "fetch" a certain id

[Reply to this message]