new question for mysql

[pldtm]

i found a solution for my last post but i have now a new question.

How can i select 4 products with for exemple id as 34, 42,55 and 60 to show them on the main page.

here is my code for a single product:

<?php

if ($prod = tep_random_select("select p.products_id, pd.products_name, p.products_image from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.products_id='34' and p.products_id = pd.products_id "))

 $prod['products_name'] = tep_get_products_name($prod['products_id']);

 $featured_prod = "Les configurations ";

 $featured_info = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $prod["products_id"], 'NONSSL') . '">' . tep_image(DIR_WS_IMAGES . $prod['products_image'], $prod['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a>';



 $info_box_contents = array();

 $info_box_contents[] = array('align' => 'left',

                                      'text' => $featured_prod );



  new infoboxheading($info_box_contents, false, false);



 $info_box_contents = array();

 $info_box_contents[] = array('align' => 'left',

                               'text' => $featured_info );

 new infobox2($info_box_contents);

?>

 

Has anyone an idea???

[pldtm]

any idea????

[pldtm]

really no idea???