RE: [PHP] John Holmes->Re: [PHP] Challenging problem for you programing gurus...

2002-09-28 Thread John W. Holmes
> 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"? Yes. That'

[PHP] John Holmes->Re: [PHP] Challenging problem for you programing gurus...

2002-09-28 Thread Ryan A
gt; > -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 accro

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

2002-09-28 Thread John W. Holmes
TECTED]] > 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 li

[PHP] Chris,Matt->Re: [PHP] Challenging problem for you programing gurus

2002-09-28 Thread Ryan A
Thanks guys, I thought it would be much more complicated than that but will look into the alter table thing. Sorry forgot to mention in the first mail, I am using MySql as its the cheapest database to get from a hosting company,otherwise on my personal machine I use MySql and/or Oracle 7.3 (pirate

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

2002-09-28 Thread Matt
>Chris Shiflett wrote: > I didn't catch which database you are using, but you can alter a field > in MySQL to add the auto_increment characteristic. Look into the "alter > table" SQL statement. And if you do that, there won't be any trouble with the existing IDs. mysql will grab the next highe

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

2002-09-28 Thread Chris Shiflett
I didn't catch which database you are using, but you can alter a field in MySQL to add the auto_increment characteristic. Look into the "alter table" SQL statement. Happy hacking. Chris Ryan A wrote: >how do i use the current table BUT use the more useful auto increment and >LAST_INSERT_ID(

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

2002-09-28 Thread Ryan A
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 autom