I've got 2 tables in a databse, which I want to update at the same time...

In one table, I have an "ID" field, which is UNIQUE...

I know that if I add the record with a '' (null) information for the
ID, then the ID field will be numbered with a new ID..

however, I need to add information to the second table, which includes
the same "new" ID as in the 1st table...

Apart from doing a new 'select' query - Is there a quick way of
identifying the new ID number, & updating the 2nd table at the same
time ?


--
G
Yahoo Archives by email = Yes
http://groups.kwister.com/owners.php#add
NZ community groups - [EMAIL PROTECTED]


Community email addresses:
  Post message: [email protected]
  Subscribe:    [EMAIL PROTECTED]
  Unsubscribe:  [EMAIL PROTECTED]
  List owner:   [EMAIL PROTECTED]

Shortcut URL to this page:
  http://groups.yahoo.com/group/php-list




SPONSORED LINKS
Php mysql Job postings


YAHOO! GROUPS LINKS




Reply via email to