Query only returning one result ???

[jandrews]

Hey,

 

Does anyone know why this query would only return one row in a table?

 <?php require_once('Connections/top50.php'); ?>
<?php
$maxRows_top50 = 10;
$pageNum_top50 = 0;
if (isset($_GET['pageNum_top50'])) {
  $pageNum_top50 = $_GET['pageNum_top50'];
}
$startRow_top50 = $pageNum_top50 * $maxRows_top50;

mysql_select_db($database_top50, $top50);
$query_top50 = "SELECT hits, title_music, playlist_music FROM flamplayer_musics ORDER BY hits DESC";
$query_limit_top50 = sprintf("%s LIMIT %d, %d", $query_top50, $startRow_top50, $maxRows_top50);
$top50 = mysql_query($query_limit_top50, $top50) or die(mysql_error());
$row_top50 = mysql_fetch_assoc($top50);

if (isset($_GET['totalRows_top50'])) {
  $totalRows_top50 = $_GET['totalRows_top50'];
} else {
  $all_top50 = mysql_query($query_top50);
  $totalRows_top50 = mysql_num_rows($all_top50);
}
$totalPages_top50 = ceil($totalRows_top50/$maxRows_top50)-1;

mysql_free_result($top50);
?>
</p>


<table width="100%" cellpadding="3" cellspacing="2">
  <tr>
    <td align="center" bgcolor="#121212"><div align="center">Song</div></td>
    <td align="center" bgcolor="#121212"><div align="center">Band</div></td>
    <td align="center" bgcolor="#121212">Plays</td>
  </tr>
  <?php do { ?>
    <tr>
      <td bgcolor="#666666"><a href="../band.php?music=<?php echo urlencode($row_top50['playlist_music']); ?>" class="style2"><a href="backing_track.php?track=<?php echo urlencode($row_top50['title_music']); ?>"> <?php echo ucfirst($row_top50['title_music']); ?></a></td>
      <td bgcolor="#666666"><a href="../band.php?music=<?php echo urlencode($row_top50['playlist_music']); ?>" class="style2"><?php echo ucfirst($row_top50['playlist_music']); ?></a></td>
      <td align="center" bgcolor="#666666"><?php echo $row_top50['hits']; ?></td>
    </tr>
    <?php } while ($row_top50 = mysql_fetch_assoc($top50)); ?>
</table>

 

Any help would be great.

 

[jackpf]

I think it could be something to do with the fact that dowhile runs the do loop before checking the while.

 

You should do it like this instead:

 

while($whatever = mysql_fetch_array($whatever))
{
//stuff here...
}

[jandrews]

tried to rearrange that like you said, but it doesnt seem to be that

[jackpf]

Try deleting:

 

mysql_free_result($top50);

[jandrews]

Try deleting:

 

mysql_free_result($top50);

 

No That doesn't work either.

[jackpf]

Ugh. Try putting or die(mysql_error()); after each query...

[jandrews]

Ugh. Try putting or die(mysql_error()); after each query...

 

There is only 1 query and it does have or die(mysql_error()); after it.

 

hmmmm....

 

I can't figure this one out

[fenway]

Show us the final sql statement.