Closed

php expert needed for search result page query fixing

basically we are looking for 21 days generalize formula

we will do a formula which will pick dates from 1-21 days

with 3 offers

search result page

[login to view URL]

------------------------------------- 5-12 june-----------------------

1. hotel villa svizzera 609 € but the price for this week in this hotel is 529+529

[login to view URL] onda blu also is wrong because the correct price is 269+269 not 690 €

[login to view URL] paradiso also is wrong because you show 898 but the correct is 998

4. missed many hotels like hotel san giovanni, hotel eden park, hotel stella maris, they not show in your search

[login to view URL] Maris from 5 to 12 june cost 345€ per person

[login to view URL] San Giovanni we have 2 offer:

1) from 21/05 to 11/06

2) from 11/06 to 9/07 and in this case we have to mix the 2 prices

==============================5-19 june===========

Annabelle is ok

Onda blu is wrong (correct is 1076)

Gran paradiso is wrong (correct is 1996€)

===========5-26 june===========

[login to view URL] is wrong (correct is 1890€

2. Gran paradiso is wrong, correct is 2994

3 hotel onda blu is wrong, correct is 1614€

Skills: PHP, SQL, MySQL, Website Testing, Website Management

About the Client:
( 20 reviews ) Hafizabad, Pakistan

Project ID: #33788871