Tamamlanmış

The Vacation Brain Work

I noticed that something isn't quite working right with the questions that the guests answer on www.thevacationbrain.com. Try this to test it:

-Go to this page; [url removed, login to view]

-Choose one or more lodging types, then proceed to press the Next button on each page without changing the default answers for any questions. You will get a list of matches.

-Now do the same thing but on question 3 change some of the answers to numbers other than 1. It doesn't really matter what you choose, and it doesn't even matter if your answers for this question exactly match a property in the database...you will get no results when you finish the 10th question. The same thing seems to happen if you change the answers on question 5 or 7 as well.

I'm not sure what is wrong with the process, but questions 3, 5 & 7 seem to be excluding all listings if any numbers other than 1 are chosen for the answer. Any ideas what is wrong? Can yo fix this? Thanks!

Mark

Beceriler: PHP, Sorun Çözümleme

Daha fazlasını gör: work vacation, work ideas, what is work, brain, database troubleshooting, database vacation, php state list database, vacation property, vacation rental property website free templates, php database results ajax drag sort, build property website database, display database results php, php displaying database results, php property listing database, database results java flex webservice, php display database results link, php display database results, displaying database results website

İşveren Hakkında:
( 100 değerlendirme ) Spokane, United States

Proje NO: #4000688

Seçilen:

siliconforks

I believe the problem is caused by a MySQL upgrade on your server - the SQL code worked (mostly) with the old version of MySQL but generates an error with the new version (which is why you see no results). See http: Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 35%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(180 Değerlendirme)
6.1

Bu iş için 4 freelancer ortalamada $35 teklif veriyor

abhi1one

hey, it seems that the logic used behind Q 3,5,7 and generate prioritized results has some flaw. i may be able to help you out debug this but first i need to know where the logic is implemented, whether the quer Daha Fazla

$35 USD in 2 gün içinde
(0 Değerlendirme)
0.0
I496pJBhN

We are freelance software developers. If you contact me I can give a quote for your project and we can discuss the details. <b><i>Removed by Admin</i></b>

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
mnamjad

Hi, I am really interested in this job. I have more than 7 years experience in php/mysql. I can remove this error from you site.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0