[SOLVED] CMS System Need Help

[Lamez]

 

How would I be able to pull the highest ID number from the database and add 1 to it?

 

example:

 

--ID-- --title-- --news--

1          wel..    welcome to the website

2          hi          this is an update

..        ..          ..

11        hello      look at this

 

so I would want to select the ID 11 and add 1 to it so it would become 12, and then I could insert it into the database.

 

Thanks Guys

 

[PFMaBiSmAd]

Use an auto_increment index column to get the database to do this for you.

[Lamez]

I am not familiar with that, is that a PHP function?

[spider661]

is a database function built into them i use mysql myself. go into the property's of the table and set id or the one you want to go up to auto_increment and then when you add your line just leave id blank and the database will put the next highest number in there for you.

 

or when you build the table set it here is how i built a table i used.

 

CREATE TABLE `server_globals` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(65) NOT NULL default '',
  `value` varchar(65) NOT NULL default '?',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `qname` (`name`,`value`)
) ENGINE=MyISAM AUTO_INCREMENT=1280 DEFAULT CHARSET=latin1;

 

see how i set id to auto_increment and even set a starting value

 

so UPDATE tablename SET `id` int(11) NOT NULL auto_increment

 

should work

[Lamez]

so now I can just insert?

 

like this:

 

<?php
$q = "INSERT INTO `home` (id, content, title) VALUES ('$id', '$content', '$title')";
   mysql_query($q);
?>

 

wait, I am confused. Would that be right (above).

[Lamez]

oh, and I just set the database to auto_increment

[spider661]

<?php
$q = "INSERT INTO `home` (content, title) VALUES ('$content', '$title')";
   mysql_query($q);
?>

 

will do it you dont have to put in an id now the database will do it auto for you.

[Lamez]

aww that is so easy thanks very much

[spider661]

jsut trying to do my part to help your welcome