> 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

Outback Queensland Internet                   ************************
Longreach                                     ** New Web Site Online *
Queensland                                    ************************
Australia                                     W: www.outbackqld.net.au

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to