Query was emty
<?if (mysql_num_rows($query)==0) {}
else {
if(isset($_POST['submit'])) {
$max = $_POST['max'];
for ($i=1;$i<=$max;$i++) {
$id = $_POST['id'.$i];
$afdeling = $_POST['afdeling'.$i];
$navn = $_POST['navn'.$i];
$initial = $_POST['initial'.$i];
$kommentar = $_POST['kommentar'.$i];
$ak_bygning = $_POST['ak_bygning'.$i];
$ak_etage = $_POST['ak_etage'.$i];
$ak_rumnr = $_POST['ak_rumnr'.$i];
$ny_etage = $_POST['ny_etage'.$i];
$ny_rumnr = $_POST['ny_rumnr'.$i];
$ny_bordnr = $_POST['ny_bordnr'.$i];
$longitude = $_POST['longitude'.$i];
$latitude = $_POST['latitude'.$i];
mysql_query("UPDATE mop_seating SET afdeling ='". $afdeling ."', navn = '". $navn ."', initial = '". $initial ."', kommentar = '". $kommentar ."' , ak_bygning = '". $ak_bygning ."' , ak_etage = '". $ak_etage ."' , ak_rumnr = '". $ak_rumnr ."' , ny_bygning = '". $ny_bygning ."' , ny_etage = '". $ny_etage ."' , ny_rumnr = '". $ny_rumnr ."' , ny_bordnr = '". $ny_bordnr ."' , longitude = '". $longitude ."' , latitude = '" .$latitude ."' WHERE id = '" .$id. "'") or die(mysql_error());
echo "DEBUG: $sql<br>";
mysql_query($sql) or die(mysql_error());}
echo "<span class=\"style1\">Seating opdateres..<meta http-equiv=\"refresh\" content=\"0; url=mop_seating_liste_hel.php\"><br></span>
<object classid=\"clsid:d27cdb6e-ae6d-11cf-96b8-444553540000\" codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,0,0\" name=\"payoff\" width=\"24\" height=\"24\" align=\"middle\" id=\"payoff\">
<param name=\"allowScriptAccess\" value=\"sameDomain\" />
<param name=\"allowFullScreen\" value=\"false\" />
<param name=\"movie\" value=\"timeglas.swf\" />
<param name=\"quality\" value=\"high\" />
<param name=\"bgcolor\" value=\"#000000\" /><param name=\"LOOP\" value=\"false\" /><param name=\"SCALE\" value=\"noborder\" />
<embed src=\"timeglas.swf\" width=\"24\" height=\"24\" loop=\"false\" align=\"middle\" quality=\"high\" bgcolor=\"#000000\" name=\"payoff\" allowscriptaccess=\"sameDomain\" allowfullscreen=\"false\" type=\"application/x-shockwave-flash\" pluginspage=\"http://www.macromedia.com/go/getflashplayer\" scale=\"noborder\" />
</object>";}
else {
echo "<form method=\"POST\" name=\"mopseating\">";
echo "<table>\n";
echo"<table width=\"1200\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
<tr>
<td valign=\"bottom\" align=\"center\"><span class=\"style3\"><a href=\"mop_seating_liste_hel.php?sorte=navn\">N<br>a<br>v<br>n</a></span></td>
<td valign=\"bottom\" align=\"center\"><span class=\"style3\"><a href=\"mop_seating_liste_hel.php?sorte=afdeling\">A<br>f<br>d<br>e<br>l<br>i<br>n<br>g</a></span></td>
<td valign=\"bottom\" align=\"center\"><span class=\"style3\"><a href=\"mop_seating_liste_hel.php?sorte=initial\">I<br>n<br>i<br>t<br>i<br>a<br>l</a></span></td>
<td valign=\"bottom\" align=\"center\"><span class=\"style3\"><a href=\"mop_seating_liste_hel.php?sorte=kommentar\">K<br>o<br>m<br>m<br>e<br>n<br>t<br>a<br>r</a></span></td>
<td valign=\"bottom\" align=\"center\"><span class=\"style3\"><a href=\"mop_seating_liste_hel.php?sorte=ak_bygning\">A<br>k.<br><br>b<br>y<br>g<br>n<br>i<br>n<br>g</a></span></td>
<td valign=\"bottom\" align=\"center\"><span class=\"style3\"><a href=\"mop_seating_liste_hel.php?sorte=ak_etage\">A<br>k.<br><br>e<br>t<br>a<br>g<br>e</a></span></td>
<td valign=\"bottom\" align=\"center\"><span class=\"style3\"><a href=\"mop_seating_liste_hel.php?sorte=ak_rumnr\">A<br>k.<br><br>r<br>u<br>m<br>n<br>r</a></span></td>
<td valign=\"bottom\" align=\"center\"><span class=\"style3\"><a href=\"mop_seating_liste_hel.php?sorte=ny_bygning\">N<br>y<br><br>b<br>y<br>g<br>n<br>i<br>n<br>g</a></span></td>
<td valign=\"bottom\" align=\"center\"><span class=\"style3\"><a href=\"mop_seating_liste_hel.php?sorte=ny_etage\">N<br>y<br><br>e<br>t<br>a<br>g<br>e</a></span></td>
<td valign=\"bottom\" align=\"center\"><span class=\"style3\"><a href=\"mop_seating_liste_hel.php?sorte=ny_rumnr\">N<br>y<br>t<br><br>r<br>u<br>m<br>n<br>r</a></span></td>
<td valign=\"bottom\" align=\"center\"><span class=\"style3\"><a href=\"mop_seating_liste_hel.php?sorte=ny_bordnr\">N<br>y<br>t<br><br>b<br>o<br>r<br>d<br>n<br>r</a></span></td>
<td valign=\"bottom\" align=\"center\"><span class=\"style3\"><a href=\"mop_seating_liste_hel.php?sorte=longitude\">L<br>o<br>n<br>g<br>i<br>t<br>u<br>d<br>e</a></span></td>
<td valign=\"bottom\" align=\"center\"><span class=\"style3\"><a href=\"mop_seating_liste_hel.php?sorte=latitude\">L<br>a<br>t<br>i<br>t<br>u<br>d<br>e</a></span></td>
</tr>";
$a = 0;
$max = 0;
while ($row = mysql_fetch_array($query)) {
$a++;
$max++;
if($a%2 == 0) {
$bgcolor = "#000000";}else{
$bgcolor = "#000000";}
$i++;
$id = $row['id'];
$afdeling = $row['afdeling'];
$navn = $row['navn'];
$initial = $row['initial'];
$kommentar = $row['kommentar'];
$ak_bygning = $row['ak_bygning'];
$ak_etage = $row['ak_etage'];
$ak_rumnr = $row['ak_rumnr'];
$ny_bygning = $row['ny_bygning'];
$ny_etage = $row['ny_etage'];
$ny_rumnr = $row['ny_rumnr'];
$ny_bordnr = $row['ny_bordnr'];
$longitude = $row['longitude'];
$latitude = $row['latitude'];
$over = '#444444';
echo "<tr bgcolor=\"$bgcolor\" onMouseOver=\"this.bgColor='$over';\" onMouseOut=\"this.bgColor='$bgcolor';\">
<td><input type=\"text\" size=\"42\" class=\"textfelt\" name=\"navn".$i."\" value=\"$navn\"> </td>
<td><input type=\"text\" size=\"7\" class=\"textfelt\" name=\"afdeling".$i."\" value=\"$afdeling\"> </td>
<td><input type=\"text\" size=\"7\" class=\"textfelt\" name=\"initial".$i."\" value=\"$initial\"> </td>
<td><input type=\"text\" size=\"47\" class=\"textfelt\" name=\"kommentar".$i."\" value=\"$kommentar\"> </td>
<td><input type=\"text\" size=\"7\" class=\"textfelt\" name=\"ak_bygning".$i."\" value=\"$ak_bygning\"> </td>
<td><input type=\"text\" size=\"7\" class=\"textfelt\" name=\"ak_etage".$i."\" value=\"$ak_etage\"> </td>
<td><input type=\"text\" size=\"7\" class=\"textfelt\" name=\"ak_rumnr".$i."\" value=\"$ak_rumnr\"> </td>
<td><input type=\"text\" size=\"7\" class=\"textfelt\" name=\"ny_bygning".$i."\" value=\"$ny_bygning\"> </td>
<td><input type=\"text\" size=\"7\" class=\"textfelt\" name=\"ny_etage".$i."\" value=\"$ny_etage\"> </td>
<td><input type=\"text\" size=\"7\" class=\"textfelt\" name=\"ny_rumnr".$i."\" value=\"$ny_rumnr\"> </td>
<td><input type=\"text\" size=\"7\" class=\"textfelt\" name=\"ny_bordnr".$i."\" value=\"$ny_bordnr\"> </td>
<td><input type=\"text\" size=\"7\" class=\"textfelt\" name=\"longitude".$i."\" value=\"$longitude\"> </td>
<td><input type=\"text\" size=\"7\" class=\"textfelt\" name=\"latitude".$i."\" value=\"$latitude\"> <input type=\"hidden\" name=\"id\" value=\"$id\"><input type=\"hidden\" name=\"max\" value=\"$max\"><input type=\"hidden\" name=\"i\" value=\"$i\"></td></td>
<td><a href=\"slet_mop_seating.php?id=$id\"><img src=\"slet.gif\" border=\"0\"></a></td>
</tr>";
echo"<tr>
<td><hr siz=\"1\" color=\"#333333\"></td>
<td><hr siz=\"1\" color=\"#333333\"></td>
<td><hr siz=\"1\" color=\"#333333\"></td>
<td><hr siz=\"1\" color=\"#333333\"></td>
<td><hr siz=\"1\" color=\"#333333\"></td>
<td><hr siz=\"1\" color=\"#333333\"></td>
<td><hr siz=\"1\" color=\"#333333\"></td>
<td><hr siz=\"1\" color=\"#333333\"></td>
<td><hr siz=\"1\" color=\"#333333\"></td>
<td><hr siz=\"1\" color=\"#333333\"></td>
<td><hr siz=\"1\" color=\"#333333\"></td>
<td><hr siz=\"1\" color=\"#333333\"></td>
<td><hr siz=\"1\" color=\"#333333\"></td>
<td><hr siz=\"1\" color=\"#333333\"></td>
</tr>";}
echo "<input type=\"submit\" name=\"submit\" class=\"button\" value=\"Gem\" /></form>";}}
echo "</table>";
?>
//DEBUG: query was emty.
en ekspert der lige kan se dig ud af det?
