
wäre echt nett wenn mir jemand kurz helfen könnte
gruß
sugar
INPUT
// selected category
$selected = "CMS_VALUE[0]";
echo "<table cellspacing=\"0\" cellpadding=\"10\" border=\"0\">
<tr valign=\"top\">
<td>Kategorie wählen:</td>
<td>
<select name=\"CMS_VAR[0]\">";
if($selected!="0" && $selected!=""){
echo"<option value=\"0\">--- kein ---</option>";
}else{
echo"<option selected=\"selected\" value=\"0\">--- kein ---</option>";
}
// fetch all categorys
$query = "SELECT A.idcat, A.level, C.name FROM ".$cfg["tab"]["cat_tree"]." AS A, ".
$cfg["tab"]["cat"]." AS B, ".$cfg["tab"]["cat_lang"]." AS C WHERE A.idcat=B.idcat ".
"AND B.idcat=C.idcat AND C.idlang='$lang' AND B.idclient='$client' ".
"AND C.visible=1 ORDER BY A.idtree";
// execute query
$db->query($query);
// loop result and build the options
while ($db->next_record()) {
// indent spacer
$spaces = "|";
// how many levels
$levels = $db->f("level");
for ($i = 0; $i < $levels; $i ++) {
// add 2 spaces for every level
$spaces = $spaces . "--";
} // end for
$spaces .= ">";
if ($selected == $db->f("idcat")) {
// selected category
echo "<option selected=\"selected\" value=\"". $db->f("idcat") ."\">". $spaces . $db->f("name") ."</option>";
} else {
// category
echo "<option value=\"". $db->f("idcat") ."\">". $spaces . $db->f("name") ."</option>";
} // end if
} // end while
echo " </select>";
echo " </td>
</tr>
<tr>
<td>Überschrift</td>
<td><input type=\"text\" name=\"CMS_VAR[2]\" value=\"CMS_VALUE[2]\"></td>
</tr>
<tr>
<td>Angezeigte Länge in Zeichen</td>
<td><input type=\"text\" name=\"CMS_VAR[3]\" value=\"CMS_VALUE[3]\"></td>
</tr>
</table>";
OUTPUT
<?php
$sql = "SELECT cat_art.idcatart, cat_lang.idcat, cat_lang.name, art_lang.idart, art_lang.title,
DATE_FORMAT(art_lang.lastmodified, '%d.%m.%Y') AS last_modified
FROM ".$cfg["tab"]["art_lang"]." art_lang, ".$cfg["tab"]["cat_art"]." cat_art, con_cat_lang cat_lang, con_cat cat
WHERE cat_lang.idcat = cat_art.idcat AND cat_art.idart = art_lang.idart AND
cat.idcat = cat_lang.idcat AND cat.idclient = '$client' AND
art_lang.online = '1' AND cat_lang.visible = '1' ORDER BY art_lang.lastmodified DESC LIMIT 0,5";
$db->query($sql); // execute query
echo '<table border="0" width="100%" height="100%" cellspacing="0" cellpadding="3">',chr(10);
echo ' <tr>',chr(10);
echo ' <td colspan="2" class="text"><b>News:</b></td>',chr(10);
echo ' </tr>',chr(10);
while ($db->next_record())
{
$link = $sess->url("front_content.php?idcatart=" . $db->f("idcatart") . "&lang=$lang&client=$client");
echo ' <tr><td width="1%" valign="top"><img src="images/newsArrow2.gif" width="5" height="25" border="0"></td><td width="99%"><a href="'.$link.'">'.$db->f("name").': '.$db->f("title").' ('.$db->f("last_modified").')</a></td></tr>',chr(10);
} // end while
echo '</table>',chr(10);
?>