[RESOLVED] 'No records found' text.

[Iain]

Seem to have a problem with the code that usually works for this - but with this particular page it seems to want to display that text even when records are found, after they're listed.

The code looks like :

<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="5%" class="labelcell">ID</td>
<td width="30%" class="labelcell">Candidate</td>
<td width="20%" class="labelcell">Telephone</td>
<td width="30%" class="labelcell">Email</td>
<td width="15%" class="labelcell"><div align="center">No of matches </div></td>
</tr>
<?php do { ?>
<tr>
<td class="idcell"><?php echo $row_Candidates['CandidateID']; ?></td>
<td class="fieldcell"><a href="candidateDetails.php?CandidateID=<?php echo $row_Candidates['CandidateID']; ?>"><?php echo $row_Candidates['FirstName']; ?> <?php echo $row_Candidates['LastName']; ?></a></td>
<td class="fieldcell"><?php echo $row_Candidates['Telephone']; ?></td>
<td class="fieldcell"><?php echo $row_Candidates['Email']; ?></td>
<td class="fieldcell"><div align="center"><?php echo $row_Candidates['rank']; ?></div></td>
</tr>
<?php } while ($row_Candidates = mysql_fetch_assoc($Candidates)); ?>
<?php 
if ($totalRows_Candidates==0){
echo "<tr><td colspan='5'>*No Matching Candidates Found*</td></tr>"; 
}
?>
</table>

Any ideas?

[mjax]

I don't see where your $totalRows_Candidates variabele is set (or modified) in the code. Could you post that code too?

[Iain]

All the code at the top of the page currently looks like :

<?php require_once('../Connections/connSearchTechUK.php'); ?>
<?php
$currentPage = $_SERVER["PHP_SELF"];



$queryString_Candidates = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_Recordset1") == false && 
        stristr($param, "totalRows_Recordset1") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_Candidates = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_Candidates = sprintf("&totalRows_Candidates=%d%s", $totalRows_Candidates, $queryString_Candidates);

$TFM_LimitLinksEndCount = 5;
$TFM_temp = $pageNum_Candidates + 1;
$TFM_startLink = max(1,$TFM_temp - intval($TFM_LimitLinksEndCount/2));
$TFM_temp = $TFM_startLink + $TFM_LimitLinksEndCount - 1;
$TFM_endLink = min($TFM_temp, $totalPages_Recordset1 + 1);
if($TFM_endLink != $TFM_temp) $TFM_startLink = max(1,$TFM_endLink - $TFM_LimitLinksEndCount + 1);




//db session

mysql_select_db($database_connSearchTechUK, $connSearchTechUK);

if (isset($_POST['profiles'])){

// get profile keys

$profiles = array_keys($_POST['profiles']);

// sql string
$sql = 'SELECT *, Count(*) As rank FROM Candidates, CandidateProfiles WHERE Candidates.CandidateID = 

CandidateProfiles.CandidateID AND CandidateProfiles.ProfileID IN(' . implode(',', $profiles).') GROUP BY 

Candidates.CandidateID ORDER BY rank DESC, Candidates.CandidateID';

$Candidates = mysql_query($sql) or die(mysql_error());
$row_Candidates = mysql_fetch_assoc($Candidates);
@$totalRows = mysql_num_rows($Candidates);
}
else
{
echo 'You did not check any profiles';
}
?>

[bradgrafelman]

I still don't see where you set $totalRows_Candidates in that code.

[Iain]

Not sure what happened there - rebuilt the page and all seems fine.