retrieve product ID from query using URL

crazylegseddie

Hi small problem. All i need is for the $productURL as shown below to recognise the product ID as set in my query.


$result = mysql_query('SELECT  pd_name, MAX(pd_id), pd_thumbnail
										FROM tbl_product GROUP BY pd_id desc limit 1') or exit(mysql_error()); 
						$row = mysql_fetch_assoc($result);
						$productUrl = 'categories.php?c=17&p='. $_GET['pd_id'];?>
						<a href="<?php echo $productUrl; ?>"><img src="<?php echo $row['pd_thumbnail']; ?>" border="0"></a>

the $_GET command has worked for me for similar problems but obviously not for this one. Any ideas as to what im doing wrong and how to fix it would be good.

THX

notaloser

what is an example URL for this page exactly?

crazylegseddie

If I type in the correct product ID as shown below the product will be displayed.

categories.php?c=17&p=1

I need the product link ie. p=1 to read from my query so it automatically displays the correct ID from the query, Which is why I tried the $_GET method but have realised this is not relevent.

Weedpacket

Here's a hint: what does $row contain? print_r() and see.

crazylegseddie

the row contains the following:

 Array ( [pd_name] => Volume WD 211>Issue 06/06 [MAX(pd_id)] => 1 [pd_thumbnail] => e70740df0e61eb625e68e4c67962f5a6.jpg )

so the pd_id is definately reading the correct product. Just how do I retrieve this information in a URL as previously posted?

notaloser

what i meant was, this php is being displayed on what page..

i.e. page.php?pd_id=2

$_GET will work if the variable pd_id is in the URL like so

crazylegseddie

problem fixed 🙂 with

$productUrl = 'categories.php?c=17&p='. $row['MAX(pd_id)'];?>

I have another issue now before my script on this page is complete. I currently have images i.e pd_thumbnail in the database located in a 'images/product' directory. These images will only show if I copy them to where the script executes. How do I set up my script to read the images from the specified directory. Currently my script to read the images is

$productUrl; ?>"><img src="<?php echo $row['pd_thumbnail']; ?>"

Do I need to make a variable of pd_thumbnail to specify a directory?

ANy help on this will be very good 🙂

THX