Page 3 of 4
Posted: Thu Dec 14, 2006 9:21 am
by mohson
neel_basu wrote:So I Think You have Understood Whats The Actuall Error
That cant be the problem because a value is being assigned.
Posted: Thu Dec 14, 2006 9:28 am
by neel_basu
Thats Because its for auto_increment on That Field In MySQL Table
Although You Are Not Passing Any Value Through $org_id MySQL Is Being Incremented Automatically By MySQL (Not By php) When Other values Are being Inserted
Posted: Thu Dec 14, 2006 9:30 am
by mohson
Ok So how should I fix this?
Posted: Thu Dec 14, 2006 9:33 am
by neel_basu
you Have To Use A SQL Command To Get The Leatest Value Of $org_id Through SELECT
Posted: Thu Dec 14, 2006 9:33 am
by mohson
Ok Now I understand. if I remove org ID from the process file it will still auto increment the ID as this is being done by MYsql and NOT PHP.
Is there any way around this problem, still using your method?
Posted: Thu Dec 14, 2006 9:38 am
by neel_basu
neel_basu wrote:you Have To Use A SQL Command To Get The Leatest Value Of $org_id Through SELECT
Posted: Thu Dec 14, 2006 9:39 am
by mohson
How, can you demonstrate? on my code?
Posted: Thu Dec 14, 2006 9:44 am
by neel_basu
Ok Tell Me Which 1 Of This fields Are Unique And Not Being Auto Increamented
org_id, person_id, orgname, web_url, notes
Posted: Thu Dec 14, 2006 9:46 am
by mohson
only org_id is being auto incremented
Posted: Thu Dec 14, 2006 9:47 am
by neel_basu
And Which One Is Unique ??
Posted: Thu Dec 14, 2006 9:52 am
by mohson
org_ID is being auto incremenetd ad is the ID therefore it is the unique filed all the other fields are manually entered
Posted: Thu Dec 14, 2006 9:58 am
by neel_basu
Are There Any Fields That Are Unique But Not Being Auto Increamented
Posted: Thu Dec 14, 2006 10:21 am
by mohson
only org_id is being auto incremented and it is also the primary key
Posted: Thu Dec 14, 2006 11:11 am
by neel_basu
Then Can I Assume That
person_id, orgname, web_url, notes Are All Unique Fields ??
Posted: Thu Dec 14, 2006 11:16 am
by RobertGonzalez
Can you do a
Where myTableName is the name of the table we are talking about? There is entirely too much ping-ponging going on with this.