Hi guys,
I have 2 tables, namely ‘test_suite’ and ‘test_case’. The test_suite contains an testsuiteID which is the primary key of the table and will auto increment with each row inserted. After an insertion, I want to retrieve the testsuiteID of the newly inserted row, and insert it into the test_case table. How can I achieve that? Anyway, I am not using any functions or stored procedures in mysql. All commands are executed on-the-fly via the ‘mysql_query’ command in php. Any help would be greatly appreciated. Thanks in advance.