you might want to install myphpadmin its very nice its distribute\astrology\poll.cfm (randomized poll)
CREATE TABLE nuke_access ( access_id int(10) NOT NULL auto_increment, access_title varchar(20) default NULL, PRIMARY KEY (access_id), KEY access_id (access_id) ) TYPE=MyISAM; there is a sample db auto_increment is the way ----- Original Message ----- From: "Paul Ihrig" <[EMAIL PROTECTED]> To: "CF-Community" <[EMAIL PROTECTED]> Sent: Tuesday, November 05, 2002 1:05 PM Subject: RE: php & mySql (WAS: got a job..) > ok.. > looking through all docs on mySql... > using the mysqlCC which is the visual editor for the db.. > > now what is the equivalent of a auto number for a primary key?? > think this would stand out but i can only assign primary key.. > but it isn't auto numbering... > > : ] > thanks! > -paul > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm