Hi all
I want to select 3 random category from database
then select 4 random product from each category
This code should have minimum query and request from data base!
The database is mySql.
any one have any suggestion ?!
The previous Code is :
$link = mysql_connect('localhost', 'user', 'password');
$Rcats = mysql_query(" SELECT DISTINCT `main_categories_id` AS
`categories_id`
FROM selected_products
WHERE 1
ORDER BY RAND(NOW()) LIMIT
3;",$link);
while ($Rcats_array = mysql_fetch_assoc($Rcats )) {
$cats [] = array ('categories_id' => $Rcats_array['categories_id']);
}
////////////// and three times repeat this :
mysql_query("INSERT INTO random_products (`products_id` ,
`products_image` , `products_price` , `products_name` ,
`categories_name` , `categories_id` , `categories_rank`)
SELECT DISTINCT
products.products_id , products.products_image,
products.products_price ,products_description.products_name ,
categories_description.categories_name,
categories_description.categories_id ,
categories_description.categories_rank
FROM products ,
products_description , selected_products ,
categories_description
WHERE products.`products_id` =
selected_products.`products_id`
AND
products.`products_quantity` > 0
AND products.`products_status`
= '1'
AND products.`products_id` =
products_description.`products_id`
AND
categories_description.categories_id = ".$cats [0]
['categories_id']."
AND
selected_products.`main_categories_id` = ".$cats [0]
['categories_id']."
ORDER BY RAND(NOW())
LIMIT 4;",$link);
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
