Hjælp til enkel kode
Hej eksperter.kan denne kode:
<?
if ($id == "") {
$sql_oeko_tjek = mysql_query("SELECT * FROM ansatte WHERE ansat_by = 1 AND medrang = 1 ORDER BY id ASC");
} else {
$sql_oeko_tjek = mysql_query("SELECT * FROM ansatte WHERE ansat_by = $id AND medrang = 1 ORDER BY id ASC");
}
if ($id == "") {
$antal_oeko_tjek = mysql_result(mysql_query("SELECT COUNT(*) FROM ansatte WHERE ansat_by = 1 AND medrang = 1"),0);
} else {
$antal_oeko_tjek = mysql_result(mysql_query("SELECT COUNT(*) FROM ansatte WHERE ansat_by = $id AND medrang = 1"),0);
}
if (mysql_num_rows($sql_oeko_tjek)==0) {
echo "";
} else {
echo "<tr>
<td colspan=\"3\"> </td>
</tr>
<tr>
<td height=\"19\" bgcolor=\"#D1DD10\" class=\"main_txt\"><div align=\"right\" class=\"top_oversk\">Økonomiafdeling </div></td>
</tr>
<tr>
<td valign=\"top\" bgcolor=\"#E3E3E3\" class=\"main_txt\" align=\"center\">";
require "db.php";
if ($antal_oeko_tjek > 2) {
$cols = "3";
$i = 0;
$a = 0;
print "<table cellspacing=\"8\" class=\"email\" width=\"100%\" align=\"center\"><tr>";
while($row = mysql_fetch_array($sql_oeko_tjek)) {
if ($num == $a) {
$rest = $cols-$i;
$navn = $row['navn'];
$email = $row['email'];
$stilling = $row['stilling'];
$tlfnr = $row['tlfnr'];
$upfile = $row['upfile'];
echo "<td colspan=\"2\" width=\"33%\" align=\"center\">"; ?>
<?php if (!empty($row['upfile'])) { echo "<img src=\"$upfile\" width=\"88\" height=\"104\" class=\"border_pic\"><br><b>$navn</b><br>$stilling<br /><a href=\"mailto:$email\">$email</a><br>$tlfnr"; } else { echo "<img src=\"images/intet_pic.gif\" width=\"88\" height=\"104\" class=\"border_pic\"><br><b> $navn</b><br> $stilling<br><a href=\"mailto:$email\"> $email</a><br>$tlfnr"; } echo"</td>";
} else {
echo"<td colspan=\"2\" width=\"33%\" align=\"center\">"; ?>
<?php if (!empty($row['upfile'])) { echo "<img src=\"$upfile\" width=\"88\" height=\"104\" class=\"border_pic\"><br><b>$navn</b><br>$stilling<br /><a href=\"mailto:$email\">$email</a><br>$tlfnr"; } else { echo "<img src=\"images/intet_pic.gif\" width=\"88\" height=\"104\" class=\"border_pic\"><br><b> $navn</b><br> $stilling<br><a href=\"mailto:$email\"> $email</a><br>$tlfnr"; } echo"</td>";
$a++;
}
$i++;
if ($i == $cols) {
echo "</tr><tr>";
$i = 0;
}
}
print "<td colspan=\"$cols\"> </td>\n</tr>\n</table>\n";
} else {
$cols = "2";
$i = 0;
$a = 0;
print "<table cellspacing=\"12\" width=\"100%\" class=\"email\" align=\"center\"><tr>";
while($row = mysql_fetch_array($sql)) {
if ($num == $a) {
$rest = $cols-$i;
$navn = $row['navn'];
$email = $row['email'];
$stilling = $row['stilling'];
$tlfnr = $row['tlfnr'];
$upfile = $row['upfile'];
echo "<td colspan=\"2\" width=\"50%\" align=\"center\">"; ?>
<?php if (!empty($row['upfile'])) { echo "<img src=\"$upfile\" width=\"88\" height=\"104\" class=\"border_pic\"><br><b>$navn</b><br>$stilling<br /><a href=\"mailto:$email\">$email</a><br>$tlfnr"; } else { echo "<img src=\"images/intet_pic.gif\" width=\"88\" height=\"104\" class=\"border_pic\"><br><b> $navn</b><br> $stilling<br><a href=\"mailto:$email\"> $email</a><br>$tlfnr"; } echo"</td>";
} else {
echo"<td colspan=\"2\" width=\"50%\" align=\"center\">"; ?>
<?php if (!empty($row['upfile'])) { echo "<img src=\"$upfile\" width=\"88\" height=\"104\" class=\"border_pic\"><br><b>$navn</b><br>$stilling<br /><a href=\"mailto:$email\">$email</a><br>$tlfnr"; } else { echo "<img src=\"images/intet_pic.gif\" width=\"88\" height=\"104\" class=\"border_pic\"><br><b> $navn</b><br> $stilling<br><a href=\"mailto:$email\"> $email</a><br>$tlfnr"; } echo"</td>";
$a++;
}
$i++;
if ($i == $cols) {
echo "</tr><tr>";
$i = 0;
}
}
print "<td colspan=\"$cols\"> </td>\n</tr>\n</table>\n";
}
echo"</td>
</tr>";
}
?>
gøres mindre på nogen måde??
