$db = mysql_connect("zabib", "cibook", "LL14H0903");
if (!$db) die("No Connection to the Database");
mysql_select_db("comments_cibook",$db);
$result1 = mysql_query("SELECT * FROM textbook WHERE comment='1'", $db);
if (!$result1) die("Error in database query");
?>
general comments
|
comment
|
name
|
date
|
checked
|
while ($daten = mysql_fetch_array($result1)) {
{ ?>
echo $daten[id]; ?>
|
echo $daten[text]; ?>
|
echo $daten[name]; ?>
|
echo $daten[date]; ?>
|
if ($daten[checked] == 0)
{ ?>
}
if ($daten[checked] == 1)
{ ?>
}
?>
|
}
}
?>
$result2 = mysql_query("SELECT * FROM textbook WHERE comment='2'", $db);
if (!$result2) die("Error in database query");
?>
shortcomings
|
comment
|
name
|
date
|
checked
|
while ($daten = mysql_fetch_array($result2)) {
{ ?>
echo $daten[id]; ?>
|
echo $daten[text]; ?>
|
echo $daten[name]; ?>
|
echo $daten[date]; ?>
|
if ($daten[checked] == 0)
{ ?>
}
if ($daten[checked] == 1)
{ ?>
}
?>
|
}
}
?>
$result3 = mysql_query("SELECT * FROM textbook WHERE comment='3'", $db);
if (!$result3) die("Error in database query");
?>
specific mistakes
|
comment
|
name
|
date
|
checked
|
while ($daten = mysql_fetch_array($result3)) {
{ ?>
echo $daten[id]; ?>
|
echo $daten[text]; ?>
|
echo $daten[name]; ?>
|
echo $daten[date]; ?>
|
if ($daten[checked] == 0)
{ ?>
}
if ($daten[checked] == 1)
{ ?>
}
?>
|
}
}
?>