$show_product = 'SELECT p.products_id,p.products_model,p.products_price, p.products_image, ps.specials_new_products_price,pd.products_name,pd.products_description,cd.categories_description,cd.categories_id FROM products p LEFT JOIN specials ps ON ps.products_id = p.products_id LEFT JOIN products_description pd ON pd.products_id = p.products_id LEFT JOIN products_to_categories pc ON pc.products_id = p.products_id LEFT JOIN categories_description cd ON cd.categories_id = pc.categories_id order by rand()'; $show_product_handle = $db->Execute($show_product,18);
while (!$show_product_handle->EOF) {
$show_product_content[] = array( 'id'=>$show_product_handle->fields['products_id'], 'product_name'=>$show_product_handle->fields['products_name'], 'products_description'