You don't need to provide the value for an auto increment field. "Db_last_insert_id()" is how you get the value after the insert, if you need it at all.
 

Nancy

 

Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.



From: Austin Einter
 
I have a table, where 'cid' field is of type "serial".
 
$lastid = 0;
  for($delta = 0; $delta < $all_companies; $delta++)
  {
 $lastid = db_last_insert_id(rs_companies, cid) + 1;
      db_query(
    'INSERT INTO {rs_companies} ( cid, uid, prevcompany, joindate, releasedate) '
      ."VALUES (%d, '%d', '%s', '%d', '%d')",
 $lastid,