We have a website that holds a list of events within 3 tables.
allsites_cinema_address holds all of the addresses and long/lat values
master_seat_detail holds all of the shows taking place along, the start time, the live date, the event date, etc. along with the relevant address id.
master_film holds all of the event information including event name and whether it is live or not.
I want a separate page with a static login, which will allow a user to enter a post code, select a radius (textbox allowing numbers only up to 999)
And a button called SEARCH.
When a user clicks the button, it will search based on the following query and return a set of results in a css-styled table format.
select f.film_name, [login to view URL], a.post_code, s.unique_date, s.scr_time from master_film f, master_seat_detail s, allsites_cinema_address a WHERE f.live=1 and f.live_date<now() and [login to view URL] <now() and s.unique_date>now() and s.film_id=[login to view URL] and s.location_id=[login to view URL] and [[login to view URL] is within selected radius of the submitted postcode].
For the right bidder I will provide:
3 x example tables
Header & footer php files which must be used as part of the page
We cannot give you access to our servers so you'll need to develop on your own environment and show us working page before payment.
47 freelancers estão ofertando em média $156 para esse trabalho
Hello, This project is quite easy for me, but I got couple of questions to clear before we proceed [login to view URL] message me to have a quick chat.
Just give us the chance to prove ourselves....... We have some questions to clarify,please reply us so we could discuss the project in details. Thanks & Regards Moumita
Hello, i am ready to implement search by postcode tool for our events website as per requirement. I assure you quality work and support. Please open message board for further discussion. Thanks Ramesh