SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Thread: Mysql question

  1. #1
    SitePoint Zealot
    Join Date
    Dec 2001
    Posts
    115
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Mysql question

    Is it possible to move up a row ?
    Ex: my site displays ID's 1,2,3 but I would like to change that to 1,3,2

    I havent't seen this option in PHPMyadmin but is it possible ?

  2. #2
    SitePoint Wizard Aes's Avatar
    Join Date
    Jun 2001
    Location
    Oklahoma
    Posts
    3,392
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    No, it's not possible. I have a question though -- why in the world would you want to do this? I cannot think of any valid reason.

    -Colin
    Colin Anderson
    Ambition is a poor excuse for those without
    sense enough to be lazy.

  3. #3
    SitePoint Zealot
    Join Date
    Dec 2001
    Posts
    115
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    if u have a large menu for example..and u want the last link to be on top

  4. #4
    Action! filmfoto's Avatar
    Join Date
    Dec 2001
    Location
    Sweden
    Posts
    278
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You could always add a field to your table, called something like view_order. Then all you have to do is update this view_order field as necessary and use an ORDER BY view_order clause.

    Might help.




    Cheers.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •