vb6+mysql+execute

in vb6 i make insrt's into mysql
like this :

VB Code:

cnMySql.Execute ("insert into xxx (p1) values('aaa')

how can i get the result id of the execution?
(in php there is a function called mysqli_insert_id() which gives me the insert id)
what to do?
thanks in advance
peleg

This is also a function in MySql, so it can be included in a query:

Code:

---

SELECT LAST_INSERT_ID() id;
+----+
| id |
+----+
|  5 |
+----+

---

first thnaks alot it works!!!
second when i want fro example to do a select syntax i do :

VB Code:

With rdoQry
 
    .SQL = "select * from tbl1"
    .RowsetSize = 1
    Set .ActiveConnection = cnMySql
    Set rdoRS = .OpenResultset(rdOpenKeyset, rdConcurRowVer)
End With

the thing is if i after few rows of code want to do another select syntx like :

VB Code:

With rdoQry
 
    .SQL = "select * from orders"
    .RowsetSize = 1
    Set .ActiveConnection = cnMySql
    Set rdoRS = .OpenResultset(rdOpenKeyset, rdConcurRowVer)
End With

it fails!
why is that?
thnaks again
Peleg