Need 2 auto increment columns?
Posted: Sun Feb 13, 2005 11:09 am
I am new to PHP and MySQL so there maybe a simple solution to this but I dont know
I am designing a hotel booking system and I have 3 tables which I am feeding info into from a form. These are the tables here
I was going to auto increment RoomsBookedID as well but it gives an error saying I can only have one auto inc per table, my problem is that I don't know how to have an auto incremented number for the ID and then how do I copy it across to RoomsBooked table? Or perhaps my tables need some redesign?
Any help is greatly appreciated
I am designing a hotel booking system and I have 3 tables which I am feeding info into from a form. These are the tables here
I was going to auto increment RoomsBookedID as well but it gives an error saying I can only have one auto inc per table, my problem is that I don't know how to have an auto incremented number for the ID and then how do I copy it across to RoomsBooked table? Or perhaps my tables need some redesign?
Any help is greatly appreciated