include_once('config.inc.php'); $prdid = $_REQUEST['prdid']; $productsPerRow =4; $cur_prds_rs = mysqli_query($dbcon,"select * from products where prdid='$prdid'"); $cur_prds = mysqli_fetch_array($cur_prds_rs); extract($cur_prds); $sub_cats_rs = mysqli_query($dbcon,"select * from sub_cats where sub_cat_id='$sub_cat_id'") or die(mysqli_error()); $sub_cats = mysqli_fetch_array($sub_cats_rs); $cur_mcat_id = $sub_cats['main_cat_id']; $subcat_rs = mysqli_query($dbcon,"select * from sub_cats where main_cat_id = '$cur_mcat_id' ORDER BY sorting_order") or die(mysqli_error()); $cur_main_cat_rs = mysqli_query($dbcon,"select * from main_cat where main_cat_id='$cur_mcat_id'"); $cur_main_cats = mysqli_fetch_array($cur_main_cat_rs); $banner = mysqli_query($dbcon,"select * from main_banner where mcat_id='$cur_mcat_id'")or die(mysqli_error()); // RELATED PRODUCTS $id = $cur_prds['sub_cat_id']; $rprdrs=mysqli_query($dbcon,"Select * from products where sub_cat_id='$id' group by art_no Having COUNT(*)>=1 ORDER BY RAND() LIMIT 4;"); $rnumrows=mysqli_num_rows($rprdrs); $rtotal_prds=$rnumrows; ?>