'); displayDJList(); print(''); djSearch(); print('


'); dpInterviewList(3); dpBlogList(); print(''); } //==================================================================== function selDJState($sel){ global $db; print('-- select a state --'); $result=mysql_query("select s.sort,s.state_name,s.state_id,count(*) as cnt". " from ref_state s,cz_members m,cz_members_dj d". " where m.state_id=s.state_id and m.mem_id=d.mem_id and d.active_flg=1". " group by s.sort,s.state_id,s.state_name". " order by s.sort,cnt desc",$db); $sort=0; while( ($rs=mysql_fetch_array($result)) ){ $state=$rs['state_name']; if($state=="Not Applicable")$state="International"; print(''.$state.' ('.$rs['cnt'].')'); } mysql_free_result($result); print(''); } //======================================================= function djSearch(){ print('

	'); print(' '); selDJState($_GET['state']); ?> [view all djs]

'); print(''); print(''); print(''); } //======================================================= function displayDJList(){ print(""); print(''); print('

'); print(''); } //======================================================= //####################################################### //======================================================= //============================================================================== function djProfilePage(){ print('

'); displayDJProfile($_GET['id']); print('

'); print(' '); dpDJList(2); dpInterviewList(2); print('

'); } //============================================================== function displayDJProfile($mid){ GLOBAL $db,$rootdir; if($mid==""){print("

NO ID GIVEN

");return;} $result=mysql_query("select m.mem_id,m.username,m.dob,m.gender,m.ethnicity,d.* from cz_members m left join cz_members_dj d on m.mem_id=d.mem_id where m.mem_id=".$mid,$db); if( ($rs=mysql_fetch_array($result)) ){ $smtstr="Create"; if($rs['dj_name']!='')$smtstr="Update"; $st_dt=fmtdate("F Y",$rs['dj_startdt']); $djpix=$rs['dj_photo']; if($djpix==""){ if($rs['gender']==1)$djpix="nonem.gif";else$djpix="nonef.gif";} print('

DJ Profile
	< < view all djs '); if($rs['real_name']!="")print(''); print(' '); if($rs['website1']!="" || $rs['website2']!="" || $rs['website3']!=""){ print(''); } if( ($mdes=$rs['t_music_desc'])!="")$mdes="-- ".$mdes; if( ($edes=$rs['t_equip_desc'])!="")$edes="-- ".$edes; if($mem_id==""){ $djemail='-- please register to view --'; $djphone='-- please register to view --'; } else{ $djphone=$rs['phone']; $djemail=''.$rs['email'].''; } $cdt=fmtdate("D, M j,Y",$rs['create_dt']); $udt=fmtdate("D, M j,Y",$rs['update_dt']); print(''); if($cdt!=$udt)print(''); print('  DJ Name '.$rs['dj_name'].'  Real Name '.$rs['real_name'].'  Ethnicity '.$rs['ethnicity'].'  From/Hometown '.$rs['hometown'].'  Websites: '); for($i=1;$i<=3;$i++)if($rs['website'.$i]!="")print(''.$rs['website_name'.$i].' '); print('  created on '.$cdt.'  updated on '.$udt.'
Information
Crews/Affilations	'.diptext($rs['aff']).'
Residencies	'.diptext($rs['resident']).'
Type of music you spin?	'.$rs['t_music_text'].' '.$mdes.'
Type of equipment can you provide?	'.$rs['t_equip_text'].' '.$edes.'
DJ Interview
When did you start DJing?	'.$st_dt.'
Bio   - tell us about yourself	'.diptext($rs['bio']).'
How did you get into DJing?	'.diptext($rs['q1']).'
What do you love most about DJing?	'.diptext($rs['q2']).'
What is your most memorable DJing  experience?	'.diptext($rs['q3']).'
What are you future goals as a DJ?	'.diptext($rs['q4']).'
What do you do when you are not  DJing?	'.diptext($rs['q5']).'
Shout outs!	'.diptext($rs['shouts']).'
Booking Info
Contact Name	'.$rs['contact_name'].'
Phone	'.$djphone.'
Email	'.$djemail.'

'); } mysql_free_result($result); } //========================================================= function diptext($s){return str_replace("\n","
",trim($s));} //========================================================= ?>