Hi Jeff
to call the last insert id several times make it a variable
$myvariable=mysql_insert_id();
an then use it as needed

Jorge
----- Mensaje original ----- 
De: Jefferis Peterson <jefferis@p...>
Para: professional php <pro_php@p...>
Enviado: Jueves, 24 de Mayo de 2001 07:26 p.m.
Asunto: [pro_php] Another attempt Insert function


> I was just informed that some of mymessages are blank.   I was using a
> BCC for a friend with the TO field as PHP. Hopefully this one will get
> through... 
> 
> "mysql_insert_id(link_id)  returns the ID generated by an Autoincrement
> field in a previous Insert Statement"
> 
> It appears that you can only call this value once, and any other attempts
> to use this function on a single connection and record insert will screw
> things up. How else can you fetch the primary key ID from the current
> record in the current connection?  Since one connection could
> theoretically insert multiple records, what parameters should be used? 
> 
> Jeff
> 
> -- 
> Jefferis Kent Peterson
> www.PetersonSales.net
> Flash, Web Design and Marketing 
> ICQ 19112253