name'"); $info = mysql_fetch_array($getinfo); if($info['corp_id'] == 0 || $info['job_rank'] == 0) { echo 'Sorry, but you do not have a job.'; }else{ $getmoreinfo = mysql_query("SELECT * FROM jobs_ranks WHERE corp_id = '".$info['corp_id']."' && job_rank = '$info[job_rank]'"); $moreinfo = mysql_fetch_array($getmoreinfo); $getevenmoreinfo = mysql_query("SELECT * FROM jobs_corps WHERE id = '$moreinfo[corp_id]'"); $s = mysql_fetch_array($getevenmoreinfo); echo ''.$moreinfo['motto'].'
Employer: '.$s['corp_name'].'
Salary: '.$moreinfo['pay'].'

Work room(s):'; $get_rooms = mysql_query("SELECT * FROM jobs_rooms WHERE rank_id = '".$info['secure_id']."'"); if($moreinfo['global'] == 1) { echo 'You can work in any room.'; } else { while ($get_rooms_info = mysql_fetch_array($get_rooms)) { echo $get_rooms_info['room_id'].'
'; } } } ?>