[Dusan01]

Hi guys, im using mysql r33 so how can i get witch number should now go on my primary key where is enabled AI

[Dusan01]

Done, i used this code:

PHP код:

stock getLastID(what[], &var) {
    mysql_format(MySQL, Query, sizeof(Query), "SELECT MAX(ID)+1 FROM `%s`",what);
    mysql_query(MySQL,Query);
    new rows = cache_get_row_count();
    if(rows) {
        var = cache_get_row_int(0, 0);
    }
    return 1;
} 


[Vince]

Uh, what? The whole point of using auto increment is to generate a unique ID automatically. In an insert statement the ID column need not be specified, or it can be filled with default or null in which case it will also generate a unique ID. The generated value can be retrieved with cache_insert_id().

[Dusan01]

Quote:

Originally Posted by Vince Uh, what? The whole point of using auto increment is to generate a unique ID automatically. In an insert statement the ID column need not be specified, or it can be filled with default or null in which case it will also generate a unique ID. The generated value can be retrieved with cache_insert_id().

Oh yeah i know that, but on loading systems from some reasons want to know what is last AI generated

but i did not know about cache_insert_id, so TNX