mysql_insert_id or fbsql_insert_id ??

[Anon]

Ok, first of all whats the difference between these two and secondly are they correct for my needs?

I have three tables:
1. stores details of problems logged with one record per problem.

2. stores details of one or more categories (i.e. email, network, etc.)associated to each problem record.

3. holds a list of categories, one category per record.

I've got 'sid' as the primary key for the problem table and 'sid' & 'category' in the associated table (no primary).

What I'd like to do is insert the data into the problem table(1), then insert the related categories into the associated table(2). What I cant work out is how to ensure the same ID is consistent for both tables.

I've come accross mysql_insert_id and it seems appropriate for retrieving the ID of the last record inserted. However, there was no example of script, so how do you use it?

[[deleted]]

The main difference is that one is mysql and the other is for frontbase, so the questin "which one should I use" is irrelevant.

"I've come accross mysql_insert_id and it seems appropriate for retrieving the ID of the last record inserted. However, there was no example of script, so how do you use it?"

Did you read the description in the manual?

[Anon]

ok I didn't know about front base. I found both of these mentioned in the php online manual. but examples of use are, shall we say, brief.

the example states: mysql_inser_id(MYSQL)

Am I correct in thinking that MYSQL is the name of the result from the query? or is it the table name? or what?

Thanks again

[[deleted]]

The PHP manual does not say

mysql_inser_id(MYSQL)

it says:

int mysql_insert_id ( [resource link_identifier])

which means you should use it like this:

$iNewID = mysql_insert_id($rDatabaseConnection);

Read the annotations, and use google to get more examples.