PHP mysql_fetch_assoc() error

Question

I am trying to retrieve data that is collected in a function, that contains my query. I am returning the data back to the main page and printing it using a while loop however i am getting this error:

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, string given

Below is my code:

Main page:

 <?php 
        $get5star = get5star(); 
        while($row = mysql_fetch_assoc($get5star)){
        echo $row['departmentid'] ;

        }
?>

function:

 function get5star(){

   $strSQL = "SELECT * FROM `5starproducts`";
   $query = mysql_query($strSQL);
   return mysql_result($query, 0);
     }

Avoid using the mysql library in PHP, use the mysqli library instead. Did you check the reference manual on php.net for this function? php.net/manual/en/function.mysql-fetch-assoc.php — Ocracoke
– Ocracoke, Commented Jan 22, 2015 at 13:00

Rakesh Sharma · Accepted Answer · 2015-01-22 13:00:54Z

8

try to return your result like

return $query;

cause you are returning string(your mysql_result($query, 0) returning 0th position column value only), need a query result for mysql_fetch_assoc()

answered Jan 22, 2015 at 13:00

Rakesh Sharma

13.7k5 gold badges41 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Cms Coders · Accepted Answer · 2015-01-22 13:47:26Z

0

try the corrected function: function get5star(){ $strSQL = "SELECT * FROM5starproducts"; $query = mysql_query($strSQL); return $query; }

answered Jan 22, 2015 at 13:47

Cms Coders

411 silver badge6 bronze badges

Collectives™ on Stack Overflow

PHP mysql_fetch_assoc() error

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related