PHP/Mysql question

[Gruzin]

Hi guys,
Here is my question: Is it possible to move up/down a record in table using php? If yes how can I do that?

Thanks,
George

[chiprivers]

Do you mean when displaying your results or literally the order in which the records are stored in the database?

[Gruzin]

I'd like to move one record up with one step in db.....

Thanks,
George

[chiprivers]

I think what your asking to do is swap the position two records are stored in the actual database, what you will have to do is extract the values of each field from both the records and then update each record with the other records values, excluding the primary key field.  This will then have the effect of swapping them around, I think!

[Gruzin]

[quote author=chiprivers link=topic=114659.msg466593#msg466593 date=1163276806]
I think what your asking to do is swap the position two records are stored in the actual database, what you will have to do is extract the values of each field from both the records and then update each record with the other records values, excluding the primary key field.  This will then have the effect of swapping them around, I think!
[/quote]
That's what i thought, thanks freind  ;)

[chiprivers]

It would be easier if you could swap the value of the primary key field but I don't think you can do that.

[lixid]

well i might be wrong .. but you could always set up and id field w/ auto increment and then set up the code to change the # of the id field from say 5 to 2 but then you would have to change the id field of 2 to 5 .. im sure it would be hard to setup .. but you might be able to create some type of counter that would decrease and increase the field number at the same time .. that kind of thing .. but i could be wrong .. :] but as chiprivers said you might not be able to do it with the primary key ...

[Gruzin]

Thanks guys, I'll try that  ;)

[Psycho]

If you build your database correctly you should NEVER need to rearrange the order the records actually exist in the database.