[SOLVED] Copy auto-increment value to another row on insert

[pfkdesign]

hi guys,

 

i have a problem and i don't know how to solve it  ???  :'(, i would like to copy the value of id (which is auto-increment) to another field on the same table "when i inserting a record".

ex:

| table                |

--------------------    i would like to copy "id" to "c_id" when i insert record

|  id      int A.PK |

|  c_id    int        |

|  label              |

--------------------

 

thank you in advance.

 

[craygo]

look into using mysql_insert_id().

 

Run your insert query, then use mysql_insert_id() to get the id then run an update query to set the id in the c_id field.

 

Ray

[pfkdesign]

hi,

 

so it will be in one inset operation or first i insert then update the form and it will update the field of c_id? ( i would like all in one operation)

 

tnx

[craygo]

$sql = "INSERT INTO `tablename` (`label`) VALUES ('labelname')";
$res = mysql_query($sql) or die(mysql_error());
$id = mysql_insert_id();
$update = "UPDATE `tablename` SET `c_id` = '$id' WHERE `id` = '$id'";
$ures = mysql_query($update) or die(mysql_error());

 

Ray

[pfkdesign]

tnx