Untitled

<p>Products</p>
<p>&nbsp;</p>
<?php virtual('/alpweb-new/Connections/rsZenCart.php'); ?>
<table border="1">
  <tr>
    <td>products_id</td>
    <td>products_type</td>
    <td>products_quantity</td>
    <td>products_model</td>
    <td>products_image</td>
    <td>products_price</td>
    <td>products_virtual</td>
    <td>products_date_added</td>
    <td>products_last_modified</td>
    <td>products_date_available</td>
    <td>products_weight</td>
    <td>products_status</td>
    <td>products_tax_class_id</td>
    <td>manufacturers_id</td>
    <td>products_ordered</td>
    <td>products_quantity_order_min</td>
    <td>products_quantity_order_units</td>
    <td>products_priced_by_attribute</td>
    <td>product_is_free</td>
    <td>product_is_call</td>
    <td>products_quantity_mixed</td>
    <td>product_is_always_free_shipping</td>
    <td>products_qty_box_status</td>
    <td>products_quantity_order_max</td>
    <td>products_sort_order</td>
    <td>products_discount_type</td>
    <td>products_discount_type_from</td>
    <td>products_price_sorter</td>
    <td>master_categories_id</td>
    <td>products_mixed_discount_quantity</td>
    <td>metatags_title_status</td>
    <td>metatags_products_name_status</td>
    <td>metatags_model_status</td>
    <td>metatags_price_status</td>
    <td>metatags_title_tagline_status</td>
    <td>products_id</td>
    <td>language_id</td>
    <td>products_name</td>
    <td>products_description</td>
    <td>products_url</td>
    <td>products_viewed</td>
  </tr>
  <?php do { ?>
    <tr>
      <td><?php echo $row_products['products_id']; ?></td>
      <td><?php echo $row_products['products_type']; ?></td>
      <td><?php echo $row_products['products_quantity']; ?></td>
      <td><?php echo $row_products['products_model']; ?></td>
      <td><?php echo $row_products['products_image']; ?></td>
      <td><?php echo $row_products['products_price']; ?></td>
      <td><?php echo $row_products['products_virtual']; ?></td>
      <td><?php echo $row_products['products_date_added']; ?></td>
      <td><?php echo $row_products['products_last_modified']; ?></td>
      <td><?php echo $row_products['products_date_available']; ?></td>
      <td><?php echo $row_products['products_weight']; ?></td>
      <td><?php echo $row_products['products_status']; ?></td>
      <td><?php echo $row_products['products_tax_class_id']; ?></td>
      <td><?php echo $row_products['manufacturers_id']; ?></td>
      <td><?php echo $row_products['products_ordered']; ?></td>
      <td><?php echo $row_products['products_quantity_order_min']; ?></td>
      <td><?php echo $row_products['products_quantity_order_units']; ?></td>
      <td><?php echo $row_products['products_priced_by_attribute']; ?></td>
      <td><?php echo $row_products['product_is_free']; ?></td>
      <td><?php echo $row_products['product_is_call']; ?></td>
      <td><?php echo $row_products['products_quantity_mixed']; ?></td>
      <td><?php echo $row_products['product_is_always_free_shipping']; ?></td>
      <td><?php echo $row_products['products_qty_box_status']; ?></td>
      <td><?php echo $row_products['products_quantity_order_max']; ?></td>
      <td><?php echo $row_products['products_sort_order']; ?></td>
      <td><?php echo $row_products['products_discount_type']; ?></td>
      <td><?php echo $row_products['products_discount_type_from']; ?></td>
      <td><?php echo $row_products['products_price_sorter']; ?></td>
      <td><?php echo $row_products['master_categories_id']; ?></td>
      <td><?php echo $row_products['products_mixed_discount_quantity']; ?></td>
      <td><?php echo $row_products['metatags_title_status']; ?></td>
      <td><?php echo $row_products['metatags_products_name_status']; ?></td>
      <td><?php echo $row_products['metatags_model_status']; ?></td>
      <td><?php echo $row_products['metatags_price_status']; ?></td>
      <td><?php echo $row_products['metatags_title_tagline_status']; ?></td>
      <td><?php echo $row_products['products_id']; ?></td>
      <td><?php echo $row_products['language_id']; ?></td>
      <td><?php echo $row_products['products_name']; ?></td>
      <td><?php echo $row_products['products_description']; ?></td>
      <td><?php echo $row_products['products_url']; ?></td>
      <td><?php echo $row_products['products_viewed']; ?></td>
    </tr>
    <?php } while ($row_products = mysql_fetch_assoc($products)); ?>
</table>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$maxRows_products = 10;
$pageNum_products = 0;
if (isset($_GET['pageNum_products'])) {
  $pageNum_products = $_GET['pageNum_products'];
}
$startRow_products = $pageNum_products * $maxRows_products;

mysql_select_db($database_rsZenCart, $rsZenCart);
$query_products = "SELECT * FROM products, products_description";
$query_limit_products = sprintf("%s LIMIT %d, %d", $query_products, $startRow_products, $maxRows_products);
$products = mysql_query($query_limit_products, $rsZenCart) or die(mysql_error());
$row_products = mysql_fetch_assoc($products);

if (isset($_GET['totalRows_products'])) {
  $totalRows_products = $_GET['totalRows_products'];
} else {
  $all_products = mysql_query($query_products);
  $totalRows_products = mysql_num_rows($all_products);
}
$totalPages_products = ceil($totalRows_products/$maxRows_products)-1;

mysql_free_result($products);
?>