I need a snippet that will read from a TV (multi-select listbox) and return a set of rows from my database and output the values accordingly. I believe the SQL will need to join two tables as the data is coming from a property info table and a photo table (tables are normalized).
For more visual explanation:
My homepage ( http://www.oakvillerealestate4sale.ca/index.php?id=1
) will contain the snippet that will reference the TV called "Featured-Properties" which will have MLS numbers selectable by the client. He/She may select as many of these as they would like and it will display the featured properties accordingly (sorted from highest price to lowest) as so: http://cl.ly/0D2d3Q220P3z2K3a1s21
I need this by Saturday March 5th. This is for Evolution 1.0.4.