Linking to retrieve info using product_id

crazylegseddie

Hi everyone I have a section on my website where i have a 'More' link which needs to retrieve info from the database and display it on a seperate page. Currently if I use: <?php echo $pd_more; ?> this will display the information within the same page. So far ive created a link for this section: <?php echo '<a href="include/pd_more.php">More...</a>';?> (would i need to include the pd_id within this link?) .What i need to know is what coding is needed on the pd_more.php page? Ive also posted on another forum and still unable to solve the problem, but had feedback which said it may be sketched like this, but i tried implementing this with no luck :bemused:

QUERY DATABASE USING PRIMARY KEY $GET['id'];
FETCH SINGLE ROW FOR PRODUCT WHOSE ID IS $GET['id'];
ECHO INTO PAGE HEADING FOR PRODUCT NAME;
ECHO INTO PAGE TEXT FROM PRODUCT DETAIL;

Any assistance will be appreciated. Thank you.

devinemke

i assume that on your main page you are listing products and want to provide a link to display more product info. here is a simple example (just guessing here at your exact data structure).

main.php

$result = mysql_query('SELECT product_name, product_id FROM products') or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
	echo $row['product_name'] . ' (<a href="more.php?product_id=' . $row['product_id'] . '">more</a>)<br>';
}

more.php

$result = mysql_query('SELECT * FROM products WHERE product_id = ' . $_GET['product_id']) or exit(mysql_error());
$row = mysql_fetch_assoc($result);
print_r($row);

crazylegseddie

Hi thx for your help but im still having problems. as you can see from this link:

http://benswhitedisc.no-ip.info/test/whitedisc/categories.php?c=12&p=1

it has retrieved every id from every product in the database when I only need the product id from the product shown in the picture. If you click on the 'More' link I receive all information in the array e.g. 'Array ( [pd_id] => 1 [cat_id] => 14 [pd_name] => Pioneer CDJ-1000 MK2 [pd_description] => The Pioneer etc etc.

I hope the link will clarify what Im trying to achieve. Look forward to your reply. Thank You

crazylegseddie

Hi im getting very close to solving this now. Just a few touches needed. Ok I didnt need the first query in the main page but just a link which read the id variable. I have created the link as below:

<?php echo '<a href="include/pd_more.php?pd_id='. $pdId;'">More..</a><br>' ?>

But i know the syntax is not quite right here as the page shows that the variable is correctly calling the id but it is accompanied by other html which makes me think that it has not correctly closed.

On the pd_more.php page i edited the query to just call the more column but it is still prints out the array info as shown below:

Array ( [pd_more] => will this work please work )

The script for this is below:

<?php
require_once '../library/config.php';
$result = mysql_query('SELECT pd_more FROM tbl_product WHERE pd_id = ' . $_GET['pd_id']) or exit(mysql_error());
$row = mysql_fetch_assoc($result);
print_r($row);
?>
Is there any reason why the array info is printing?

Any assistance on these two issues will be greatly appreciated.

thorpe

Is there any reason why the array info is printing?

print_r($row);

devinemke

change this:

<?php echo '<a href="include/pd_more.php?pd_id='. $pdId;'">More..</a><br>' ?>

to this:

<?php echo '<a href="include/pd_more.php?pd_id=' . $pdId . '">More..</a><br>'; ?>

crazylegseddie

yeh thank you very much that has fixed the first issue! any idea on the second issue involving the array print out?

crazylegseddie

just seen your reply thorpe. What else can i use to print out pd_more without using
print_r($row); function?