tommyda Posted October 9, 2007 Share Posted October 9, 2007 my new rating system is working ok here www.pokerdepositoptions.com/display.php?affid=1 For some reason the ratings are not showing properly in paypal-poker.php it is showing 0star.jpg even if it has a rating look here www.pokerdepositoptions.com/paypal-poker-deposit.php // Displayrating.php <? include'connect.php'; $result1 = mysql_query("SELECT * FROM ratings WHERE (affid = '$affid')"); $num1 = mysql_num_rows($result1); if ($num1 > 1){$txt = 'Ratings';} else {$txt='Rating';} $query2 = "SELECT AVG(rating) FROM ratings WHERE (affid = '$affid')"; $result2 = mysql_query($query2) or die(mysql_error()); // Print out result while($row2 = mysql_fetch_array($result2)){ $actualrating = $row2['AVG(rating)']; $roundrating = round($actualrating); $ratecode = "<img border='0' src='images/".$roundrating."star.jpg'> ".$num." ".$txt; } ?> paypal-poker.php <?php include"connect.php"; include"displayrating.php"; $result = mysql_query("SELECT * FROM affiliates WHERE paypal = '<li>paypal</li>' ORDER BY rank DESC")or die(mysql_error()); echo"<blockquote><p class='style10'>Paypal Poker Sites and casinos </p></blockquote>"; echo"<table width='100%' border='1' bordercolor='#EAEAEA' align='center' cellspacing='0' cellpadding='0' bgcolor='white'> "; echo"<tr ><td width='120'><center>Site</center></td>"; echo"<td><center>Link</center></td>"; echo"<td><center>Bonus</center></td>"; echo"<td><center>Bonuscode</center></td>"; echo"<td><center>Usa</center></td>"; echo"<td><center>Rank</center></td>"; echo"<td><center>Review</center></td>"; echo"</tr><tr><td>"; // keeps getting the next row until there are no more to get while($row = mysql_fetch_array( $result )) { $affid = $row['id']; // Print out the contents of each row into a table echo"</tr><tr><td>"; echo "<a href='"; echo $row['url']; echo"'>"; echo"<center><img src='"; echo"$row[i120x120]' width='120' height='120' border='0' />"; echo"</a></center>"; echo"</td><td><center>"; echo"<a href='"; echo"$row"; echo"'>"; echo $row['site']; echo"</a>"; echo"</center></td><td><center>"; echo"$row[bonus]"; echo"</center></td><td><center>"; echo"$row[bonuscode]"; echo"</center></td><td><center>"; echo"$row[usa]"; echo"</center></td><td><center>"; echo $ratecode; echo"</center></td><td><center>"; echo"<a href='http://www.pokerdepositoptions.com/display.php?affid="; echo"$row[id]"; echo" '>Read more</a></center></tr><tr>"; } echo"</td><td></tr></table>"; ?> If anyone can help me it would be much appreciated ! Link to comment https://forums.phpfreaks.com/topic/72490-solved-help/ Share on other sites More sharing options...
pocobueno1388 Posted October 9, 2007 Share Posted October 9, 2007 Both of your links are not working. The first one I think you just left out the 's' in options. The second one goes to your site, but gives a 404 error. Link to comment https://forums.phpfreaks.com/topic/72490-solved-help/#findComment-365524 Share on other sites More sharing options...
tommyda Posted October 9, 2007 Author Share Posted October 9, 2007 links working now Link to comment https://forums.phpfreaks.com/topic/72490-solved-help/#findComment-365527 Share on other sites More sharing options...
pocobueno1388 Posted October 9, 2007 Share Posted October 9, 2007 Quickly looking at your code, I found a problem that might just be throwing everything off. In display.php, you have this code. $actualrating = $row2['AVG(rating)']; That isn't the correct way of doing that, you need to change your query to this: $query2 = "SELECT AVG(rating) AS avg_rating FROM ratings WHERE affid = '$affid'"; Now, change the first line of code I posted to this $actualrating = $row2['avg_rating']; See if that changes anything before I look at the code any further. Link to comment https://forums.phpfreaks.com/topic/72490-solved-help/#findComment-365532 Share on other sites More sharing options...
tommyda Posted October 9, 2007 Author Share Posted October 9, 2007 Thank you i changed it but it still will not display the correct rating on paypal-poker.php Link to comment https://forums.phpfreaks.com/topic/72490-solved-help/#findComment-365534 Share on other sites More sharing options...
tommyda Posted October 9, 2007 Author Share Posted October 9, 2007 Problem solved I included displayrating.php before setting $affid swapped them both round now it works! Link to comment https://forums.phpfreaks.com/topic/72490-solved-help/#findComment-365536 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.