- Copy the code below.
- Open comment.php in the code view. Paste the code below the form (not inside the form tag.
- Change 'david' in fourth line to your username.
- Upload the page, any comments which have been posted will now appear below the form.
<?php
$conn = mysql_connect("localhost", "wetsoxor_student", "coyote");
mysql_select_db("wetsoxor_davinci", $conn) or die(mysql_error());
$sql = "SELECT * FROM blog where user='david' order by count DESC";
$result=mysql_query($sql, $conn) or die(mysql_error());
while ($newArray = mysql_fetch_array($result)) {
$when = $newArray['when'];
$name = $newArray['name'];
$comment = $newArray['comment'];
print "<hr> On $when $name said<p>$comment</p>";
}
?>
Home
Classes
Instructor
