you can view the PHP file that i have uploaded at <!-- w --><a class="postlink" href="http://www.kenemmertdesigns.com/catalog/allprods.php">www.kenemmertdesigns.com/catalog/allprods.php</a><!-- w -->
i am trying to figure out how i can make the table that displays in the middle of the page sort differently.
i think right now, it is by price of the item..... and second by name....
can somebody please tell me where it is that i would edit how it sorts?
ideally, it would sort by category (there are several categories for the site.... viewable by clicking one of the images on the left.
if somebody could help me out ASAP i would really appreciate it.
Thankscorrect me if I am wrong but when you view all products you don't have categories.but i want it to be sorted by category.... or to be able to sort it by name.... instead of just by price.you can't do it by category if you view all products. bu tyou can change the price order
on this line,
$listing_sql = "select ... order by p.products_price, pd.products_name"
change the order by to just the name
order by pd.products_name
i am trying to figure out how i can make the table that displays in the middle of the page sort differently.
i think right now, it is by price of the item..... and second by name....
can somebody please tell me where it is that i would edit how it sorts?
ideally, it would sort by category (there are several categories for the site.... viewable by clicking one of the images on the left.
if somebody could help me out ASAP i would really appreciate it.
Thankscorrect me if I am wrong but when you view all products you don't have categories.but i want it to be sorted by category.... or to be able to sort it by name.... instead of just by price.you can't do it by category if you view all products. bu tyou can change the price order
on this line,
$listing_sql = "select ... order by p.products_price, pd.products_name"
change the order by to just the name
order by pd.products_name