[eluser]Nica[/eluser]
oh i'm sorry I think you misinterpret my question..
what I mean is I have my sql query like this..
Code:
<?php
// db connection
$db = "mds_reports";
if($connect = mysql_connect("172.16.8.32", "mds_reports", "password"))
$connect = mysql_select_db($db);
else die("Unable to connect".mysql_error());
$date_from = $_POST['dfrom'];
$date_to = $_POST['dto'];
?>
<html>
<head>
</head>
<title>Sales Frequency Bracket</title>
<body>
<h1>Sales Per Sales Frequency Bracket</h1>
<form name="fetching" method="POST" action="Sales.php"></p>
<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 /><p>
<input name="submit" type="submit" value="Go">
</form>
<table>
<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>
<?php
if(isset($_POST['submit']))
{
echo " Date select from $date_from to $date_to"."</p>";
$sql = "SELECT restaurant_master.code, restaurant_master.name,
SUM(CASE WHEN mds_orders.GrossTotal < '100' THEN mds_orders.GrossTotal END) AS 'less100',
SUM(CASE WHEN mds_orders.GrossTotal >= '100' AND mds_orders.GrossTotal < '200' THEN mds_orders.GrossTotal END) AS 'less200',
SUM(CASE WHEN mds_orders.GrossTotal >= '200' AND mds_orders.GrossTotal < '300' THEN mds_orders.GrossTotal END) AS 'less300',
SUM(CASE WHEN mds_orders.GrossTotal >= '300' AND mds_orders.GrossTotal < '400' THEN mds_orders.GrossTotal END) AS 'less400',
SUM(CASE WHEN mds_orders.GrossTotal >= '400' AND mds_orders.GrossTotal < '500' THEN mds_orders.GrossTotal END) AS 'less500',
SUM(CASE WHEN mds_orders.GrossTotal >= '500' AND mds_orders.GrossTotal < '600' THEN mds_orders.GrossTotal END) AS 'less600',
SUM(CASE WHEN mds_orders.GrossTotal >= '600' AND mds_orders.GrossTotal < '700' THEN mds_orders.GrossTotal END) AS 'less700',
SUM(CASE WHEN mds_orders.GrossTotal >= '700' AND mds_orders.GrossTotal < '800' THEN mds_orders.GrossTotal END) AS 'less800',
SUM(CASE WHEN mds_orders.GrossTotal >= '800' AND mds_orders.GrossTotal < '900' THEN mds_orders.GrossTotal END) AS 'less900',
SUM(CASE WHEN mds_orders.GrossTotal >= '900' AND mds_orders.GrossTotal < '1000' THEN mds_orders.GrossTotal END) AS 'less1k',
SUM(CASE WHEN mds_orders.GrossTotal >= '1000' THEN mds_orders.GrossTotal END) AS 'gtr1k',
SUM(mds_orders.GrossTotal) AS 'total'
FROM mds_orders
JOIN restaurant_master
ON mds_orders.RestaurantID = restaurant_master.PKID
WHERE mds_orders.OrderDate BETWEEN '".$date_from." 00:00:00' AND '".$date_to." 23:59:59'
GROUP BY restaurant_master.code, restaurant_master.name";
$result = mysql_query($sql)
or die("SELECT Error: ".mysql_error());
$num_rows = mysql_num_rows($result);
$i = 0;
if (mysql_num_rows($result) >0) {
while ($row = mysql_fetch_array($result,MYSQL_ASSOC)){
$csv .= $row['code'].",".
$row['name'].",".
$row['less100'].",".
$row['less200'].",".
$row['less300'].",".
$row['less400'].",".
$row['less500'].",".
$row['less600'].",".
$row['less700'].",".
$row['less800'].",".
$row['less900'].",".
$row['less1k'].",".
$row['gtr1k'].",".
$row['total'].","."<br>";
?>
<tr>
<td><?php echo $row['code'];?></td>
<td><?php echo $row['name'];?></td>
<td><?php echo $row['less100'];?></td>
<td><?php echo $row['less200'];?></td>
<td><?php echo $row['less300'];?></td>
<td><?php echo $row['less400'];?></td>
<td><?php echo $row['less500'];?></td>
<td><?php echo $row['less600'];?></td>
<td><?php echo $row['less700'];?></td>
<td><?php echo $row['less800'];?></td>
<td><?php echo $row['less900'];?></td>
<td><?php echo $row['less1k'];?></td>
<td><?php echo $row['gtr1k'];?></td>
<td><?php echo $row['total'];?></td>
</tr>
</tr>
</tr>
<?php
}}}
?>
</form>
</body>
</html>
then the output of this should be the same when I do it to CodeIgniter, how can I do this..?
thank you and sorry again for my mistake.
