MDanz Posted April 22, 2010 Share Posted April 22, 2010 <?php mysql_connect("localhost", "Master", "pword"); mysql_select_db("db"); $official2 = mysql_query("SELECT * FROM Contribute WHERE stack LIKE '%comic%' ORDER BY points DESC")or die (mysql_error()); while($row = mysql_fetch_array($official2)) { $officaluser = $row['username']; $officalpoints = $row['points']; echo "<table><tr><td align='center'><font face='Arial' size='3px' color='#D99C29'><strong><a href='ustack.php?search=$officialuser' style='text-decoration: none'>$officialuser</a></strong></font></td><td align='center'><font face='Arial' size='3px' color='#FFFFFF'><strong>$officialpoints</strong></font></td></tr></table>"; } ?> the page is coming up blank??!? Link to comment https://forums.phpfreaks.com/topic/199345-not-workin-mysql-while-loop/ Share on other sites More sharing options...
DavidAM Posted April 22, 2010 Share Posted April 22, 2010 The query may not be returning any rows, in which case your script does not produce any output. After executing the query, add a check to see if it succeeded: if ($official2 === false) { echo 'Query Failed: ' . mysql_error(); } Link to comment https://forums.phpfreaks.com/topic/199345-not-workin-mysql-while-loop/#findComment-1046249 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.