I have been racking my brain today, trying to get a page to run 2 queries.
Basically i have a page that has a form on it and there is a bunch of numbers in one of the drop down lists that comes from a table called cab_eticket_numbers this and the rest of the data on this form is posted to a MySQL table called cab_details, which works all good. However I also need to update a flag in the cab_eticket_numbers table called cab_eticket_used so that the number does not come up in the drop down list again.
Can someone please advise how you would do this? I have checked out google and found a few things (such as http://www.artfulsoftware.com/infotree/tip.php?id=799) however dont seem to make much sense, i feel there has to be a better way as i thought this would be a rather common scenario?
Any help would be much appreciated, maybe even if i could use the same query that i use to do the INSERT if i cant have 2 queries.
Any help would be much appreciated.
Thanks very much in advance.