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) Quote 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() Quote 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? Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.