Re: Product details not being displayed, based on passed id

Petar Nedyalkov wrote:

On Wednesday 27 April 2005 08:54, Mark Sargent wrote:

Hi All, this page, http://webmonkey.wired.com/webmonkey/99/21/index3a_page3.html?tw=programmin g 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.

Are you sure your webserver handles it's rewrite rules correctly? Maybe you use apache - check the mod_rewrite settings, rules, etc. Have in mind that the rewrite engine is being enabled using the "RewriteEngine on" directive.

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>

Hi All,

yes, using Apache2 as my test web server. I'm even more a novice with it. I'm not too sure I understand what you are asking me to check. I looked in apache2/conf/httpd.conf for somethig related to RewriteEngine, but found nothing. Could you explain a little more..? Cheers. Mark Sargent.