select page_id,mode from pages
    where substring_index(pages.name,'/',-1)='main.php'

	select page_id from pages
	    where 
	    substring_index(pages.name,'/',-1)='main.php'

    select title,header,footer,background,length(bg_image),
	font_color,font_size,length(header_img),meta
    from pages
    where page_id=''

    select /*length(header),*/header_align,length(footer),footer_align,
	header_html,footer_html,length(logo),toptable_color,bottomtable_color,
	topnav_textcolor,topnav_color,
	textmain,length(mainimg),length(mainimg2),toptable_color,bottomtable_color,
	length(main_footer),main_footer_align
    from navlinks

    select /*top_navigation,topnav_color,topnav_textcolor,*/
	links_color,powered/*,length(powered_img),*/navbutton_bg,powered_bg
    from config

select name,url from links
		     where name<>'' and url<>''
		     order by link_id asc

	select name,url,color from navigation
	where active=1 and pub='1'
	order by sort asc

Powered by: Web Page Design Pro