Hey John,
Thanks for the reply,
Am a bit confused, 2 guys already gave me the advise you are giving me but
you also say
CHANGE COLUMN old_column_name new_column_name
why to change the column name? dont I only have to change it from being an
int to an Auto_Increment?
Kindly reply,
Cheers,
-Ryan.
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:[EMAIL PROTECTED]]
Sent: Saturday, September 28, 2002 12:17 PM
To: [EMAIL PROTECTED]
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.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php