Warning: mysql_fetch_object(): supplied argument is not a valid MySQL
result resource in json
i got an error in my json codelike this,.
ERROR:
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL
result resource in D:\XAMPP\xampp\htdocs\ROOPA\music\demo.php on line 15
{"result":null}
PHP FILE:
<?php
@include("db.php");
$query = "SELECT a.a_name as name,b.total_value as value,b.total_votes
as votes,a.a_pic as image FROM _album a inner join ratings b on
b.a_id=a.id";
$result = mysql_query($query);
// $query1 = "SELECT total_value,total_votes FROM ratings";
//$result1 = mysql_query($query1);
$count = mysql_num_rows($result);
//$count1 = mysql_num_rows($result1);
if($count > 0)
{
while($data = mysql_fetch_object($result))
{
$alb_name =$data->name;
$rate_value = $data->value;
$rate_votes = $data->votes;
$alb_pic =$data->image;
$resmsg[] =
array("Album_name"=>$alb_name,"Rating_total_value"=>$rate_value,"Rating_total_votes"=>$rate_votes,"Image_name"=>$alb_pic);
}
$jsonarr = array("result"=>$resmsg);
}
else
{
$jsonarr = array("result"=>"data not found");
}
echo json_encode($jsonarr);
?>
CAN ANYONE HELP ME?
