RE: [PHP] Challenging problem for you programing gurus...

ALTER TABLE your_table CHANGE COLUMN old_column_name new_column_name NOT NULL AUTO_INCREMENT PRIMARY KEY; Then use mysql_insert_id() in your PHP code to retrieve the ID that is generated upon INSERTs. ---John Holmes... > -----Original Message----- > From: Ryan A [mailto:r@jumac.com] > Sent: Saturday, September 28, 2002 12:17 PM > To: php-general@lists.php.net > Subject: [PHP] Challenging problem for you programing gurus... > > Hi guys, > I have come accross a small problem while trying to convert a java program > to a PHP one.... > my database table is like so > > ************* > cno (int) > name (varchar) > lastname(varchar) > etc etc > ************* > > as you can see the details I take is name/lastname and customer number > (cno) is automatically generated, now instead of using a "auto increment" > a "int" was declared and this code was used > > ************************** > synchronized(this) > { > rs=stmt.executeQuery("select max(cno)+1 from cust"); > } > ************************** > > (for those of you who dont understand java) > the "synchronized" keyword makes sure only one thread can work in the > "block" of code between the "{" and "}" then it executes the > query "select > max(cno)+1 from cust" and stores the result in an array (like PHP) in > "rs". > > Basically, it just gets the next higher cno from the table cust. > > Then it enters the cno like this rs=cno,then name,lastname etc and then > tells the customer that the data has been entered and his new customer > number is <rs>. > > > As you can see its a pain in the ass job which has to be changed, > the problem is a few hundred records have already been entered, > how do i use the current table BUT use the more useful auto increment and > LAST_INSERT_ID() via PHP? > The java servlet program which is handleing the requests is working fine, > but I am want to convert it to a PHP program as paying for servlet hosting > is upto 5-8 times more...and I aint rich, or even close to being rich :-( > > > Please reply, > ANY help appreciated and thanks in advance. > Cheers, > -Ryan.