|
|
|
10 and outofstock=0 ORDER BY rand() limit 12 ";
$res_product_u=mysqli_query($linkdb,$qt_product_u);
$num_product_u=mysqli_num_rows($res_product_u);
$mn=$num_add_rzd%4;
echo '
';
for($i=0;$i<$num_product_u;$i++) {
$razd_name_key=returnParent_key(mysqli_result($res_product_u,$i,'parent_id'));
$product_id=@mysqli_result($res_product_u,$i,'pr_id');
$qt_product_photo="SELECT * from cofi_product_photo where product_id='$product_id' order by head_photo DESC, id ASC limit 0,1";
$res_product_photo=mysqli_query($linkdb,$qt_product_photo);
$num_product_photo=mysqli_num_rows($res_product_photo);
if($i%4==0 && $i!=0)
print ' ';
echo ' ';
if($num_product_photo){
echo '.' "'.mysqli_result($res_product_u,$i,'drink_name').'")
';}
else echo ' ';
echo ''.mysqli_result($res_product_u,$i,'drink_name').'
'.mysqli_result($res_product_u,$i,'cena').' руб. | ';
if($i==($num_add_rzd-1) && $mn!=0)
{
for($j=0;$j<(4-$mn);$j++)
print ' | ';
}
}
?>
| ';
for($i=0;$i<$num_product_u;$i++) {
$razd_name_key=returnParent_key(mysqli_result($res_product_u,$i,'parent_id'));
$product_id=@mysqli_result($res_product_u,$i,'pr_id');
$qt_product_photo="SELECT * from cofi_product_photo where product_id='$product_id' order by head_photo DESC, id ASC limit 0,1";
$res_product_photo=mysqli_query($linkdb,$qt_product_photo);
$num_product_photo=mysqli_num_rows($res_product_photo);
if($i%4==0 && $i!=0)
print ' ';
echo ' ';
if($num_product_photo){
echo '
';}
else echo '';
echo ''.mysqli_result($res_product_u,$i,'drink_name').'
'.mysqli_result($res_product_u,$i,'cena').' руб. ';
if(@mysqli_result($res_product_u,$i,'cena_akcia'))echo ' '.@mysqli_result($res_product_u,$i,'cena_akcia').' руб.';
echo ' | ';
if($i==($num_add_rzd-1) && $mn!=0)
{
for($j=0;$j<(4-$mn);$j++)
print ' | ';
}
}
?>
|
|