Product page display problem

[Chuck S]

Okay these lines in showproduct make the changes in bold changing $date to $pdate

Content visible to verified customers only.

and this line

Content visible to verified customers only.

[bpi007]

I change it but now they are no prev or next product.

[bpi007]

Check line 248

Content visible to verified customers only.

This case cause the bad select because in database, field date have data.

[bpi007]

If you click here, I've display the select that is executed on top on the product : http://www.plouf.be/scuba-planet/sho...oduct=5&cat=14

[Chuck S]

Okay how about removing this code.

Content visible to verified customers only.

You can revert any other prior changes and on the list line make $cat $dbcat

[bpi007]

If I remove your code :
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/pascalbi/public_html/scuba-planet/showproduct.php on line 269

[bpi007]

When removing code the select is following :
SELECT id,bigimage,cat,userid,approved FROM rp_products WHERE cat= AND approved=1

[Chuck S]

What happens if you change the $dbcat variable to $cat on around line 264? This is why I suggested you send us ftp info we dont spend so long with this.

Content visible to verified customers only.

[bpi007]

I've change $dbcat by $cat but order not correct

$query = "SELECT id,bigimage,cat,userid,approved FROM {$Globals['rp_db_prefix']}products WHERE cat=$cat AND approved=1 $sortcode";

[bpi007]

$sortcode is empty

[bpi007]

Chuck I've send ftp code to support@photopost.com

[Chuck S]

feel free to send ftp info to support@photopost.com as well as url and admin login.

[bpi007]

Send it.

[Chuck S]

cool got it have a merry christmas