'; while ($row = mysql_fetch_assoc($result)) { echo '

'.$row[p_title].'

'.$row[p_desc].'

'; $i++; if($i%3==1){ echo '

'; } } echo '

'; } } function get_project_list($id,$conn){ $sql="SELECT `pi_id`, `ptoject_id`, `img_s`, `img_o`, `desc`, `status` FROM `project_img` WHERE ptoject_id=".$id; if($result = mysql_query($sql)){ $i=0; $ret = array(); $i=1; echo '

'; while ($row = mysql_fetch_assoc($result)) { if($i%3==1){ } echo '

'.$row[desc].'

'; $i++; if($i%3==1){ echo '

'; } } echo '

'; } } function get_partners_list(){ $sql="SELECT `par_id`, `par_title`, `par_img1`, `par_img2` FROM `partners` WHERE 1 order by par_id asc"; if($result = mysql_query($sql)){ $i=0; $ret = array(); $i=1; echo '

'; while ($row = mysql_fetch_assoc($result)) { if($i%3==1){ } echo '

'; $i++; if($i%3==1){ echo '

'; } } echo '

'; } } function get_slider_list(){ $sql="SELECT `id`, `order`, `title`, `bigimg`, `smallimg`, `status` FROM `home_slider` WHERE 1 order by `order` asc"; if($result = mysql_query($sql)){ while ($row = mysql_fetch_assoc($result)) { echo '

'; } } } function get_slider_css(){ $sql="SELECT `id`, `order`, `title`, `bigimg`, `smallimg`, `status` FROM `home_slider` WHERE 1 order by `order` asc"; if($result = mysql_query($sql)){ $i=1; while ($row = mysql_fetch_assoc($result)) { if($i>1){ echo '.camera_pag_ul li:nth-child('.$i.') { background: url("../'.$row[smallimg].'"); }'; } $i++; } } } function get_slider_css1(){ $sql="SELECT `id`, `order`, `title`, `bigimg`, `smallimg`, `status` FROM `home_slider` WHERE 1 order by `order` asc limit 1"; if($result = mysql_query($sql)){ $row = mysql_fetch_assoc($result); echo $row[smallimg]; } } function selectpagemeta($page,$conn){ $query = "SELECT `page_id`, `page_name`, `page_title`, `page_desc`, `page_keywords`, `page_text1`, `page text2`, `lang` FROM `page_meta` WHERE `page_name` like '".$page."'"; $result = mysql_query( $query ) or die( 'error getting enum field ' . mysql_error() ); $a = array(); $row = mysql_fetch_array($result); return $row; } function print_nav_menu($page){ //here we insert navigation menu and highlight selected page ?>