mysql_fetch_row() ERROR please help

[eukhost]

Hello,

With the following code:

$result = mysql_query("SELECT username,password FROM merchants WHERE user='$username'");
list($username,$password) = mysql_fetch_row($result);//line 8
if($password == "$password") 
    if($action == "") 
        $result = mysql_query("SELECT id,name,username,password,email,hitsout,banner,url,companyname,address,maxhitsout,description WHERE id='$id'");

I get the below error:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/pc-prices.co.uk/httpdocs/edit.php on line 8

Can anyone please help?

Thanks

[Saruman]

Try to echo your query and then execute it using, for example, phpMyAdmin. Or check for errors and prints them - maybe your query is incorrect that leads to a error.

[vronsky]

wich sql funtion are you using to connect?

If mysql_connect();
try to change to
mysql_pconnect();

hope can help