On Sun, 26 Oct 2003 13:40:20 +0000, dan wrote:
> The MAX(id) didn't return anything [...]
Are you sure about that? Generally, MAX(id) _always_ returns something,
ie:
SELECT MAX(user_id) FROM user
This one will return the highest 'user_id' value, _or_ 0 if there are no
records in the 'user' table.
> SELECT id FROM memodata ORDER BY id DESC
Then you should also limit the expression, thus offloading the SQL server
a bit;
SELECT id FROM memodata ORDER BY id DESC LIMIT 1
> then take the first line value and ignore the rest.
With 'LIMIT' you don't need to worry about ignoring anything. Just ignore
ignoring. :-)
> Ideally though i want the last line with the highest id number.
If you want the last auto_increment value, you could always use the MySQL
proprietary 'mysql_insertid';
my $stInsert = $dbh->prepare( ... );
$stInsert->execute();
$stInsert->finish();
my $last_insert_id = $stInsert->{ 'mysql_insertid' };
> I know for a fact that another INSERT won't happen before the SELECT
> because they happen immediately one after the other.
Do yuo really? Is there _always_ only one user using the script?
--
Tore Aursand <[EMAIL PROTECTED]>
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
