andy7t
User
Feb 19, 2004, 10:52 AM
Post #1 of 2
(379 views)
|
|
MySQL- What was the autonumber
|
Can't Post
|
|
Hello,
This is my SQL:
$SQL="INSERT into `tickets` (attachedto,poster,time,date,subject,message,priority,name,email,url,username)
VALUES ('0','$login','$time','$date','$indata{'subject'}','$indata{'message'}','$indata{'priority'}','$indata{'name'}','$indata{'email'}','$indata{'url'}','$indata{'username'}')
";
Now, in fact, before ATTACHEDTO, there is also: id.
This id is an autoincrement and it adds 1 to the last one.
The script is from a online ticket program, and i need to find out what the ID was, so i can say:
Thanks. The ticket has been logged: ID: 21235
etc
Thanks
|
MAIN
SEARCH
WHO'S 
LOG 