diff options
author | cookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8> | 2006-11-10 19:37:59 +0000 |
---|---|---|
committer | cookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8> | 2006-11-10 19:37:59 +0000 |
commit | e87e62d953ec5d4a79390ce28ef88fe43a816473 (patch) | |
tree | 5ee6538614a28e5aa075f620e53a36568e87d116 /www-ssl/nonpublic/schichtplan.php | |
parent | f57b0c9137ab8d5278715f2cedf34eabb14ee3d5 (diff) |
probleme mit leeren tabellen beseitigt
git-svn-id: svn://svn.cccv.de/engel-system@157 29ba0400-6e00-0410-a75a-ca02368028f8
Diffstat (limited to 'www-ssl/nonpublic/schichtplan.php')
-rwxr-xr-x | www-ssl/nonpublic/schichtplan.php | 13 |
1 files changed, 8 insertions, 5 deletions
diff --git a/www-ssl/nonpublic/schichtplan.php b/www-ssl/nonpublic/schichtplan.php index b9a24cfd..a9e2d50e 100755 --- a/www-ssl/nonpublic/schichtplan.php +++ b/www-ssl/nonpublic/schichtplan.php @@ -51,7 +51,10 @@ if( !isset($ausdatum) ) $sql = "SELECT `DateS` FROM `Shifts` ORDER BY `DateS` ASC LIMIT 0, 1"; $Erg = mysql_query($sql, $con); } - $ausdatum = substr(mysql_result($Erg,0,"DateS"),0,10); + if( mysql_num_rows( $Erg ) > 0 ) + $ausdatum = substr(mysql_result($Erg,0,"DateS"),0,10); + else + $ausdatum = gmdate("Y-m-d", time()+3600); } @@ -61,10 +64,10 @@ if ( !isset($raum) ) { // Ausgabe wenn kein Raum Ausgewählt: echo Get_Text("pub_schicht_auswahl_raeume"). "<br><br>\n"; - - foreach( $Room as $RoomEntry ) - echo "\t<li><a href='./schichtplan.php?ausdatum=$ausdatum&raum=". $RoomEntry["RID"]. "'>". - $RoomEntry["Name"]. "</a></li>\n"; + if( isset($Room)) + foreach( $Room as $RoomEntry ) + echo "\t<li><a href='./schichtplan.php?ausdatum=$ausdatum&raum=". $RoomEntry["RID"]. "'>". + $RoomEntry["Name"]. "</a></li>\n"; echo "<br><br>"; echo Get_Text("pub_schicht_alles_1"). "<a href='./schichtplan.php?ausdatum=$ausdatum&raum=-1'> <u>". |