[support] How to get the auto-increment value
Metzler, David
metzlerd at evergreen.edu
Mon Mar 28 18:12:03 UTC 2011
Do not include cid in the insert statement and it should autoincrement for you.
-----Original Message-----
From: support-bounces at drupal.org on behalf of Austin Einter
Sent: Mon 3/28/2011 03:04
To: support at drupal.org; development at drupal.org
Subject: [support] How to get the auto-increment value
Hi All
I have a table, where 'cid' field is of type "serial".
Schema declaration is -> *"'cid' => array('type' => 'serial', 'unsigned' =>
TRUE, 'not null' => TRUE, ),"*
Aim is to have an incremented value for it.
The code is as below
*$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, *
With this, I find this 'cid' field is not auto incrementing. Any idea,
whats the wrong here.
Best Regards
Austin.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 3070 bytes
Desc: not available
Url : http://lists.drupal.org/pipermail/support/attachments/20110328/7c77123b/attachment.bin
More information about the support
mailing list