Warning: expects resource but string given

Question

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?

Answer 1

You are overwriting $password in the loop:

while($row = mysql_fetch_array($password)) {  <-------- $password as resource
    $password = $row['password'];             <-------- $password as string
} 

this should work:

 while($row = mysql_fetch_array($password)) {
    $password_record = $row['password'];
}