Results page not showing any results
I just ran through the data assist wizard for the second time on this table. The results page stopped showing any results so I deleted the pages and ran the wizard again. I can use the insert page to create a record, and I verify that it is in the database, but then the results page shows no records at all. I haven't changed any RS queries. Thanks for your help!
Here is the Show If Code:
<?php if ($totalRows_WADAproduct > 0) { // Show if recordset not empty ?>
<div class="WADAResults">
<div class="WADAResultsNavigation">
<div class="WADAResultsCount">Records
<?php echo ($startRow_WADAproduct + 1) ?>
to
<?php echo min($startRow_WADAproduct + $maxRows_WADAproduct, $totalRows_WADAproduct) ?>
of
<?php echo $totalRows_WADAproduct ?>
</div>
<div class="WADAResultsNavTop">
<table border="0" cellpadding="0" cellspacing="0" class="WADAResultsNavTable">
<tr valign="middle">
<td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAproduct > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_WADAproduct=%d%s", $currentPage, 0, $queryString_WADAproduct); ?>" title="First"><img border="0" name="First" id="First" alt="First" src="WA_DataAssist/images/Poppy/Ultramodern_first.gif" /></a>
<?php } // Show if not first page ?></td>
<td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAproduct > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_WADAproduct=%d%s", $currentPage, max(0, $pageNum_WADAproduct - 1), $queryString_WADAproduct); ?>" title="Previous"><img border="0" name="Previous" id="Previous" alt="Previous" src="WA_DataAssist/images/Poppy/Ultramodern_previous.gif" /></a>
<?php } // Show if not first page ?></td>
<td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAproduct < $totalPages_WADAproduct) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_WADAproduct=%d%s", $currentPage, min($totalPages_WADAproduct, $pageNum_WADAproduct + 1), $queryString_WADAproduct); ?>" title="Next"><img border="0" name="Next" id="Next" alt="Next" src="WA_DataAssist/images/Poppy/Ultramodern_next.gif" /></a>
<?php } // Show if not last page ?></td>
<td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAproduct < $totalPages_WADAproduct) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_WADAproduct=%d%s", $currentPage, $totalPages_WADAproduct, $queryString_WADAproduct); ?>" title="Last"><img border="0" name="Last" id="Last" alt="Last" src="WA_DataAssist/images/Poppy/Ultramodern_last.gif" /></a>
<?php } // Show if not last page ?></td>
</tr>
</table>
</div>
<div class="WADAResultsInsertButton"> <a href="product_Insert.php" title="Insert"><img border="0" name="Insert" id="Insert" alt="Insert" src="WA_DataAssist/images/Poppy/Ultramodern_insert.gif" /></a> </div>
</div>
<table class="WADAResultsTable" border="0" cellpadding="0" cellspacing="0">
<tr>
<th class="WADAResultsTableHeader">Product ID:</th>
<th class="WADAResultsTableHeader">Name:</th>
<th class="WADAResultsTableHeader">Collection:</th>
<th class="WADAResultsTableHeader">Category:</th>
<th class="WADAResultsTableHeader">New Design:</th>
<th class="WADAResultsTableHeader">Most Popular:</th>
<th> </th>
</tr>
<?php do { ?>
<tr class="<?php echo $WARRT_AltClass1->getClass(true); ?>">
<td class="WADAResultsTableCell"><a href="product_Detail.php?ProductID=<?php echo(rawurlencode($row_WADAproduct['ProductID'])); ?>" ><?php echo($row_WADAproduct['ProductID']); ?></a></td>
<td class="WADAResultsTableCell"><a href="product_Detail.php?ProductID=<?php echo(rawurlencode($row_WADAproduct['ProductID'])); ?>" ><?php echo($row_WADAproduct['Name']); ?></a></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAproduct['CollectionID']); ?></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAproduct['CategoryID']); ?></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAproduct['NewDesign']); ?></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAproduct['MostPopular']); ?></td>
<td class="WADAResultsEditButtons" nowrap="nowrap"><table class="WADAEditButton_Table">
<tr>
<td><a href="product_Detail.php?ProductID=<?php echo(rawurlencode($row_WADAproduct['ProductID'])); ?>" title="View"><img border="0" name="View<?php echo(rawurlencode($row_WADAproduct['ProductID'])); ?>" id="View<?php echo(rawurlencode($row_WADAproduct['ProductID'])); ?>" alt="View" src="WA_DataAssist/images/Poppy/Ultramodern_zoom.gif" /></a></td>
<td><a href="product_Update.php?ProductID=<?php echo(rawurlencode($row_WADAproduct['ProductID'])); ?>" title="Update"><img border="0" name="Update<?php echo(rawurlencode($row_WADAproduct['ProductID'])); ?>" id="Update<?php echo(rawurlencode($row_WADAproduct['ProductID'])); ?>" alt="Update" src="WA_DataAssist/images/Poppy/Ultramodern_edit.gif" /></a></td>
<td><a href="product_Delete.php?ProductID=<?php echo(rawurlencode($row_WADAproduct['ProductID'])); ?>" title="Delete"><img border="0" name="Delete<?php echo(rawurlencode($row_WADAproduct['ProductID'])); ?>" id="Delete<?php echo(rawurlencode($row_WADAproduct['ProductID'])); ?>" alt="Delete" src="WA_DataAssist/images/Poppy/Ultramodern_trash.gif" /></a></td>
</tr>
</table></td>
</tr>
<?php } while ($row_WADAproduct = mysql_fetch_assoc($WADAproduct)); ?>
</table>
<div class="WADAResultsNavigation">
<div class="WADAResultsCount">Records
<?php echo ($startRow_WADAproduct + 1) ?>
to
<?php echo min($startRow_WADAproduct + $maxRows_WADAproduct, $totalRows_WADAproduct) ?>
of
<?php echo $totalRows_WADAproduct ?>
</div>
<div class="WADAResultsNavBottom">
<table border="0" cellpadding="0" cellspacing="0" class="WADAResultsNavTable">
<tr valign="middle">
<td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAproduct > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_WADAproduct=%d%s", $currentPage, 0, $queryString_WADAproduct); ?>" title="First"><img border="0" name="First1" id="First1" alt="First" src="WA_DataAssist/images/Poppy/Ultramodern_first.gif" /></a>
<?php } // Show if not first page ?></td>
<td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAproduct > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_WADAproduct=%d%s", $currentPage, max(0, $pageNum_WADAproduct - 1), $queryString_WADAproduct); ?>" title="Previous"><img border="0" name="Previous1" id="Previous1" alt="Previous" src="WA_DataAssist/images/Poppy/Ultramodern_previous.gif" /></a>
<?php } // Show if not first page ?></td>
<td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAproduct < $totalPages_WADAproduct) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_WADAproduct=%d%s", $currentPage, min($totalPages_WADAproduct, $pageNum_WADAproduct + 1), $queryString_WADAproduct); ?>" title="Next"><img border="0" name="Next1" id="Next1" alt="Next" src="WA_DataAssist/images/Poppy/Ultramodern_next.gif" /></a>
<?php } // Show if not last page ?></td>
<td class="WADAResultsNavButtonCell" nowrap="nowrap"><?php if ($pageNum_WADAproduct < $totalPages_WADAproduct) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_WADAproduct=%d%s", $currentPage, $totalPages_WADAproduct, $queryString_WADAproduct); ?>" title="Last"><img border="0" name="Last1" id="Last1" alt="Last" src="WA_DataAssist/images/Poppy/Ultramodern_last.gif" /></a>
<?php } // Show if not last page ?></td>
</tr>
</table>
</div>
</div>
</div>
<?php } // Show if recordset not empty ?>