I know that i can use the mysql function LAST_INSERT_ID() to return the last auto-increment value that was created, but is there a way to specify the table? say if i had a database with 2 tables `foo` and `bar`. an insert was just made into `foo` by user 'a' before that user 'b' made an entry into `bar` now if both users access the database througha website and thuis chances are by the same user name, if i called LAST_INSERT_ID() wouldnt that return user 'a's insert into table `foo`? but what if i wanted to know the last insert id in table `bar`? Any one know?