Devam Ediyor

mySQL query + js & spry

1. Client wants a js/spry map and the spry checkboxes to work together (click the map & the corresponding checkbox automatically is checked & visa versa.)

2. We need to link the html page you worked on ([url removed, login to view]) with a search results page ([url removed, login to view])

3. There is a search details page that you probably will not need to work on but if you need it, it is ([url removed, login to view])

regarding item #2:

there are 2 searches. One that is a quick search using the field values shown when the collapsable panel is closed and the advanced search, that uses all the parameters EXCEPT the fields in the area dropdown will be overridden IF the map is used.

The contents of the amenities field will need to be buffered & EXPLODEd to (it is comma delimited within the field.)

I created a new db with one main table that contains 55 fields (columns) fed to us by NYC MLS.

There are 5 additional field that are automatically added

1. num (primary)

2. createdDate

3. createdByUserNum

[url removed, login to view]

5. updatedByUserNum

There is another important table : zipcodes

zipcodes lists all zipcodes in Manhattan and (a) matches them to 10 neighborhoods and to 6 sections that are provided in the MLS feed (in the main table described above.)

BTW you are right about the searches. There are no queries yet.

The exploded field "amenities" contains many of the search parameters such as 'garage, health club, laundry room, storage room, etc.' I have attached an excel spreadsheet containing a typical feed parsed out.

There is an identical table "featured" (identical to the 55 field main table (idxfeed)

This is for featured listings not listed with MLS.

Both tables have a field 'copyright_info'. The MLS feed ALWAYS has data in that field. The 'featured' table NEVER has data in that field. The idea is to join the tables and do a sort for any query results that show featured properties before MLS listed properties.

Beceriler: HTML, Javascript, MySQL, PHP

Daha fazlasını görün: mysql query spry, spry mysql, the mls, spreadsheet javascript, spreadsheet in javascript, n query, js spreadsheet, js do, index.idx, idx 5, idx 2, idx 1, idx 0, html 5 checkbox, excel advanced 2010, excel 2010 advanced, do i need a visa, advanced search results, spry html table mysql, php.js, php idx, if js, excel uses, mysql client, versa

İşveren Hakkında:
( 18 değerlendirme ) Cragsmoor, United States

Proje NO: #698455

8 freelancer bu iş için ortalamada 184$ teklif veriyor

urmi1

Please see PMB for more details...

in 6 gün içinde250$ USD
(111 Değerlendirme)
6.5
phpplay

Please see PM

in 7 gün içinde225$ USD
(20 Değerlendirme)
5.8
bdimuch

Hello, check PMB please.

1 gün içinde 120$ USD
(41 Değerlendirme)
5.7
YashpalSingh123

mysql/js professional, ready to start

in 3 gün içinde200$ USD
(12 Değerlendirme)
4.7
cristi0320

Hi, I am interested in this project

in 5 gün içinde170$ USD
(10 Değerlendirme)
3.8
domybest

Dear Sir, Let me try this. Thanks.

in 10 gün içinde150$ USD
(1 Değerlendirme)
2.4
NanoMicrosystems

we have very experienced and talented professionals in php,mysql,java,html,javascript,seo,joomla,asp, jsp,ajax,design and [url removed, login to view] we can handle this project very efficiently and properly. some of our work sample Daha fazlası

in 25 gün içinde220$ USD
(0 Değerlendirme)
0.0
kchowdary142

Hello, I have read your requirements, understand what you need and can provide my services for this job. I have flare of programming using new techniques, so please give me a chance to prove my worth. I am very k Daha fazlası

in 5 gün içinde140$ USD
(0 Değerlendirme)
0.0