= UNIX_TIMESTAMP(CURDATE()) AND priority !=0 ORDER BY priority, UNIX_TIMESTAMP(eventdate) "; $result = mysql_query($query, $link); $num_news = mysql_num_rows($result); $news = array(); for($i=0; $i<$num_news; $i++){ $news[] = mysql_fetch_assoc($result); } // fetch the records $query = "SELECT * FROM seminars where (UNIX_TIMESTAMP(eventdate) >= UNIX_TIMESTAMP(CURDATE())) and display = 'Y' ORDER BY UNIX_TIMESTAMP(eventdate)"; // $query = "select * from tenders"; // echo $query; $query_result = mysql_query($query); $num_seminars = mysql_num_rows($query_result); // echo "Records:".$num_rows; $seminars = array(); for($i=0; $i<$num_seminars; $i++){ $seminars[] = mysql_fetch_assoc($query_result); } //------------------------------------------------------------------------ ?> Official Site of CUSAT
0 ) { ?>
News & Events

0 ) { ?>
Seminar