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> -- Cyberly yours, Petar Nedyalkov Devoted Orbitel Fan :-) PGP ID: 7AE45436 PGP Public Key: http://bu.orbitel.bg/pgp/bu.asc PGP Fingerprint: 7923 8D52 B145 02E8 6F63 8BDA 2D3F 7C0B 7AE4 5436
Attachment:
pgpdXFaAFXGhW.pgp
Description: PGP signature
