[zodehala]

suppose that i have database called name db and user table

user table

Code:

No user
========
1
1
1
1

i wanna increase value as sequential

Code:

No user
========
1
2
3
.
.

(NO is not AUTO_INCREMENT)


so i write following

PHP Code:

$link = mysql_connect("localhost","root","123") or die ( mysql_errno()."<br/>".mysql_error());

$db =  mysql_select_db("db");

$row = mysql_num_rows(mysql_query("SELECT * FROM user", $link));



for($i=0; $i <= $row;  $i++){

    mysql_query ("UPDATE user SET no = $i" ) or die ( mysql_errno()."<br/>".mysql_error());

} 

but it does not insert sequential number into cells ( it inserts same value into all cells) why ?

[Nico]

Because it'll update ALL rows if you don't specify a WHERE clause.

EDIT:

I think if you go to your PhpMyAdmin, and delete the no field, and then add it again using the auto_increment option, it'll automatically add the IDs.

[zodehala]

Originally Posted by Nico

Because it'll update ALL rows if you don't specify a WHERE clause.

EDIT:

I think if you go to your PhpMyAdmin, and delete the no field, and then add it again using the auto_increment option, it'll automatically add the IDs.

i tried it using "WHERE" too but it does not


and using auto_increment

http://img515.imageshack.us/img515/7349/snap1oi1.gif

[phpdoctor]

Can you show us the table structure?
What type of field is the "no" one?

Like Nico said... you a WHERE clause.

Lex

[nashruddin]

modify your code like this:

PHP Code:

$result = mysql_query("SELECT * FROM user");



$new_id = 1;



while($row = mysql_fetch_assoc($result)) {

    mysql_query("UPDATE user SET no = $new_id WHERE no = " . $row['no']);

    $new_id++;

} 

Hope that's work

[Nico]

The thing is all rows have the same ID (or "no"). And you're using a query without LIMIT, WHERE no = no. So that'll do pretty much the same as his code did.

[phpdoctor]

How many records do you have... to much to do manually?
I think you need to get all the records into an array to process...
Then remove all records...
Then insert all the records from the array...

Might be dangers to do if not done correctly the first time

Lex

[UnrealEd]

What exactly are you trying to do?

Looking at the image you posted tells me you already have an AUTO_INCREMENT field, and therefor already have an increasing, sequential value.

[phpdoctor]

What? i didnt see the image for some reason...
It says you already have a auto-increment field?

I dont see the problem either... could you show us the table structure?

Lex