// RANDOM PRODUCT IMAGE
$resultID = mysql_query("SELECT pi.product_name_en ,pi.company_id,pi.picture_filename,url FROM directory.product_info pi where pi.product_categories= 'Electrical & Electronic' ORDER BY rand() LIMIT 3", $linkID);
while($row = mysql_fetch_assoc($resultID))
{
//echo $row["picture_filename"];
echo " | ";
}
?>
| ...More |
|
// RANDOM BRANDING IMAGE
$resultID = mysql_query("SELECT ci.acc_reference,ci.picture_filename, ci.url FROM directory.product_info pi, directory.company_info ci WHERE ci.acc_reference = pi.company_id AND pi.product_categories = 'Electrical & Electronic' AND ci.picture_filename <> '' ORDER BY rand( ) LIMIT 3", $linkID);
while($row = mysql_fetch_assoc($resultID))
{
//echo $row["picture_filename"];
echo " | ";
}
?>
| ...More |
|