ich find den fehler nich... hab schon alles versucht...
Code:
<?php
include'mysql.php';
if(isset($_get["title"])) {
$title=$_get["title"];
$inhalt=$_get["inhalt"];
$autor=$_get["autor"];
}
echo $title.$inhalt.$autor;
if(isset($title) and isset($inhalt) and isset($autor)){
$ip = "tex";
$msql="INSERT INTO gaestebuch
(Titel,Inhalt,Datum,Ip,Autor)
VALUES
('$title',
'$inhalt',
NOW(),
'$ip'
'$autor');";
} else {
echo '<form action="gaestebuch.php" method="get">';
echo 'titel:<input type="text" name="title">
';
echo 'inhalt:<input type="text" name="inhalt">
';
echo 'autor:<input type="text" name="autor">
';
echo '<input type="Submit" value="Absenden">
';
echo '</form>';
$sql = "SELECT
Titel,
Inhalt,
Datum,
Autor,
Ip
FROM
gaestebuch
ORDER BY
Datum DESC;";
$result = mysql_query($sql) OR die(mysql_error());
while($row = mysql_fetch_assoc($result)) {
if(isset($_SESSION['admin'])){
echo "<table>";
echo "<tr>";
echo " <td>";
echo "Titel: ".$row[Titel];
echo " </td>";
echo " <td>";
echo "Datum: ".$row[Datum];
echo " </td>";
echo " <td>";
echo "Autor: ".$row[Autor];
echo " </td>";
echo " <td>";
echo $row[Ip];
echo " </td>";
echo " <td>";
echo "</tr>";
echo "<tr>";
echo "<td colspan=\"4\">";
echo $row[Inhalt];
echo " </td>";
echo "</tr>";
echo "</table>";
} else {
echo "<table>";
echo "<tr>";
echo " <td>";
echo "Titel: ".$row[Titel];
echo " </td>";
echo " <td>";
echo "Datum: ".$row[Datum];
echo " </td>";
echo " <td>";
echo "Autor: ".$row[Autor];
echo " </td>";
echo "</tr>";
echo "<tr>";
echo "<td colspan=\"3\">";
echo $row[Inhalt];
echo " </td>";
echo "</tr>";
echo "</table>";
}
}
}
?>