MySql should insert a value into that column when you update if you are using an 
auto_increment field.  this value will always be unique.  period.
 
-Chris

        -----Original Message----- 
        From: Chad Day [mailto:[EMAIL PROTECTED]] 
        Sent: Wed 2/19/2003 1:16 PM 
        To: php general 
        Cc: 
        Subject: [PHP] problem with mysql / auto increment fields.. ?
        
        

        On my website there are a couple places where people can sign up ..
        
        The querys after the sign up process look like
        
        $blahblah = query(insert firstname lastname) values (blah blah blah)
        $userid = mysql_insert_id($blahblah);
        
        $insertintoothertable = query(userid, blah blah blah) etc.
        
        it then uses this userid var to insert them into a variety of other tables
        for other things on the site, such as a phpBB account, etc.
        
        if multiple people are signing up for accounts at different places, is there
        the possibility that a duplicate userid could be assigned, or anything like
        that?
        
        Thanks,
        Chad
        
        
        --
        PHP General Mailing List (http://www.php.net/)
        To unsubscribe, visit: http://www.php.net/unsub.php
        
        



Reply via email to