session_start(); include("general/config.php"); global $client; $sqlQuery="SELECT a.product_id, a.discount_price, a.description, a.stock_id, b.imagename, b.metal_type_id FROM ".$client."_product_details a, ".$client."_prd_image b WHERE a.product_id=b.product_id ORDER BY RAND() LIMIT 6 "; ?>
|
Search Wholesale Loose Diamonds,
Diamond Engagement Rings & Wedding Bands at DiamondonNet |
$rsResult=mysql_query($sqlQuery) or die("No Records...");
if(mysql_num_rows($rsResult)>0){
while($rcResult=mysql_fetch_array($rsResult)){
$rsResult2="SELECT sub_category_id FROM ".$client."_prd_sub_category WHERE product_id='".$rcResult['product_id']."' ";
$rsResult2=mysql_query($sqlQuery) or die("No Records...");
if(mysql_num_rows($rsResult2)>0){
$rcResult2=mysql_fetch_array($rsResult2);
$title=explode('~',$rcResult['description']);
echo "