Quote:
Originally Posted by naplesrealestate
...The hardest part is still to come - big learning curve! Setting up the SQL, then learning the PHP and writing the program that I want, also finding the ftp script to do the nightly download and upload.
|
Before setting up the sql you need define the fields. Here is an example of the main listing db table:
FIELDS:
title
contact
type
subdivsion
price
sold_price
county
address
city
state
zip
country
description
floors
beds
baths
half_baths
year_built
view
school_district
square_feet
garage
lot_size
acres
property_features
community_features
status
featured
elements_01
elements_02
creation_date
expiration_date
listingsdb_last_modified
notes
mls_id
mls_name
mls_broker
mls_agent
legal
latitude
longitude
hit_count
Additional tables can be used for "School Names," and listings features such as pools, fireplaces, etc.