All pastes #512070 Raw Edit

Mine

public text v1 · immutable
#512070 ·published 2007-05-26 18:22 UTC
rendered paste body
<?php 
require_once('../../Connections/ghostlicense.php'); 
require_once('../../Connections/Shopping.php');
mysql_select_db($database_Shopping, $Shopping);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Orders</title>
  <script charset='UTF-8' src='menu.js' type='text/javascript'></script>
  <script type='text/javascript'>awmBuildMenu();</script>
  <!-- ******** END CODE FOR menu ******** -->
  <style type="text/css">
body {
	background-color:#FFFFD5;
}
FORM {
font-family: Verdana, Arial, Helvetica, sans-serif;
color: #000080;
border: 2px solid #4682B4;
padding: 5px;
background-color: #0099CC;
}
table {
font-family: Verdana, Arial, Helvetica, sans-serif;
color: #000080;
border-color: #0066CC;
background-color: #0099CC;
}
td {
font-size:10px;
background-color:#FFFFCC;
}
</style></head>
<table>
<?php
$var1 = "query_hunting_tickets_sold";
$var2 = "hunting_tickets_total";
$var3 = "'Ghost Hunting%'";
$var4 = "hunting_tickets_sold";
$var5 = "row_hunting_tickets_sold";
$value = "51.75";

function writedata(){
	global $var1, $var2, $var3, $var4, $var5, $value;
$var1 = "
  SELECT
    CubeCart_order_inv.name,
    CubeCart_order_sum.cart_order_id,
    CubeCart_order_sum.time,
    CubeCart_order_inv.cart_order_id,
    SUM(CubeCart_order_sum.prod_total) as $var2
  FROM
    CubeCart_order_sum,
    CubeCart_order_inv
  WHERE 
    (CubeCart_order_inv.name LIKE $var3)
    AND 
    (CubeCart_order_sum.cart_order_id = CubeCart_order_inv.cart_order_id) 
  GROUP BY 
    CubeCart_order_inv.name";
$var4 = mysql_query($var1, $Shopping) or die(mysql_error());
while ($var5 = mysql_fetch_array($var4)){
?>

  <tr>
    <td>
	  <?php echo $var5['name'] ; ?>
	</td>
	<td>
      $<?php echo $var5[$var2] ; ?>
	</td>
	<td>
	  <?php echo round($var5[$var2] / $value) ; ?>
    </td>
  </tr>
<?php 
}
}
writedata();
?>
</table>