Please help with my query

jandrews

Hi there,

Im new to php and mysql and I'm using dreamweaver 8 to program my queries.

Does anyone know why when i set up a recordset and test it, i get a nice long list of results but when i include the results in a table as a repeat region, i get no results?

Here is the page:

<table cellpadding="1">
  <tr>
    <td>hits</td>
    <td>title_music</td>
    <td>playlist_music</td>
  </tr>
  <?php do { ?>
    <tr>
      <td><?php echo $row_toptracks['hits']; ?></td>
      <td><?php echo $row_toptracks['title_music']; ?></td>
      <td><?php echo $row_toptracks['playlist_music']; ?></td>
    </tr>
    <?php } while ($row_toptracks = mysql_fetch_assoc($toptracks)); ?>
</table>
<?php require_once('Connections/top50.php'); ?>
<?php
$maxRows_toptracks = 10;
$pageNum_toptracks = 0;
if (isset($_GET['pageNum_toptracks'])) {
  $pageNum_toptracks = $_GET['pageNum_toptracks'];
}
$startRow_toptracks = $pageNum_toptracks * $maxRows_toptracks;

mysql_select_db($database_top50, $top50);
$query_toptracks = "SELECT hits, title_music, playlist_music FROM flamplayer_musics ORDER BY hits DESC";
$query_limit_toptracks = sprintf("%s LIMIT %d, %d", $query_toptracks, $startRow_toptracks, $maxRows_toptracks);
$toptracks = mysql_query($query_limit_toptracks, $top50) or die(mysql_error());
$row_toptracks = mysql_fetch_assoc($toptracks);

if (isset($_GET['totalRows_toptracks'])) {
  $totalRows_toptracks = $_GET['totalRows_toptracks'];
} else {
  $all_toptracks = mysql_query($query_toptracks);
  $totalRows_toptracks = mysql_num_rows($all_toptracks);
}
$totalPages_toptracks = ceil($totalRows_toptracks/$maxRows_toptracks)-1;

mysql_free_result($toptracks);
?>

ee12csvt

Hi,

Just had a look and have noticed that you don't have any Head, Title or Body indicators.

I have rewritten the code on how I think it should be.

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

mysql_select_db($database_top50, $top50);
$query_toptracks = "SELECT hits, title_music, playlist_music FROM flamplayer_musics ORDER BY hits DESC";
$query_limit_toptracks = sprintf("%s LIMIT %d, %d", $query_toptracks, $startRow_toptracks, $maxRows_toptracks);
$toptracks = mysql_query($query_limit_toptracks, $top50) or die(mysql_error());
$row_toptracks = mysql_fetch_assoc($toptracks);

if (isset($_GET['totalRows_toptracks'])) {
  $totalRows_toptracks = $_GET['totalRows_toptracks'];
} else {
  $all_toptracks = mysql_query($query_toptracks);
  $totalRows_toptracks = mysql_num_rows($all_toptracks);
}
$totalPages_toptracks = ceil($totalRows_toptracks/$maxRows_toptracks)-1;
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<table cellpadding="1">
  <tr>
    <td>hits</td>
    <td>title_music</td>
    <td>playlist_music</td>
  </tr>
  <?php do { ?>
    <tr>
      <td><?php echo $row_toptracks['hits']; ?></td>
      <td><?php echo $row_toptracks['title_music']; ?></td>
      <td><?php echo $row_toptracks['playlist_music']; ?></td>
    </tr>
    <?php } while ($row_toptracks = mysql_fetch_assoc($toptracks)); ?>
</table>
</body>
</html>
<?php 
mysql_free_result($toptracks);
?>

Let me know if it works

Phil

jandrews

ee12csvt;10910913 wrote:
Hi,
Just had a look and have noticed that you don't have any Head, Title or Body indicators.

Thanks phil, but they are not necessary as the page is being included into a page which does have those things.

Anyway i found the problem and it was that the connection code was in the wrong order. Here is what i used:

<?php require_once('Connections/top50.php');

mysql_select_db($database_top50, $top50);
$query_test = "SELECT hits, title_music, playlist_music FROM flamplayer_musics ORDER BY hits DESC";
$test = mysql_query($query_test, $top50) or die(mysql_error());
$row_test = mysql_fetch_assoc($test);
$totalRows_test = mysql_num_rows($test);
?>
<table cellpadding="1">
  <tr>
    <td>hits</td>
    <td>title_music</td>
    <td>playlist_music</td>
  </tr>
  <?php do { ?>
    <tr>
      <td><?php echo $row_test['hits']; ?></td>
      <td><?php echo $row_test['title_music']; ?></td>
      <td><?php echo $row_test['playlist_music']; ?></td>
    </tr>
    <?php } while ($row_test = mysql_fetch_assoc($test)); ?>
</table>

<?php

mysql_free_result($test);
?>

Thanks again Phil