$sql = "select * from jobs where aktiv='yes' order by date_created DESC, date_modified DESC, ueb";
$result = $db->query($sql);
$anz = $db->num_rows();
if ($anz && $anz > 0) {
?>
for ($i=0;$i<$anz;$i++) {
$id = mysql_result($result,$i,"id");
$ueb = mysql_result($result,$i,"ueb");
$txt = mysql_result($result,$i,"txt");
$img = mysql_result($result,$i,"img_id");
$file = mysql_result($result,$i,"file_id");
if (!$SID && $i == 0) {
$style = "topnav1";
$txt1 = $txt;
$img_1 = $img;
$file_1 = $file;
} else if ($SID == $id) {
$style = "topnav1";
} else {
$style = "topnav";
}
?>
•
=$ueb;?>
|
|
}
if ($img_1!="") {
$sql = "select * from images where id=$img_1 and category='jobs'";
$result = $db->query($sql);
$anz = $db->num_rows();
if ($anz > 0) {
$image = mysql_result($result,0,"img_name");
$image_big = mysql_result($result,0,"big_img_name");
if (!file_exists("cms/upload/jobs/".$image)) {
$image = "";
}
if (!file_exists("cms/upload/jobs/".$image_big)) {
$image_big = "";
}
}
}
if ($file_1!="") {
$sql = "select * from files where id=$file_1 and category='jobs'";
$result = $db->query($sql);
$anz = $db->num_rows();
if ($anz > 0) {
$file = mysql_result($result,0,"file_name");
if (!file_exists("cms/upload/jobs/".$file)) {
$file = "";
}
}
}
?>
if (!$SID || $SID == "") {
echo $txt1;
if ($image!="" || $file!="") {
?>
}
}
else {
$sql = "select * from jobs where aktiv='yes' and id='$SID' order by date_created DESC, date_modified DESC, ueb";
$result = $db->query($sql);
$anz = $db->num_rows();
if ($anz && $anz > 0) {
$txt = mysql_result($result,0,"txt");
$img = mysql_result($result,0,"img_id");
$file = mysql_result($result,0,"file_id");
if ($img!="") {
$sql = "select * from images where id=$img and category='jobs'";
$result = $db->query($sql);
$anz = $db->num_rows();
if ($anz > 0) {
$image = mysql_result($result,0,"img_name");
$image_big = mysql_result($result,0,"big_img_name");
if (!file_exists("cms/upload/jobs/".$image)) {
$image = "";
}
if (!file_exists("cms/upload/jobs/".$image_big)) {
$image_big = "";
}
}
}
if ($file!="") {
$sql = "select * from files where id=$file and category='jobs'";
$result = $db->query($sql);
$anz = $db->num_rows();
if ($anz > 0) {
$file = mysql_result($result,0,"file_name");
if (!file_exists("cms/upload/jobs/".$file)) {
$file = "";
}
}
}
echo $txt;
if ($image!="" || $file!="") {
?>
}
} else {
echo $txt1;
if ($image!="" || $file!="") {
?>
}
}
}
?>
|
}
else {
?>
!! Derzeit sind leider
keine Stellenausschreibungen vorhanden !!
|
}
?>
|