function debug($sql){
global $debug;
if($debug == 1)
print(stripslashes($sql) . "
");
}
function output($string, $size = "-1"){
print("" . stripslashes($string) . "");
}
$debug = 0;
$connection = mysql_connect("localhost", "c1305_waterjobs", "urbEek2Fabrern4I");
$db = mysql_select_db("c13057_waterjobs_com", $connection);
if($db)
{
?>
Agitators & Bioremediation People, Boiler Feed & Bottled Water People:
Get Jobs.
|
|
|
if(isset($HTTP_GET_VARS['number'])){
$sql = "select * from jobs where number=\"" . $HTTP_GET_VARS['number'] . "\"";
debug($sql);
if($success = mysql_query($sql, $connection) and mysql_num_rows($success) > 0){
$row = mysql_fetch_object ($success);
output("$row->title
\n", "");
output("Job Order # $row->number \n");
output("$row->location \n");
if ($row->travel != 0){output("$row->travel% Travel \n");}
print(" \n");
output(nl2br($row->description));
output("
\nReturn to Job Listings\n");
}
else{
output("You have come to this page in error. ");
output("Please click here to return to job listings.");
}
}
else{
?>
Job Name");?> |
Job Order #");?> |
Location");?> |
Travel");?> |
$sql = "select * from jobs";
debug($sql);
$success = mysql_query ($sql, $connection);
while ($row = mysql_fetch_object ($success)){
?>
$row->title");?>
|
number");?> |
location);?> |
travel != 0){output("$row->travel%");} else{output("N/A");}?> |
}?>
}?>
|
|
|
602 Violet St - Modesto, CA 95356 - (209)529-5051
|
}
?>