View Single Post
  #10  
Old 07-29-2003, 01:30 PM
 
aguy2no aguy2no is offline
 

Advanced Member
  
Join Date: Jan 2003
Location: The Netherlands
Posts: 37
 

Default

OK...I got a little bit further....

Now I changed the query in products.php into:

Code:
$search_query = "($sql_tbl[products].categoryid='$cat' or $sql_tbl[products].categoryid1='$cat' or $sql_tbl[products].categoryid2='$cat' or $sql_tbl[products].categoryid3='$cat') and $sql_tbl[products].forsale='Y' &orderby=price &orderby=product ";

This seems to work.... Products will show up alphabetically. When I leave "&orderby=products"... I'll get no searchresults. The same happens when I skip "&orderby=price"....No results...

I am running bazurk!
Reply With Quote