[PHP + MYSQL] primary key start at 5000?

DylanButler · 01-30-2007, 12:00 PM

Hi people,

Can someone turn this into a function for me?

PHP Code:

          if ($row[authcode] != $_POST["authcode" . $counter]) {

 
            $row[authcode] = $_POST["authcode" . $counter]; // authcode . $counter is the name of the input / select option that has been modified.

 
            $newauthcode = $row[authcode];

????: NamePros.com http://www.namepros.com/programming/288113-php-mysql-primary-key-start-5000-a.html
 
            $sql = "UPDATE `order` SET authcode='$newauthcode' WHERE id='$row[id]'";

 
            mysql_query($sql);

????: NamePros.com http://www.namepros.com/showthread.php?t=288113
 
        }

This function should allow me to update any field from the $row array easier. Is this the best way to update fields? I did it this way so that if nothing is updated on 95% of the tables, then the query won't be run for them.

View the entire page source here:
http://www.dylanbutler.com/client/oa...ew_orders.phps

You'll see I've got 4 different user levels (0 - 3).

Level 0 users see the least amount of items, whereas an administrator (level 3) can modify / delete pretty much anything.

Please simplify lines 519-613 into a usable function so I can just plug in the row names rather than the whole logic over and over again.

Does this make sense?

Matthew. · 01-30-2007, 12:38 PM

You can do it by manually editing each inserted ID however that's not the best way like you say.

My advice is to go into phpmyadmin, go to the chosen database/table (orders), go to operations and change the "auto_increment" value to 5000.

That should start it off at 5000 like your require without any script adjustments.

As for the second question, im not 100% sure of what you are asking so ill leave it

Matt

sdsinc · 01-30-2007, 12:41 PM

If you want the ID field to increment with a value different than 1 you can use a custom CREATE TABLE statement like this:

Code:

CREATE TABLE #### (
...
  PRIMARY KEY  (####)
) AUTO_INCREMENT=5000 ;

DylanButler · 01-30-2007, 12:48 PM

Thanks both of you guys for your faster than fast response. That worked perfect. I've got one more problem and I've posted my source code and the objective for that one if you don't mind. I really appreciate it guys and +REP added!

01-30-2007, 12:00 PM	THREAD STARTER #1 (permalink)
DylanButler NamePros Regular Join Date: Jan 2006 Location: San Diego, CA Posts: 734	[PHP + MYSQL] primary key start at 5000? Hi people, Can someone turn this into a function for me? PHP Code: if ($row[authcode] != $_POST["authcode" . $counter]) { $row[authcode] = $_POST["authcode" . $counter]; // authcode . $counter is the name of the input / select option that has been modified. $newauthcode = $row[authcode]; ????: NamePros.com http://www.namepros.com/programming/288113-php-mysql-primary-key-start-5000-a.html $sql = "UPDATE `order` SET authcode='$newauthcode' WHERE id='$row[id]'"; mysql_query($sql); ????: NamePros.com http://www.namepros.com/showthread.php?t=288113 } This function should allow me to update any field from the $row array easier. Is this the best way to update fields? I did it this way so that if nothing is updated on 95% of the tables, then the query won't be run for them. View the entire page source here: http://www.dylanbutler.com/client/oa...ew_orders.phps You'll see I've got 4 different user levels (0 - 3). Level 0 users see the least amount of items, whereas an administrator (level 3) can modify / delete pretty much anything. Please simplify lines 519-613 into a usable function so I can just plug in the row names rather than the whole logic over and over again. Does this make sense? __________________ -Dylan Butler EXAMP - San Diego Web Design Last edited by DylanButler; 01-30-2007 at 12:50 PM.

01-30-2007, 12:38 PM	#2 (permalink)
Matthew. Senior Member Join Date: Dec 2006 Location: England Posts: 1,565	You can do it by manually editing each inserted ID however that's not the best way like you say. My advice is to go into phpmyadmin, go to the chosen database/table (orders), go to operations and change the "auto_increment" value to 5000. That should start it off at 5000 like your require without any script adjustments. As for the second question, im not 100% sure of what you are asking so ill leave it Matt __________________ University Grade Calculator juegosjuegos Your Hotel in Austria Matratzen

01-30-2007, 12:41 PM	#3 (permalink)
sdsinc Domains my Dominion Join Date: Aug 2005 Location: Web 1.0 Posts: 9,963	If you want the ID field to increment with a value different than 1 you can use a custom CREATE TABLE statement like this: Code: CREATE TABLE #### ( ... PRIMARY KEY (####) ) AUTO_INCREMENT=5000 ; __________________ NameNewsletter.com - free lists of available domain names ZoneFiles.net (beta) - ccTLD and gTLD droplists

01-30-2007, 12:48 PM	THREAD STARTER #4 (permalink)
DylanButler NamePros Regular Join Date: Jan 2006 Location: San Diego, CA Posts: 734	Thanks both of you guys for your faster than fast response. That worked perfect. I've got one more problem and I've posted my source code and the objective for that one if you don't mind. I really appreciate it guys and +REP added! __________________ -Dylan Butler EXAMP - San Diego Web Design

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)