search function?

lukeurtnowski

On my site, im trying to create a search function so that the results could be searched by Name, or by date, the problem is I dont know how to do this.
http://scasp.com/testing/reviews.php
I'm trying to make the search function happen when I click the search button, so the form action would be "", method would be POST, but dont really know much after that (the query I would run is going to be SELECT ID, Rating, DATE_FORMAT(R_Date, '%c/%e/%Y') as date, ASP_Name, Username FROM REVIEW WHERE 'ASP_Name' = $POST['name'] AND R_Date INBETWEEN $POST['SDate'] AND $_POST['EDate'] ORDER BY R_Date DESC).
RIGHT?

bogu

RIGHT ...

If u have problems relaited to R_Date INBETWEEN $POST['SDate'] AND $POST['EDate'] in the WHERE condition ..., use UNIX_TIMESTAMP and strtotime() for the date send through POST ...

UNIX_TIMESTAMP(R_Date) BETWEEN ".strtotime($_POST['SDate'])." AND ".strtotime($_POST['EDate'])."

lukeurtnowski

well I dont know how to run the query when the search button is pressed?
How do I? Something like this?

if(!isset($_POST['search'])) {
$sql = "SELECT ID, Rating, DATE_FORMAT(R_Date, '%c/%e/%Y') as date, ASP_Name, Username FROM REVIEW WHERE R_Date INBETWEEN $_POST['S_Date'] AND $_POST['E_Date'] ORDER BY R_Date DESC"); 
$query = mysql_query($sql) or die(mysql_error()); }

then

if(!isset($_POST['search'])) {
while($row = mysql_fetch_array($result)){
    // 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";
}
}

Thanks

bogu

U should use a hidden field:

<input type="hidden" name="action" />

when u check if the form was submit, cause if I complet the form and hit "Enter" your input type submit wont be pass through POST vars ...