|
DAM Warenwirtschaftssystem Handbuch
|
$SQLwhere4 = "where unterpunkt = ''";
if(!empty($_GET['p']))
$SQLwhere4 .= " and position = '".$_GET['p']."'";
$sql4 = "select punkt, position, name from handbuch $SQLwhere4 order by position";
$result4 = mysql_query($sql4);
while($row4 = mysql_fetch_object($result4))
{
if(!empty($_GET['p']))
echo ''.$row4->name.'';
//echo "punkt\" style=\"color:black;text-decoration: none\">$row4->name ";
else
echo "position\" style=\"color:black;text-decoration: none\">$row4->punkt ";
$SQLwhere = "where unterpunkt = '$row4->punkt'";
$sql = "select id, punkt, name, position, u_position from handbuch $SQLwhere order by position, u_position, punkt";
$result = mysql_query($sql);
while($row = mysql_fetch_object($result))
{
if(substr_count($row->punkt, "/") == 0)
$SQLwhere = "where unterpunkt = '$row->punkt'";
$sql2 = "select id, punkt, name, position, u_position, unterpunkt from handbuch $SQLwhere order by u_position";
$result2 = mysql_query($sql2);
while($row2 = mysql_fetch_object($result2)) {
if(substr_count($row2->unterpunkt, "/") == 0)
if(!empty($_GET['p']))
echo "";
else
echo "";
$SQLwhere = "where unterpunkt = '$row2->punkt'";
$sql3 = "select id, punkt, name, position, u_position from handbuch $SQLwhere order by u_position";
$result3 = mysql_query($sql3);
while($row3 = mysql_fetch_object($result3) and !empty($_GET['p'])){
echo "";
$SQLwhere = "where unterpunkt = '$row3->punkt'";
$sql5 = "select id, punkt, name, position, u_position from handbuch $SQLwhere order by u_position";
$result5 = mysql_query($sql5);
while($row5 = mysql_fetch_object($result5)) {
echo "";
$SQLwhere = "where unterpunkt = '$row5->punkt'";
$sql6 = "select id, punkt, name, position, u_position from handbuch $SQLwhere order by u_position";
$result6 = mysql_query($sql6);
while($row6 = mysql_fetch_object($result6)) {
echo "";
$SQLwhere = "where unterpunkt = '$row5->punkt'";
$sql7 = "select id, punkt, name, position, u_position from handbuch $SQLwhere order by u_position";
$result6 = mysql_query($sql7);
while($row7 = mysql_fetch_object($result6)) {
echo "";
}
}
}
}
}
}
echo " ";
}
if(!empty($_GET['p'])) echo "
Zurück";
?>
|
|
|
|
$result = mysql_query("select id, news_text as n, titel, datum from news order by datum desc limit 1");
while($row = mysql_fetch_object($result))
{
echo
'
'.strip_tags(datum_extrahieren($row->datum)).' '.strip_tags($row->titel).' |
';
$news_laenge = strlen($row->n);
$text_laenge = 300;
$news_länge = strlen($row->n);
if($news_laenge > $text_laenge) {
echo strip_tags(leerzeichen_finden($text_laenge, substr($row->n, 0, $text_laenge))).' ... weiter';
}
else
echo strip_tags($row->n);
}
?>
|
$result = mysql_query("select id, news_text as n, titel, datum from news order by datum desc limit 0, 1000");
$num_rows = mysql_num_rows($result);
while($row = mysql_fetch_object($result))
{
echo '
'.$row->titel.'
|
';
;
}
$num_rows = (int)($num_rows);
if(4 <= $num_rows){
echo '
|
';
}
else
for($i = 5 - $num_rows; $i < 5; $i++){
echo '
|
';
}
?>
|
|
|
|
|
|