query($sql); // get DJs $sql = 'SELECT dj_id, type_id, name, picture FROM djs WHERE priority < 5 ORDER BY type_id, priority, dj_id'; $djs = $db->query($sql); // diplay data if($_GET['dj_id']) { $sql = 'SELECT dj_id, type, name, picture, description, note FROM djs, dj_types WHERE dj_id='.$_GET['dj_id'].' AND djs.type_id = dj_types.type_id'; $result = $db->query($sql); $thedj = $result->fetch_assoc(); echo ''."\n"; echo '
'; $types->data_seek(0); while($type = $types->fetch_assoc()) { echo '
'; $djs->data_seek(0); while($dj = $djs->fetch_assoc()) { if($dj['type_id'] == $type['type_id']) { echo '
'.$dj['name'].'
'.$dj['name'].'
'."\n"; } } echo '
'."\n"; echo '
'; } echo '
'; // display selected dj echo '
'; // get associations for given DJ $sql = 'SELECT name, website FROM associations, associates WHERE dj_id='.$thedj['dj_id'].' AND associations.associate_id = associates.associate_id ORDER BY priority'; $result = $db->query($sql); echo $thedj['picture'] ? ''.$thedj['name'].'
'; echo '

'.$thedj['name'].' ('.$thedj['type'].')

'; echo $thedj['note'] ? '

'.$thedj['note'].'

' : ''; if($result->num_rows) { echo '

'; } echo $thedj['description'] ? '

'.$thedj['description'].'

' : ''; echo '

'."\n".'
'; // get links for given DJ $sql = 'SELECT link, title FROM dj_links WHERE dj_id='.$thedj['dj_id'].' ORDER BY priority'; $result = $db->query($sql); if($result->num_rows) { echo '

'.$thedj['name'].'\'s links:

'; echo ''; } echo '
'; echo '
'; } else { //display all DJs echo '
'; echo '

>> DJs <<

'; while($type = $types->fetch_assoc()) { echo '
'; // echo '

'.$type['type'].'

'."\n".'
'; $djs->data_seek(0); while($dj = $djs->fetch_assoc()) { if($dj['type_id'] == $type['type_id']) { echo '
'.$dj['name'].'
'.$dj['name'].'
'."\n"; } } echo '
'."\n"; echo '
'; } echo '
'; } //include bottom include_once('bottom.php'); ?>