|
|
Posted by Mark Sargent on 10/05/40 11:14
Hi All,
this page,
http://webmonkey.wired.com/webmonkey/99/21/index3a_page3.html?tw=programming
has code that is supposed to pass an id via the url string to the same
page, and display info of a particular product, based on the id being
passed. Everything works fine, until I click the link, and instead of
the proudct's details being displayed, based on that id, I get the
original page, with the lnks. I've right clicked the links, and viewed
properties, where I see that the id=n is set. Why doesn't it pull the
record based on the id being passed..? Cheers.
Mark Sargent.
P.S. I've inserted, echo $id && to display the id value. Nothing appears.
<html>
<body>
<?php
$db = mysql_connect("localhost", "root", "grunger");
mysql_select_db("status",$db);
// display individual record
if ($id) {
echo $id &&
$result = mysql_query("SELECT * FROM Products WHERE product_id=$id",$db);
$myrow = mysql_fetch_array($result);
printf("Product Name: %s\n<br>", $myrow["product_name"]);
printf("Product Model Number: %s\n<br>", $myrow["product_model_number"]);
printf("Product Serial Number: %s\n<br>",
$myrow["product_serial_number"]);
printf("Product Price: %s\n<br>", $myrow["product_price"]);
} else {
// show employee list
$result = mysql_query("SELECT * FROM Products",$db);
if ($myrow = mysql_fetch_array($result)) {
// display list if there are records to display
do {
printf("<a href=\"%s?id=%s\">%s</a><br>\n", $PHP_SELF,
$myrow["product_id"], $myrow["product_name"]);
} while ($myrow = mysql_fetch_array($result));
} else {
// no records to display
echo "Sorry, no records were found!";
}
}
?>
</body>
</html>
Navigation:
[Reply to this message]
|