[eluser]Nica[/eluser]
How about the dfrom..?
Code:
WHERE mds_orders.OrderDate BETWEEN '".$date_from." 00:00:00' AND '".$date_to('dto'." 23:59:59'
Is it okay to load also my libraries like this..?
Code:
$autoload['libraries'] = array('database','form_validation','session','pagination','email');
Like you said I already change my starting form tag like this..
Code:
<html>
<head>
</head>
<body>
<h1>Sales Per Sales Frequency Bracket</h1>
<?php echo form_open('sales/getAll');?>
<b>Date From:</b> <br><input type="text" name="dfrom" id="dfrom"></p>
<b>Date To:</b> <br><input type="text" name="dto" id="dto"><br /><br />
<input name="submit" type="submit" value="Go">
<?php echo form_close();?>
<table border="2"
cellpadding="2"
cellspacing="1"
>
<tr>
<th>Restaurant Code</th>
<th>Restaurant Name</th>
<th>100 & Below</th>
<th>101-200</th>
<th>201-300</th>
<th>301-400</th>
<th>401-500</th>
<th>501-600</th>
<th>601-700</th>
<th>701-800</th>
<th>801-900</th>
<th>901-1000</th>
<th>1001 & Above</th>
<th>Total Gross Sales</th>
</tr>
</table>
<?php
if(isset($_POST['submit']))
{
foreach($query as $row)
print $row->code;
print $row->name;
print $row->less100;
print $row->less200;
print $row->less300;
print $row->less400;
print $row->less500;
print $row->less600;
print $row->less700;
print $row->less800;
print $row->less900;
print $row->less1k;
print $row->gtr1k;
print $row->total;
print "<br>";
}
?>
</html>
but still there are no display.,I don't know if I'm doing right.,I understand if my coding style is a bad practice I'm new in this Code Igniter that's why I'm asking a lot of questions. And thank you a lot for helping me this.