Hi guys hope you guys could help me...
I have finish the page where customers will enter their fav. dishes(products) than it will store what they like in the favourites table as show below. After that i would like to do a page where i would enter the age and gender to search, it will than output the 5 most favourite dishes.
(((i want to see in the fav table how many times each product pops up and than count them and sort to see which one appears the most times...)))
So can some one help me with the array to count how many times the product has been selected by the customers and than sort them out in order of most time selected.
i hope u guys could provide me with the coding cause the coldfusion book does not give any nuts on array...
the link below is my database.
*NOTE: Data in the favourites goes like this-
.. so on pls help...