Hyperlinking results

wrinkle35

I am very new to this and I so far I have made some real progress. I have my pages showing results from my categories in a nice list, with images and everyting. But what I can't figure out is how to get one of the items in the list to show up in a new page when you click on view.

If you go here http://www.canadalogo.com/clnew/products.html# and click on athleticwear.
All the athleticwear shows up....how can I get a new page to show up with only the chosen products details when a customer clicks VIEW?

I am stumped.

rehfeld


<a href="foo.php?show=single&productid=blah">view</a>

then in foo.php


if ($_GET['show'] == 'single') {
    $productid = $_GET['productid'];
    // now show just that single product
}

wrinkle35

I cannnot get it work..... I have my foo.php (template.php) set up to have the data output into columns in a table.

<?
include("dbinfo.inc.php");
mysql_connect("localhost",$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM athletic_wear";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

echo "<b><center>Contacts Database Output</center></b><br><br>";

$i=0;
while ($i < $num) {
$product_name=mysql_result($result,$i,"product_name");
$style_number=mysql_result($result,$i,"style_number");
$fabric=mysql_result($result,$i,"fabric");
$size=mysql_result($result,$i,"size");
$description=mysql_result($result,$i,"description");
$price=mysql_result($result,$i,"price");
$colours=mysql_result($result,$i,"colours");

?>
<table>
<td><? echo $product_name; ?>Product Name</td>

ect....
how does your code work with that?

rehfeld

$query="SELECT * FROM athletic_wear where product_name = '$product_id'";

Roger_Ramjet

You can do it like this

<?
include("dbinfo.inc.php");
mysql_connect("localhost",$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM athletic_wear";
$result=mysql_query($query); 

echo '<table>';
// use the simple form of itterating through a resultset
while ($row=mysql_fetch_array($result)) {   

   echo '<tr><td>' . $row['product_name'] . '</td>
         <td>' . $row['style_number'] . '</td>
         <td><a href="template.php?prodid=' . $row['prodid'] . '">View</a></td></tr>';
}  // wend

echo '</table>';

?>

As you can see, there is no need to keep using mysql_result, mysql_fetch_array returns each row as an array that you can access by field name. Also, it allows you to just itterate through the resultset with a while that terminates when there are no more rows left: no need to keep count as it evaluates to false after the last row anyway.