on my page
http://scasp.com/testing/reviews.php
I use a search function in the form to search my database using the following code
$name = mysql_real_escape_string($_POST['name']);
$S_DATE = mysql_real_escape_string($_POST['S_Date']);
$E_DATE = mysql_real_escape_string($_POST['E_Date']);
$sql = "SELECT ID, Rating, DATE_FORMAT(R_Date, '%c/%e/%Y') as date, ASP_Name, Username FROM REVIEW WHERE ASP_Name = '$name' AND (R_Date BETWEEN '$S_DATE' AND '$E_DATE') ORDER BY R_Date DESC";
$query = mysql_query($sql) or die(mysql_error());
if(mysql_num_rows($query) == 0) {
while($row = mysql_fetch_array($query)){
// Build your formatted results here.
if($i++ % 2) {
$bgcolor = "#ffffff";
$id = "category";
} else {
$bgcolor = "#DFE6EF";
$id = "";
}
print "<tr bgcolor=\"$bgcolor\" id=\"$id\">";
print '<td><img src="' . $smileys[$row['Rating']] . '" alt="Rating: ' .$row['Rating']. '/10" /></td>';
print "<TD><a href=show_review.php?ID=".$row['ID'].">".$row['ASP_Name']."</a></TD>";
print "<TD>".$row['Username']."</TD>";
print "<TD>".$row['date']."</TD>";
print "</TR>\n";
}
} else {
echo "<tr><th colspan=3>You did not enter valid search critera.</th></tr>";
}
[/php}
I was just doing some testing to ensure all is ok and if I search for a review thats suposed to return 0 results, nothing is displayed(not even "You did not enter valid search criterea.
Do you know what the dilio is?
Thanks
