Re: Generating Static Pages
| From: | David Jackson | Date: | Tue, 01 Jan 2002 18:44:37 +0000 |
| Subject: | Re: Generating Static Pages | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-79175@lists.php.net to get a copy of this message | ||
Sorry here's the code unattached:
<?php
include("/home/sites/www.pickledbeans.com/web/html_header.php");
// include("/home/sites/www.pickledbeans.com/web/connect.php");
include("/connect.php");
echo "<body >\n";
echo "<form method = \"post\" action =\"invoice.php\">\n";
echo "<p>Sales Date:</p>\n";
echo "<p><input type=\"Text\" name=\"frm_date\"
size=\"15\"></p>\n";
echo "<p>Sales Rep:</p>\n";
echo "<p><input type=\"text\" name=\"frm_sid\"
size=\"4\"></p>";
// Define table
echo "<br><table bgcolor=\"gray\" border=\"1\" >";
// Generate book listing
$result = mysql_query("SELECT pid,date,title,subtitle,author,amount FROM
catalog ") or die("Dis ain't right !!");
while (
list($pid,$date,$title,$subtitle,$author,$amount)=mysql_fetch_row($result)){
echo "<tr>\n";
echo "<td><input type=\"checkbox\" name=\"frm_pid[]\" value =
\"$pid\"
></td>";
echo "<td>$title</td>";
echo "<td>Price: $amount</td>";
echo "</tr>\n";
}
echo "</table>";
echo "<p><input type=\"Submit\" name=\"submit\"
value=\"Submit\">";
echo "<input type=\"Reset\" name=\"reset\"
value=\"Reset\"></p>";
echo "</form>";
echo "</body>";
echo "</html>";
mysql_free_result ($result);
mysql_close($link);
exit;
?