Warning: expects resource but string given
- by Damien
I get:
"Resource id #8
Warning: mysql_fetch_array() expects parameter 1 to be resource, string given"
Heres the code: 
$sql="SELECT password FROM user WHERE userid=$userid";    
echo $password=mysql_query($sql);
while($row = mysql_fetch_array($password)) {
    $password = $row['password'];
}   
Any ideas?