PHP Help

[Trigs]

$query = mysql_query("SELECT * FROM `users` ORDER BY `abc`");
 while($info = mysql_fetch_array($query)) {
  echo '<a href="index.php?user='.$info['username'].'">'.$info['username'].'</a> <br />';
 } 

I get mysql_fetch_array is not a valid resource blah blah blah. I haven't done php in a while so I can't remember how to troubleshoot it.

edit:

i have the same problem here:

 $query = mysql_query("SELECT * FROM users ORDER BY abc");
 while($list = mysql_fetch_array($query)) {
  echo '<a href="profile.php?user='.$list['username'].'">'.$list['username'].'</a> <br />';
 } 

[Source]

Just looking over it, on ORDER BY you need to specify a table - then a type.

SELECT * FROM `users` ORDER BY `table` ASC

As an example.

[Trigs]

Aha thanks. +rep