Hi guys,
I have come accross a small problem while trying to convert a java program to a PHP 
my database table is like so

cno (int)
name (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

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 
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.

Reply via email to