$newsorder1=$row[newsorder]+1;

[Jarod]

This doesnt seem to work.

mysql_query("SELECT max(newsorder) FROM news") or die("Couldn't ececute query.");

$newsorder1=$row[newsorder]+1;

I tried to do a auto increment but I already have a auto_increment in the database. Here is what it is.

id mediumint(9) NOT NULL auto_increment,
title text NOT NULL,
teaser text NOT NULL,
text longtext NOT NULL,
date datetime NOT NULL default '0000-00-00 00:00:00',
newsorder varchar(5) NOT NULL default '',
KEY id (id),

I need to auto increment twice so that later we can rearrange the news order

[theeper]

$newsorder1=$row[newsorder];
$newsorder1++;

[Jarod]

doesnt work any more ideas?

[Jarod]

does anybody have any ideas plese, i am really stumped

[theeper]

I am not sure what you want. I thought you just wanted to increment a number you pulled from a DB. Please explain.

[Jarod]

that is all i want but i cant seem to get it to work.

[theeper]

Pull your value from the DB and assign it to a variable.

Then use the increment operator on it.

$var = 1;
$var++; // $var now equals 2

http://www.php.net/manual/en/language.operators.increment.php

[Jarod]

like this?

[theeper]

Like what ?

[Jarod]

my bad

$result = mysql_query("SELECT MAX(newsorder) FROM news") or die("Couldn't ececute query.");
$newsorder1=$row[newsorder];
$newsorder1++;

[theeper]

If you properly assigned a value to $newsorder1, that script will increment $newsorder1 by one.

Are you trying to get the highest value of your auto_increment column and increment it by one?

If so, check out mysql_insert_id()
http://www.php.net/manual/en/function.mysql-insert-id.php

This will give you the value of the most recent INSERT into an auto_increment column.

[[deleted]]

Note that select max() will NOT give you a good value, it will only give you the current highest value at the time the query was executed. do NOT use this to insert into a new record.

If you want to insert the value into a new record, you MUST lock the table before you select the value, and you may not unlock the table until you have inserted the value successfully.

This is again one of those times when mysql really show how shitty it is. PostgrSQL (and every other database) can create multiple 'sequences' (auto_increments) on a table. MySQL can only deal with one at a time.

[Jarod]

Originally posted by theeper
If you properly assigned a value to $newsorder1, that script will increment $newsorder1 by one.

Are you trying to get the highest value of your auto_increment column and increment it by one?

If so, check out mysql_insert_id()
http://www.php.net/manual/en/function.mysql-insert-id.php

This will give you the value of the most recent INSERT into an auto_increment column.

Yea thats what im trying to do. Ill try this thanks

[[deleted]]

"This will give you the value of the most recent INSERT into an auto_increment column."

No, it will give you the last value used by an insert query executed over the same database connectionn that you issue this from.

If there was no previous insert, then there is no value for mysql_insert_id() either.

Besides which, this is also not multi-user safe. Your insert may have used number 100, but since them there could have been 50 other inserts and the real number may be up to 150 by the time you get the result from mysql_insert_id().

[Jarod]

i like ur thinking, what can i do than. I need to auto_increment 2 feilds, im thinking of making a new feild just to make this work.

[[deleted]]

You need to auto_increment two fields... why?

What's the point of having two columns with increasing values?
What's stopping you from just using one?

[theeper]

If there was no previous insert, then there is no value for mysql_insert_id() either.

Actually, mysql_insert_id() returns 0 if the previous query does not generate an AUTO_INCREMENT value.

[[deleted]]

"Actually, mysql_insert_id() returns 0 if the previous query does not generate an AUTO_INCREMENT value."

Details, details... 🙂 the point is that mysql_num_rwos() doesn't return 'max()+1' if you did not insert anything before.

PS zero is never used in sequences, so it's an invalid value anyway.

[theeper]

lol, just giving you a hard time Vincent, I know you are the man when it comes to this stuff. I have learned A LOT from you.

[Jarod]

well i need to have one for a unique id then i need another one where after the news is updated the end user can choosewhich order the news will go in.

any ideas?