Id like a little advise if possible. I have a MySQL database. Say I have job_id as an auto increment. Im trying to access this database via a the net using PHP. What I would like is when somebody adds a record the next number on job_id would automatically be set.
I know that in oracle you select next.val from dual or something like that with the PHP. Im not sure how to go about this using PHP and MySQL. Im rather new to both.
Any advise or direction would be most appreciated.
Could you be little more clear with this
"What I would like is when somebody adds a record the next number on job_id would automatically be set. "
Where do u want to set the next job_id?
If you want to run another query after this and want to store the next no in it then you could use mysql_insert_id() this will return the value if the auto incremented value is generated for the previous query.. You can add '1' to it to ge the next no .
If this is not ur solution please made the above (the quoted one) statment little more clear