delt Posted May 6, 2007 Share Posted May 6, 2007 I have a database for storing the information of documents that users upload. I'm organizing the new entries by ID numbers (as traditionally done). When creating a new row, I'm having difficulty getting the last ID/highest ID so I can add 1 for the new ID of the new row. The code that I've been trying to fix (below) does well until I get to the 10th ID. After that, it recognizes "9" as the largest ID. $result = mysql_query("SELECT * FROM resources ORDER BY resource_id DESC"); $current = mysql_fetch_array($result); $id = $current[resource_id] + 1; How can this be resolved or what way would be better for performing this task? Thanks! (MySQL version 4.1.21) Link to comment https://forums.phpfreaks.com/topic/50285-getting-the-highest-value-then-adding-1/ Share on other sites More sharing options...
bubblegum.anarchy Posted May 7, 2007 Share Posted May 7, 2007 mysql_insert_id() Link to comment https://forums.phpfreaks.com/topic/50285-getting-the-highest-value-then-adding-1/#findComment-246935 Share on other sites More sharing options...
Wildbug Posted May 7, 2007 Share Posted May 7, 2007 Are you using an AUTO_INCREMENT column? Link to comment https://forums.phpfreaks.com/topic/50285-getting-the-highest-value-then-adding-1/#findComment-247255 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.