State Owned

0 && state_owned = '1'"); $getnumrows = mysql_num_rows($getinfo); if($getnumrows < 0) { echo "Sorry, but there's no jobs currently available."; }else{ while($r = mysql_fetch_array($getinfo)){ $getmoreinfo = mysql_query("SELECT * FROM jobs_corps WHERE id = '$r[corp_id]'"); $s = mysql_fetch_array($getmoreinfo); echo ''.$r['motto'].'
Employer: '.$s['corp_name'].'
Vacancies: '.$r['open_spots'].'
Salary: '.$r['pay'].'
Apply Here

'; } } ?>

Public Businesses

0 && state_owned = '0'"); $getnumrows = mysql_num_rows($getinfo); if($getnumrows < 0) { echo "Sorry, but there's no jobs currently available."; }else{ while($r = mysql_fetch_array($getinfo)){ $getmoreinfo = mysql_query("SELECT * FROM jobs_corps WHERE id = '$r[corp_id]'"); $s = mysql_fetch_array($getmoreinfo); echo ''.$r['motto'].'
Employer: '.$s['corp_name'].'
Vacancies: '.$r['open_spots'].'
Salary: '.$r['pay'].'
Apply Here

'; } } ?>

My Job

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'].'
'; } } } ?>