HELP "Warning: mysql_fetch_row(): supplied argument is not a valid MySQL"

[legohead6]

This script gets files and is supposed to show the immage along with the name of the image!

[code]<?PHP
session_start();
$user=$_SESSION['user'];
$username="*********";
$password="********";
$database="**********";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query = "SELECT * FROM files";
$results = mysql_query($query);
while($files = mysql_fetch_row($results)){
$m = "SELECT * FROM members WHERE user=$files[3]";
$r = mysql_query($m);
while($mem = mysql_fetch_row($r)){
$name = explode('.' , $files[1]);
$thumb="/userfolder/$mem[3]/$files[1]";
echo "<img src=$thumb><br>$name[0]";
}
}
?>[/code]

[trq]

Your query is failing, try some debugging...

[code=php:0]
$r = mysql_query($m) or die(mysql_error());
[/code]

More than likely because your query should be...

[code=php:0]
$m = "SELECT * FROM members WHERE user='{$files[3]}'";
[/code]