=CURRENT_DATE ORDER BY rand() LIMIT 3";
//$query_news_item = "SELECT news.id, news.dateNews, news.title FROM news WHERE news.dateStart<=CURRENT_DATE AND news.dateExpire>=CURRENT_DATE AND news.clr='Y' AND news.delflag='N' ORDER BY rand() LIMIT 3";
$news_item = mysql_query($query_news_item, $news) or die(mysql_error());
$row_news_item = mysql_fetch_assoc($news_item);
$totalRows_news_item = mysql_num_rows($news_item);
mysql_select_db($database_news, $news);
$query_events = "SELECT events.eventID, events.title, events.dateEvent FROM events Inner Join events_distribution ON events.eventID = events_distribution.event_id WHERE events_distribution.dist_name='$distribution' AND events.delflag='N' AND events.dateAnounce <=CURRENT_DATE AND events.dateEvent >=CURRENT_DATE ORDER BY rand() LIMIT 3";
//$query_events = "SELECT events.eventID, events.title, events.dateEvent FROM events WHERE events.dateAnounce <=CURRENT_DATE AND events.clr='Y' AND events.dateEvent>=CURRENT_DATE AND events.delflag='N' ORDER BY rand() LIMIT 3";
$events = mysql_query($query_events, $news) or die(mysql_error());
$row_events = mysql_fetch_assoc($events);
$totalRows_events = mysql_num_rows($events);
for ($x=1; $x<=3; $x++) {
//$z=0;
if ($x<=$totalRows_news_item) {
$news_itemandevents[$x]['ty']="N";
$news_itemandevents[$x]['id']=$row_news_item['id'];
$news_itemandevents[$x]['dt']=$row_news_item['dateNews'];
$news_itemandevents[$x]['t1']=$row_news_item['title'];
$row_news_item = mysql_fetch_assoc($news_item);
$x++;
}
if ($x<=$totalRows_events) {
$news_itemandevents[$x]['ty']="E";
$news_itemandevents[$x]['id']=$row_events['eventID'];
$news_itemandevents[$x]['dt']=$row_events['dateEvent'];
$news_itemandevents[$x]['t1']=$row_events['title'];
$row_events = mysql_fetch_assoc($events);
}
/*if ($z>1)
$x++;
*/}
mysql_select_db($database_clr_rd, $clr_rd);
$query_promo = "SELECT * FROM hp_promo WHERE ((hp_promo.date_start <=CURRENT_DATE) OR (hp_promo.date_start IS NULL)) AND ((hp_promo.date_end >=CURRENT_DATE) OR (hp_promo.date_end IS NULL)) AND hp_promo.make_live='Y' ORDER BY rand() LIMIT 1";
$promo = mysql_query($query_promo, $clr_rd) or die(mysql_error());
$row_promo = mysql_fetch_assoc($promo);
$totalRows_promo = mysql_num_rows($promo);
?>