PLZ help with this one thing (VERY EASY)..

m37h0d

Ok, im getting this error when trying to view this page...

Warning: Supplied argument is not a valid MySQL result resource in c:\apache\htdocs\view_clan.php on line 13

Thank you very much if anyone can help me.

Line 13 is...

while ($row = mysql_fetch_array ($ver))

The full code...

 
 <?php
 require("config.php");
 mysql_connect ($hostname, $db_login, $db_pass);
 mysql_select_db($dbname);

 $select_data=("SELECT first_name, last_name, clan_name, leaders_name, gb_id, socom_rank, member_num, aim, yahoo, msn, email, opmsg, guest_id FROM cfrecords");
 $ver=mysql_query($select_data);

  echo"<center><font color=yellow size=+2>Clanfinder BETA</font></center>";
  echo"<body bgcolor=blue>";


   while ($row = mysql_fetch_array ($ver))

  {

echo "<font color=white><b>Name:</b><a href=mailto:$row[2]></font></font><font color=white> ".$row[0]."</a><br></font>\n";
echo "<font color=yellow><b>Message:</b> ".$row[1]."<br>\n</font>";
}


?>

Shrike

That generally means that the SQL query failed. Add

echo mysql_error();

Before the line with the while() loop.