View Single Post
Old 01-08-2009, 04:51 PM   #3 (permalink)
code_junkie
The Contributor
 
Join Date: Sep 2008
Posts: 39
Thanks: 9
code_junkie is on a distinguished road
Default

HTML:
Code:
<form action="search_results.php" method="post" name="search_form">
		  <div class="row">
		    <div class="report_title"><p>Start Date:</p></div>
			<div class="report_field"><p><input name="date_start" type="text" id="date_start" maxlength="8" /></p></div>
		  </div>
		<div class="form_padding"></div>
		  <div class="row">
		    <div class="report_title"><p>End Date:</p></div>
			<div class="report_field"><p><input name="date_end" type="text" id="date_end" maxlength="8" /></p></div>
		  </div>
		<div class="form_padding"></div>
		  <div class="row">
		    <div class="report_title"><p>&nbsp;</p></div>
			<div class="report_field"><p><input type="reset" value="Reset" name="reset" />  <input type="submit" name="submit" value="Submit" /></p></div>
		  </div>
		<div class="clear"></div>
		</form>
PHP:
Code:
$MM_username = $_SESSION['MM_Username'];
error_reporting(E_ALL);
ini_set('display_errors', '1');

$maxRows_Recordset1 = 100;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
  $pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

mysql_select_db($database_Company, $Company);
$query_Recordset1 = "SELECT * FROM call_in,drivers,company WHERE call_in.company_id = $MM_username AND call_in.company_id = company.company_id AND call_in.driver_id = drivers.driver_id AND call_in.date BETWEEN '" . $_POST['date_start'] . "' AND '" . $_POST['date_end'] . "' ORDER BY call_in.date DESC";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $Company) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);

if (isset($_GET['totalRows_Recordset1'])) {
  $totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
} else {
  $all_Recordset1 = mysql_query($query_Recordset1);
  $totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
__________________
Trying to learn all I can about PHP. Teach me what you know...
code_junkie is offline  
Reply With Quote