$result = mysql_query("
SELECT q.*, IF(v.id,1,0) AS voted
FROM quotes AS q
LEFT JOIN quotes_votes AS v 
ON 	q.id = v.qid
	AND v.ip =".$ip."
	AND v.date_submit = '".$today."'
");

$i=1;
$str='';
$script='';

while($row=mysql_fetch_assoc($result))
{
	// Looping through all the quotes and generating the list on the right of the page:
	
	$str.= '<div class="thumb" id="q-'.$i.'">'.substr($row['txt'],0,20).
	'<span class="points">...</span><div class="star-rating" id="rating-'.$i.'">';
	
	$row['rating'] = round($row['rating']);
	for($z=0;$z<5;$z++)
	{
		$str.='<input type="radio" name="rate-'.$i.'" value="'.($z+1).'" '.($z+1==$row['rating']?'checked="checked"':'').' disabled="disabled" />';
	}

	$str.='</div></div>';
	
	// Each quote calls the fillData JS function
	$script.="fillData(".formatJSON($row).");".PHP_EOL;
	
	$i++;
}

This is a Code for Quotation Script where User can Vote for the Quotation and Stuff..
But whenever I run this I encounter this Error:-

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /public_html/index.php on line 31

Please Help! Thank You! :D

Member Avatar for rajarajan2017

The error will come because of your formation of query. If you misplaced And or Where the error will trigger. So check whether the formation of query is correct or not?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.