Customer group ID

Code: Select all

<?php
require_once('../../../config.php');
require_once(DIR_SYSTEM . 'startup.php');
$db = new DB(DB_DRIVER, DB_HOSTNAME, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
$q=$_GET["q"];
$resultado = mysql_query("SELECT * FROM product WHERE model LIKE '%" . $q . "%'");
while($row = mysql_fetch_array($resultado))
  {
 $special_query = mysql_query("SELECT * FROM product_special WHERE product_id LIKE '%" . $row['product_id'] . "%' AND customer_group_id LIKE '%" . $this->customer->getCustomerGroupId . "%'");
 $row_s = mysql_fetch_array($special_query);
if ($row['quantity'] > 0) {
$disponible = 7;
$stock_query = mysql_query("SELECT * FROM stock_status WHERE stock_status_id LIKE '%" . $disponible . "%'");
$stock = mysql_fetch_array($stock_query);
$rstock = $stock['name'];
}
if ($row['price']) { 
echo '<div class="price">';      
 if (!$row_s['price']) { 
echo '<span>';
echo 'Precio: ';
echo '</span>'; 
echo $row['price']; 
} else { 
echo '<span>';
echo 'Precio: ';
echo '</span>';
echo '<span class="price-new">';
echo $row_s['price'];
echo '</span>';
} 
echo '</div>';
 } 
echo '<div class="actions">';
echo '<div class="cart">';
 if ($row['price']) { 
echo $rstock; 
echo '<br>';
 } 

 echo 'Cantidad: ';
 echo '<input type="text" name="quantity" value="" class="input-mini" id="quantity-'.$row['product_id'].'">';
 if ($rstock !== "Sin disponibilidad") { 
echo '<br><input id="boton" name="boton" type="button" value="Añadir a la cesta" onclick="addQtyToCart(';
echo "'";
echo $row['product_id'];
echo "'";
echo ');" class="btn btn-cart btn-small" />';
 } 
echo '</div>';
echo '</div>';
}
?>