Same ID on both tables !

[perrohunter]

Hi, im having a problem, i want a query to make a registry on 2 diff tables, everything goes fine till the id gets to be the same number.

I was wondering if somebody knows a query to read the las ID number , copy it and then add 1.

thanks for your time

[devinemke]

what are trying to do exactly? if you want two related tables then you must use the primary key field from on table as the foreign key in the other table.

[perrohunter]

exactly

but what if both tables have different keys , what i need is to read the last record, extract it, add 1 to it, then write that on the next

but i dont have a clue which query could do that :S

[bpat1434]

perhaps: [man]mysql_insert_id[/man]

~Brett

[perrohunter]

did work 🙁

Ive tryed something like

$result=mysql_query('SELECT id FROM table ORDER BY id desc LIMIT 1;')

//that select the last record

while($r=mysql_fetch_array($result))
{

  $id=$r["id"];

//extract it to a array

$newid=$id+1

//add it 1

mysql_query('INSERT INTO table ($newid, etc...

what am i doig wrong ? :S ! !