How to click result - then lead to item page

charles256

I need help with the code for an items detail page.
When a user clicks on an item from the main page,
this link will say more details...
then when clicked it will take them
to my second page, an item detail page.

I am using the product id as the passing variable.

So on the item detail page, how would I set that up
for the select statement? Currently I don't know if I
am to use a limit or not. This is what I have so far
and its not working...

$table_name = "table";
$host = "localhost";
$user = "user";
$pass = "pass";
$db = "database";

//open database connection
$connection = mysql_connect("$host", "$user", "$pass")
  or die(mysql_error());
//select database
$db = @mysql_select_db($db, $connection) or
die(mysql_error());


$sql = "select * from $table WHERE ProductID='ProductID'";
$result = mysql_query($sql,$connection) or die("Error: " . mysql_error());
$numrows = mysql_num_rows($result);

// We have no results

if ($num_rows == 0) {
echo "Sorry, we have no records";
} else {

// We have  results so create a table to display them
//blah..blah..

//products table
/* Begin table to format data */
print "<center><table width=\"500\" border=\"1\" bordercolor=\"#EEEED1\" cellspacing=\"0\" cellpadding=\"0\">\n";
print "<tr><td align=\"center\" colspan=\"4\" bgcolor=\"#CDB5CD\">";
print "<strong>Products</strong>";
print "</td></tr>";


while($row=mysql_fetch_array($result)){


print "\t<tr>";
print "\t\t<td>" .$row['Name']. "<br><a target=\"_blank\" href=\"" . $row['Link']. "\">" . $row['Name'] . "</a></td>";
print "\t\t<td>" . $row['ProductID'] . "</td>";
print "\t\t<td><font color=\"#FF0000\">$" . $row['Price'] . "</font></td>";
print "\t\t<td align=\"center\"><img src=\"" .$row['Thumbnail']. "\" width=\"50\" height=\"50\"></td>";
print "\t</tr>";
}
print "</table></center>\n";

?>

The main page is working fine.
thanks in advance,
charles256

LordShryku

If the product id is coming through the URL, try this SQL statement.

$table = "table";
$sql = SELECT * FROM $table WHERE ProductID='".$_GET['pid']."'";

That's assuming you are passing it like
http://somewhere/detail.php?pid=foo

Also, in your example you use
$table_name = "table";
But then use $table in the SQL query

charles256

Originally posted by LordShryku
If the product id is coming through the URL, try this SQL statement.
$table = "table";
$sql = SELECT * FROM $table WHERE ProductID='".$_GET['pid']."'"; 
This gives me an error on the last line, (99) and I have 98 lines.

That's assuming you are passing it like
http://somewhere/detail.php?pid=foo
Yes this is correct

Also, in your example you use
$table_name = "table";
But then use $table in the SQL query [/B]

Oh that was just fixing it here for posting, it is correct in
my original.

Is the $_GET suppose to be somewhere else before its used
in the select?
charles

LordShryku

It doesn't have to be. $_GET is just the array o arguments passed in the URL

charles256

ok, still getting the error on line (99) and I only have 98 lines.
FYI I am not working with any forms either.
charles

LordShryku

"the error" being an "unexpected end on line 99" error?

charles256

Nope, its a parse error.

charles256

Now the page comes up, the item detail page, that is. But it is blank. So when on the main page you click your item of choice, the item detail page comes up no item.

rocket

Try useing this

$sql = "select * from $table WHERE ProductID LIKE='ProductID'";

charles256

Originally posted by rocket
Try useing this

$sql = "select * from $table WHERE ProductID LIKE='ProductID'";

$sql = "select * from $table WHERE ProductID LIKE '%ProductID%'";

This seems to work, although still any item I click on returns an empty table on the item detail page. The page loads, the header, navigators etc...even the table and such, just no product or info.

charles256

Ok I have it where it will pass to the item detail page.
I changed the link to pass the int (ID) of the product
rather then the productid.

But when I click on int(ID) #979, the item detail page
comes up with a product that only matches to the
int(ID) of that in the database to #1.

I have ran thru the code over and over, and cannot
see why this is doing this.

Here again is the detail page code:

$query = "SELECT ProductID FROM $table_name WHERE ProductID = ProductID";
$result = mysql_query($query) or die("Error: " . mysql_error());
$row = mysql_fetch_array($result);


//products table
/* Begin table to format data */
print "<center><table width=\"500\" border=\"1\" 
bordercolor=\"#EEEED1\" cellspacing=\"0\" cellpadding=\"0\">\n";
print "<tr><td align=\"center\" colspan=\"4\" bgcolor=\"#CDB5CD\">";
print "<b>Your Item</b>";
print "</td></tr>";



print "\t<tr>";
print "\t\t<td><a target=\"_blank\" href=\"" . $row['Link']. "\">" . $row['Name'] . "</a></td>";
print "\t\t<td>" . $row['ProductID'] . "</td>";
print "\t\t<td><font color=\"#FF0000\">$" . $row['Price'] . "</font></td>";
print "\t\t<td align=\"center\"><img src=\"" .$row['Thumbnail']. "\" width=\"50\" height=\"50\"></td>";
print "\t</tr>";

print "</table></center>\n";

Thanks again
Charles

charles256

Any help appreciated.
thanks