AW: [PHP-DB] getting data back when inserting
| From: | Stefan | Date: | Wed, 01 Dec 2004 18:20:07 +0000 |
| Subject: | AW: [PHP-DB] getting data back when inserting | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-37516@lists.php.net to get a copy of this message | ||
The actual problem was the leading number in some of your arguments
(4_h_1, 4_h_2, etc....)
Stefan
> -----Ursprüngliche Nachricht-----
> Von: Aaron Todd [mailto:aaloki88@hotmail.com]
> Gesendet: Mittwoch, 1. Dezember 2004 18:33
> An: php-db@lists.php.net
> Betreff: Re: [PHP-DB] getting data back when inserting
>
> Thanks a bunch...thats exactly what I was looking for.
>
> Aaron
>
>
> "Stefan" <phpmail@nw-server.de> wrote in message
> news:20041201162942.9BF6690140@wersten.nw-server.de...
> You should easily use
>
> mysql_insert_id();
>
> otherwise you could use something like:
>
> SELECT max(id) FROM ...
>
> But I think the first command is what you're looking for.
>
> Stefan
>
>
> > -----Ursprüngliche Nachricht-----
> > Von: Aaron Todd [mailto:aaloki88@hotmail.com]
> > Gesendet: Mittwoch, 1. Dezember 2004 17:01
> > An: php-db@lists.php.net
> > Betreff: [PHP-DB] getting data back when inserting
> >
> > I was wondering if somone might be able to suggest a command to me...I
> am
> > inserting data into a MySQL database that has an auto-incrementing
> primary
> > field. When I insert the data I would like to somehow get the value of
> > the
> > auto-incrementing primary field. I thought I could just run a SELECT
> > statement on some of the data that I am inserting, but the problem is
> that
> > it could have a duplicate already in the database.
> >
> > Anyone know of a command or something to point me in the direction I am
> > looking to go?
> >
> > Thanks,
> >
> > Aaron
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php