I dont see anything
| From: | Brandon Feldhahn | Date: | Wed, 06 Dec 2000 03:31:15 +0000 |
| Subject: | I dont see anything | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-40203@lists.php.net to get a copy of this message | ||
i created a form called guestbook.html:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<HTML>
<HEAD>
<TITLE></TITLE>
<META NAME="Generator" CONTENT="TextPad 4.0">
<META NAME="Author" CONTENT="?">
<META NAME="Keywords" CONTENT="?">
<META NAME="Description" CONTENT="?">
</HEAD>
<BODY BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#FF0000"
VLINK="#800000"
ALINK="#FF00FF" BACKGROUND="?">
<FORM method="POST" action="guestbook2.php">
<INPUT type="text" name="NAME" size="10"
maxlength="35"><br />
<INPUT type="text" name="E_MAIL" size="25"
maxlength="50"><br />
<TEXTAREA name="SUGGESTIONS
" cols=30 rows=5></TEXTAREA><br />
<INPUT type="submit" value="Submit!">
</form>
</BODY>
</HTML>
then created the thing you view it in called guestbook2.php:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<HTML>
<HEAD>
<TITLE></TITLE>
<META NAME="Generator" CONTENT="TextPad 4.0">
<META NAME="Author" CONTENT="?">
<META NAME="Keywords" CONTENT="?">
<META NAME="Description" CONTENT="?">
</HEAD>
<BODY BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#FF0000"
VLINK="#800000"
ALINK="#FF00FF" BACKGROUND="?">
<?php
// create connection
$connection = mysql_connect("localhost","brandon","surfer")
or die("Couldn't make connection.");
// select database
$db = mysql_select_db("guestbook_db", $connection)
or die("Couldn't select database.");
// create SQL statement
$sql = "SELECT NAME, E_MAIL, SUGGESTIONS
FROM GUESTBOOK";
// execute SQL query and get result
$sql_result = mysql_query($sql,$connection)
or die("Couldn't execute query.");
// start results formatting
echo "<TABLE BORDER=1>";
echo "<TR>
<TH>Name</TH>
<TH>Suggestions</TH>
</TR>
";
// format results by row
while ($row = mysql_fetch_array($sql_result)) {
$E_MAIL = $row["E_MAIL"];
$NAME = $row["NAME"];
$SUGGESTIONS = $row["SUGGESTIONS"];
echo "<TR>
<TD><a href='mailto:E_MAIL'>$NAME</a></TD>
<TD>$SUGGESTIONS</TD>
</TR>
";
}
echo "</TABLE>";
// free resources and close connection
mysql_free_result($sql_result);
mysql_close($connection);
?>
</BODY>
</HTML>
all i see is "NAME" and "SUGGESTIONS" and no data
WHAT AM I DOING WRONG?