How do I sort in alphabetical order this SQL query?

Question

I have tried with sort() in front of $new but it won't work, where should I put it?

$new = mysql_query("SHOW COLUMNS FROM Professors");

   while($row = mysql_fetch_array($new)) {  

    $output .= "{$row['Field']}";
    echo $output;
}

I have also tried something like this:

  $new = "SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE   table_name = 'Professors' ORDER BY column_name";

but, while on my SQL compiler it will sort them correctly, they won't get printed on the page with the exact code above.

@Ivke it will say: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource — Fidelio, Dec 25 '15 at 22:07
http://stackoverflow.com/questions/4075800/sql-listing-all-column-names-alphabetically — Ivan, Dec 25 '15 at 22:10
@PaulGrimshaw, nice suggestion but you forgot the `$` before row. — Phiter, Dec 25 '15 at 22:13

Phiter · Accepted Answer · 2015-12-25T22:10:37.600

0

Try this, then:

 $new = "SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE   table_name = 'Professors' ORDER BY column_name";

   while($row = mysql_fetch_array($new)) {  
    $output = $row['column_name'] . "<br>";
    echo $output;
}

You were ordering it correctly and selecting by column name but you weren't getting the correct field names.

edited Dec 25 '15 at 22:10

answered Dec 25 '15 at 22:07

Phiter

14,570
14
50
84

@paul grimshaw it will output {row['column_name']} as text – Fidelio Dec 25 '15 at 22:09
Whenever you need. Don't forget to pick the accepted question. – Phiter Dec 25 '15 at 22:14

How do I sort in alphabetical order this SQL query?

1 Answers1