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