Professional Web Applications Themes

Any ideas why a mysql 'order by' does not work any more ?? - PHP Development

The following piece of code has worked in the past but any ideas why it does not work now ??? $sql = mysql_query("ALTER TABLE `words` ORDER BY `counter` DESC"); The code that is above it, also uses the same database, username, password etc and works fine. The mysql scheme privilges are set to 'select' and 'update'...

  1. #1

    Default Any ideas why a mysql 'order by' does not work any more ??

    The following piece of code has worked in the past but any ideas why
    it does not work now ???

    $sql = mysql_query("ALTER TABLE `words` ORDER BY `counter` DESC");

    The code that is above it, also uses the same database, username,
    password etc and works fine.

    The mysql scheme privilges are set to 'select' and 'update'


    shorty Guest

  2. #2

    Default Re: Any ideas why a mysql 'order by' does not work any more ??

    shorty wrote: 

    So what are you trying to do? Maybe you meant
    SELECT * FROM `words` ORDER BY `counter` DESC?
     

    See you used ALTER not SELECT or UPDATE.

    Regards
    Stefan
     
    Stefan Guest

  3. #3

    Default Re: Any ideas why a mysql 'order by' does not work any more ??

    After a customer enters data into a table, and then leaves the
    website.

    All I want to do is sort (numerically) a particular column in the
    table, and then resave the table, ready for its next use.
     
    >
    >So what are you trying to do? Maybe you meant
    >SELECT * FROM `words` ORDER BY `counter` DESC?

    >
    >See you used ALTER not SELECT or UPDATE.
    >
    >Regards
    >Stefan
    > [/ref]

    shorty Guest

  4. #4

    Default Re: Any ideas why a mysql 'order by' does not work any more ??

    shorty wrote: [/ref][/ref]
     [/ref]
     [/ref][/ref]
     [/ref]

     


    Tables in SQL databases are not sorted in any way and you can't
    make them be sorted.
    What you can do is to sort the data you get from table when
    you select the data as Stefan described.

    Only statement with which "ORDER BY" can be used is "SELECT"
    (not CREATE, ALTER, DROP, INSERT, UPDATE or DELETE).


    Hilarion
    Hilarion Guest

  5. #5

    Default Re: Any ideas why a mysql 'order by' does not work any more ??

    Great got the following to work

    $result = mysql_query("SELECT * FROM words ORDER BY counter DESC LIMIT
    0, 15")

    The strange thing is that I thought you could permanently sort a mysql
    database. But then again my memory can be a bit suspect at times.





    shorty Guest

  6. #6

    Default Re: Any ideas why a mysql 'order by' does not work any more ??

    You can't use Order by in ALTER TABLE

    "Hilarion" <op.SMIECI.pl> a écrit dans le message de news:
    de4tl0$mor$onet.pl... [/ref]
    > [/ref]
    > [/ref]
    > [/ref]
    >

    >
    >
    > Tables in SQL databases are not sorted in any way and you can't
    > make them be sorted.
    > What you can do is to sort the data you get from table when
    > you select the data as Stefan described.
    >
    > Only statement with which "ORDER BY" can be used is "SELECT"
    > (not CREATE, ALTER, DROP, INSERT, UPDATE or DELETE).
    >
    >
    > Hilarion[/ref]


    Hatem Guest

Similar Threads

  1. Replies: 0
    Last Post: July 23rd, 12:15 AM
  2. cfm and mysql 'order'
    By Dave199 in forum Coldfusion - Getting Started
    Replies: 3
    Last Post: April 27th, 12:52 PM
  3. Order statistic in MySQL
    By Jeffrey Rolland in forum MySQL
    Replies: 13
    Last Post: April 25th, 04:00 PM
  4. help with mySQL and ORDER BY
    By LRW in forum PHP Development
    Replies: 4
    Last Post: February 23rd, 12:15 AM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139