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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux