Product Details page

I set up a Search, Results, and Product Details page.
Everything works GREAT on the local server. But the details page does not work on the Live server.

I published files to live. Result:
My search page works
My results page works
On the results page the Product Image links to the Details page. But when the Details page loads it says "No record found."

All pages work fine on the local server. Can't figure out why just the Details page is not working on Live. Please help.

Thanks,
Danielle

your links to the details page are using the product name in the query string:
plants_Search_Detail.php?ProductName=CANNA 'Journey's End'

it should be using the product ID instead.

I modified by replacing with Product ID link. Does not work on live or local server.
Can you take a look at the results page again?
The strange thing is that the original code had it link to ProductName and it worked on the local server but not live.

NOTE:
The image now links to the page via ProductID. But this link does not function correctly.
(Note the Text link below the image still links to the Product Name, same as the original I sent you.)

the detail page will need to be modified to except the ProductID querystring variable.

Currently your detail page is configured to filter the recordset on the product name column using the productName querystring variable.

you need to edit the recordset to use the ProductID column and ProductID querystring variable for filtering.

the issue with the product name column is that it contains single quotes which are throwing the server off.

your local server probably has a setting that is accounting for it, but that setting does not exist in the live server. It is better practice though to use the ID column than the name column, since it is posible that 2 records could have the same name value, but the ID value will always be unique.

Hi,

This Details page was created with DataAssist. I opened the page up and viewed the Recordset. I made some changes (adding ProductID to the Select area and replacing ProductName with ProductID) but it did not work.
I'm still doing something wrong.
If I'm looking just at the Code on the page what am I looking for exactly?
(I should replace "what" with "what")

Thanks for simplifying it for me. I appreciate it,
Danielle

send a copy of your page please

Hi,
Details page attached.
thanks,
Danielle

doubkle click the WADAProducts recordset. and change the where clause:

WHERE ProductName = ParamProductName OR ( -1= ParamSessionProductName AND ProductName= ParamProductName2)

to:
WHERE ProductID = ParamProductName OR ( -1= ParamSessionProductName AND ProductID= ParamProductName2)


edit the ParamProductName and ParamProductName2 parameters and change the run time value:
$_GET['ProductName']


to:
$_GET['ProductID']