on my case I use fetch an work fine;

Jorge
----- Mensaje original -----
De: Jefferis Peterson <jefferis@p...>
Para: professional php <pro_php@p...>
Enviado: Jueves, 24 de Mayo de 2001 07:42 a.m.
Asunto: [pro_php] Re: proper syntax for UPDATE?


> I am wondering if I should be using the insert id command here to
> ascertain the current value of the record.   Is this the value of the
> current connection as is written to the database? Or should I be using a
> fetch to get the primary key, which is the userid?
>
> >$userid = mysql_insert_id($con);
> >$username= (trim($username1) + $userid);
> >$password = $id
>
> >
> >UPDATE users SET username = '$username' WHERE userid = '$userid';
>
> Somehow I am getting the correct new member id sent to me by what
> follows, without a query:
>
>   >  file://send email to user_validator to get them to validate new user.
> >    $msg = sprintf("A new customer has submitted their information. Log
> >into back-end
> >database and authorize userid ".strval(mysql_insert_id($con)).".
>   >  mail($g_uservalidator_email,"New Customer Submission -
Validate",$msg);
>
> >correct sintax for UPDATE
>
> --
> Jefferis Kent Peterson
> www.PetersonSales.net
> Flash, Web Design and Marketing
> ICQ 19112253
> _______
> "Happy is the person who finds wisdom, and the one who gets
> understanding, for the gain from it is better than gain from silver and
> its profit better than gold."  - Proverbs 3:13,14.
>
>