Re: INSERT confirmation? PHP

2002-12-16 Thread Giannis Vrentzos
Steve Lefevre wrote: I'm designing a user database for PHP 4 and MySQL 3.32 or whatever. Users enter a class and it's workshops for their students. The 'Class' table has fields 'Name' and 'ID'. ID is the primary key and its an auto-incremented integer The 'Workshop' table has a field ID,

Re: INSERT confirmation? PHP

2002-12-16 Thread Giannis Vrentzos
Steve Lefevre wrote: I'm designing a user database for PHP 4 and MySQL 3.32 or whatever. Users enter a class and it's workshops for their students. The 'Class' table has fields 'Name' and 'ID'. ID is the primary key and its an auto-incremented integer The 'Workshop' table has a field ID,

RE: INSERT confirmation? PHP

2002-12-15 Thread Roger Davis
Lefevre; [EMAIL PROTECTED] Subject: Re: INSERT confirmation? PHP Peter Lovatt wrote: mysql_insert_id should do it! According to documentation somewhere, last insert can sometimes return a different value than the most recent insert if the most recent insert failed. What is a better solution

RE: INSERT confirmation? PHP

2002-12-14 Thread Peter Lovatt
hi mysql_insert_id http://www.php.net/manual/en/function.mysql-insert-id.php should do it! Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel.

Re: INSERT confirmation? PHP

2002-12-14 Thread Michael T. Babcock
Peter Lovatt wrote: mysql_insert_id should do it! According to documentation somewhere, last insert can sometimes return a different value than the most recent insert if the most recent insert failed. What is a better solution? -- Michael T. Babcock C.T.O., FibreSpeed Ltd.

Re: INSERT confirmation? PHP

2002-12-14 Thread Paul DuBois
At 20:08 -0500 12/14/02, Michael T. Babcock wrote: Peter Lovatt wrote: mysql_insert_id should do it! According to documentation somewhere, last insert can sometimes return a different value than the most recent insert if the most recent insert failed. Why is this a problem? If the most