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
pgpFCCJrtXoI6.pgp
Description: PGP signature
