Can anyone tell me if there is anything wrong with this statement
$query = "SELECT * FROM song ORDER BY songname ASC WHERE status='$stat'";
$result = @mysql_query ($query);
while ($row = mysql_fetch_array($result)) {
echo "{$row['songname']}";
}//end of while
i get error for $row = mysql_fetch_array($result))
Help!!!!
[SOLVED] Problem with code
Moderator: General Moderators
http://www.mysql.com/doc/en/SELECT.html
You need to place WHERE clause before ORDER BY clause.
You need to place WHERE clause before ORDER BY clause.