select username,date_format(join_date,'%m/%d/%Y') as join_date,replace(bio,char(13,10),'
') as bio,e_mail,date_format(last_updated,'%m%d%Y%h%i%p') as last_updated,verification from users where id=