Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Inserting "Auto-Increment" into a Table

Quote Reply
Inserting "Auto-Increment" into a Table
Hiya!

I am adding a mod to my site, I have a new table (called "Related") which will have related links to the subject. (For those of you who think it is strange, you have to know my site, which does NOT have Links in it, really...)

Anyway, everything is fine, I am insert using this command:

In Reply To:
$relate_db->add (
Category => $category,
URL => $url,
Date => $today,
User => $user_name,
Validate => 'No',
Site_Name => $site_name
My problem is, I am not sure how to deal with an auto incriment field. I set one up when I created the table, and then tried to just insert as above, and it did not work. Drop the auto-incriment, no problem.

I need the unique auto-incriment field; how do I deal with that?

tia!

Dave

Subject Author Views Date
Thread Inserting "Auto-Increment" into a Table carfac 3394 Jul 31, 2001, 4:37 PM
Post Re: Inserting "Auto-Increment" into a Table
carfac 3263 Jul 31, 2001, 5:51 PM
Thread Re: Inserting "Auto-Increment" into a Table
pugdog 3282 Jul 31, 2001, 5:57 PM
Thread Re: Inserting "Auto-Increment" into a Table
carfac 3308 Jul 31, 2001, 8:55 PM
Thread Re: Inserting "Auto-Increment" into a Table
pugdog 3285 Aug 1, 2001, 12:22 AM
Thread Re: Inserting "Auto-Increment" into a Table
carfac 3274 Aug 1, 2001, 10:16 AM
Thread Re: Inserting "Auto-Increment" into a Table
pugdog 3251 Aug 1, 2001, 2:26 PM
Thread Re: Inserting "Auto-Increment" into a Table
carfac 3239 Aug 1, 2001, 3:07 PM
Thread Re: Inserting "Auto-Increment" into a Table
carfac 3253 Aug 1, 2001, 3:26 PM
Thread Re: Inserting "Auto-Increment" into a Table
Alex 3222 Aug 1, 2001, 3:44 PM
Post Re: Inserting "Auto-Increment" into a Table
carfac 3234 Aug 1, 2001, 4:13 PM