Re[2]: [PHP] selecting one item at a time from mysql

Hello scottrus, Sunday, September 17, 2000, 6:40:26 AM, you wrote: sin> Maybe if you add another col to your ipaddr table you can do what sin> you want. Call the column 'ipstate' and give it a value of 0-2. sin> 0 = not in use sin> 1 = in use sin> 2 = active config sin> When I user first requests and IP select all the ip's where state sin> is 0. Take the first one off the top and set it to state = 2 meaning sin> a user is about to check it out. I like your first idea with second col . I don't have to worry about a user accessing this script it runs at the command line at root run by cron every 15 min. I guess my next question is how do I implement this process. What would the mysql process look like. -- Best regards, Richard mailto:rkurth@pacifier.com