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??!? Quote 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(); } Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.