select allow_resume_modify,allow_retrieve_pw from job_config

select page_id,mode,navgroup,length(header_img),last_visit<'2008-08-01' from pages
                 where substring_index(pages.name,'/',-1)='resume_login.php'

	    select page_id,navgroup,length(header_img),last_visit<'2008-08-01' from pages
	        where (mode='' or mode is null) and
	        substring_index(pages.name,'/',-1)='resume_login.php'

    select title,header,footer,background,length(image1),
	length(image2),length(image3),length(image4),length(image5),
	length(bg_image),
	font_color,font_size,
	table_color,meta
    from pages_properties
    where pages_properties.page_id=''

    select length(header),header_align,length(footer),footer_align,
	header_html,footer_html,length(logo),
	top_navigation,topnav_textcolor,links_color,
	toptable_color,bottomtable_color,
	textmain,length(mainimg),length(mainimg2),length(main_footer),
	main_footer_align
    from navlinks where navgroup=''

    update pages set hits=hits+1,last_visit=now()
    where page_id=''

    select navbutton_bg,powered_bg from config

	select allow_register,featured from job_config

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

Job Categories SQL error (Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)) in ( select category_id,name from job_categories where active=1 order by sort asc ) Search Advanced Search Please enter your login and password Email: Password:

Powered by Omnistar Recruiter