Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource

[poreko]

I am connecting to my database using Object oriented PHP. My query is returning results but at the end of my table,at the bottom of the page I keep having this error when I run my program: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\mysql_class_2.php on line 45.

Can anyone help me?

The following is my PHP class:

 <?php
 class mysql {
 ////////////////////////////////////////////////////////////////
 function Connect($host, $name, $pass, $db){
 $connection = mysql_connect("$host","$name","$pass");
 mysql_select_db("$db", $connection);
 }//ends the connection function
 ///////////////////////////////////////////////////////////////
 function Close(){
 mysql_close($this->connection);
 }//ends the close function
 //////////////////////////////////////////////////////////////
 function FetchRow($query){
 $rows = mysql_fetch_row($query);
 return $rows;
 }
 ////////////////////////////////////////////////////////////
 function FetchArray($query){
 $array = mysql_fetch_array($query);
 return $array;
 }
 ///////////////////////////////////////////////////////////
 function FetchNum($query){
 while ($num = mysql_num_rows($query));
 return $num;
 }
 ////////////////////////////////////////////////////////////////
 function Query($sql){
 $query = mysql_query($sql) or die(mysql_error());
 return $query;
 }//ends the query function
 ///////////////////////////////////////////////////////////////////////////////
 function FetchAssoc($query2){
 $array = mysql_fetch_assoc($query2);
 return $array;
 }
 ///////////////////////////////////////////////////////////////////////////////
 function TanimotoSimilarity($query,$input_arrays) {
 $i=0;
 $row= array();
 while( $row=mysql_fetch_assoc($query) )
 {
 $first[$i]=(count(array_intersect($row,$input_arrays)))/(count($row)+count($input_arrays)-count(array_intersect($row,$input_arrays)));
 $i++;
 }
 return($first);
 
 }
 ///////////////////////////////////////////////////////////////////////////////////
 }//ends the class
 ?>
 

On the code above Mysql_fetch_asson function is on line 33.

Thanks

[Atli]

Hi.

You get that warning when you try to fetch rows from a variable that is not a MySQL query resource.
(A MySQL query resource is the return value of a successful mysql_query call)

To avoid it, you need to make sure that the parameter you are passing it is in fact a valid resource. This usually works fine:

if($resource and !is_bool($resource)) {
  $row = mysql_fetch_assoc($resource);
}

When a mysql_query call fails, it returns FALSE, or in the case of successful queries that do not return a result set, TRUE.

P.S.
What's with the while loop on line 24?

[poreko]

The while loop in line 24 is my mistake. It was just me trying something out.