View Full Version : Pear php: getting next id in mysql db

06-06-2005, 03:14 PM
I have a table using auto_increment for id(lots of rows there already). And now i started using pear for db queries++ instead of usual php. But here came a problem. I need to get inserted row id and pear dont have anything like mysql_insert_id, although it has nextId(). But nextId() uses some sequence and as i understand if i start using it, ids will start from 1 and increment after each call. But i already have over 100k rows in it and so it would ruin pretty everything if ids starts going from 1 again. Is there any way to continue incrementing ids with pear?