Jump to content


Photo

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


  • Please log in to reply
1 reply to this topic

#1 legohead6

legohead6
  • Members
  • PipPipPip
  • Advanced Member
  • 434 posts

Posted 15 October 2006 - 05:39 AM

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

<?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]";
}
}
?>

"Syntax error" .. WHERE THE **** IS IT?!

#2 trq

trq
  • Staff Alumni
  • Advanced Member
  • 31,041 posts

Posted 15 October 2006 - 06:18 AM

Your query is failing, try some debugging...

$r = mysql_query($m) or die(mysql_error());

More than likely because your query should be...

$m = "SELECT * FROM members WHERE user='{$files[3]}'";





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users