RE: [PHP] Querying for MAX

> What I’m trying to do here is not inside PHP nor MySQL books > I have. I need to query the DB to look the max result in a > column. That is, if I have affiliate members with ID going > from 1 to 10, get the query to know that the last member > added was 10 so I can add member 11 without using > auto_increment, because I need to insert old members too > which already have ID numbers. Is that possible? This is really a mysql question rather than a php question and would probably be more appropriate to a mysql list. In any event, if you seriously think auto_increment is not your solution here you probably need to rethink your database design. This is exactly what auto_increment is for. If someone is already in the list then you can get their ID with a select and then do an update on their row, if someone doesn't exist then you add them and ID auto_increments in the process. -- ---------------------------------------------------------------------- Outback Queensland Internet ************************ Longreach ** New Web Site Online * Queensland ************************ Australia W: www.outbackqld.net.au