product Listing vs splitPageResults

[chris416]

im having some trouble with product listings........ basiscally whats happening is..

everytime i change the page i get the same 60 listings.. the splitPageResults function doesnt seem to be working, i mean that every page has the same results.. and its not changing...

 

heres my $listing_sql :

 

$listing_sql = "select pd.products_name,

p.products_quantity,

p.products_image,

p.products_audio,

p2c.categories_id,

p.products_id,

p.products_price,

p.products_artist,

p.products_title,

p.products_label

from " . TABLE_PRODUCTS_DESCRIPTION . " pd,

" . TABLE_PRODUCTS_TO_CATEGORIES . " p2c,

" . TABLE_PRODUCTS . " p,

" . TABLE_CATEGORIES . " c

where p.products_status = '1'

and p.products_id = p2c.products_id

and pd.products_id = p2c.products_id

and p2c.categories_id = c.categories_id

and c.parent_id = '" . $current_category_id . "'

order by p.products_date_added desc";

 

is it caused by the sql statement?

also, I'm trying to add a dropdown on submit that changes the number of displayed results..

but i cant seem to find out where in the php files the MAX_DISPLAY_SEARCH_RESULTS gets defined..

 

can anyone help me here?

 

---chris

[chris416]

i forgot to mention that

the display at the bottom works right .. it sez displaying

21- 40 of 60 but the records displayed are still 0-60

what could be causing this?!?