[funkydunk]

forgot to say that the file is called by going to yourdomain.com/total_list.php?main=listall

Also that I have sorted it by category name but this can be changed by amending the sql order by code in all_products.php.