Ninjakreborn

On Youtube you click "Embed this video". Then copy/paste the code into your site. It's probably pretty similar for the other video sites as well.

I do not understand what you mean. Can you rephrase that question?

Please post ALL of your code, and be specific about what you are trying to achieve.

1. Crawl the HTML files, and save them in a file locally. 2. Use this: http://stackoverflow.com/questions/215896/how-to-use-php-to-delete-x-number-of-lines-from-the-beginning-of-a-text-file To strip out X number of lines from the file (in your case, 14) from the beginning. 3. Use standard regex for the string replaces (or str_replace). Then just strip off the last 3 lines (reverse engineer some of what you found in #2, or just str_replace over </body> and </html> with an empty space.

Read through this: http://www.linuxquestions.org/questions/programming-9/mysql-and-php-multibyte-character-support-311060/

By "Backend" I think he means the torrenting server, right?

Reading is good, but practice is better. Read through a few simple books. Then create a personal project, jump in, and figure it out as you go. I spent a LONG time reading books. I never learned much until I start "practicing" it and trial by fire.

I generally use my own, or Codeignitor. I have been hearing too much about Symfony lately...I might play with it this weekend.

I would start by not posting like a 13 year old girl. Your on a roll today. I almost fell out of my chair laughing.

That made my day. In regards to the question, out of curiosity what is the purpose behind you wanting to develop it that way? Maybe what you are trying to do is go about a specific issue the wrong way, perhaps we can point you in the right direction.

Well either way, once you get done with your interview, tell us how it went. When is your interview?

@KingPhilip - The android SDK is free, but to load something into the market you have to pay their 25.00 developer fee to get access to the market. So in essence you need the 25.00 anyway. Unless your throwing it on some random website and not in the market.

Iphone is 75.00 (I think if I recall correctly) and Android is 25. Good job on that system.

I didn't necessarily mean source code (unless it's open source). I just want to know where to download it. App is pretty. Also, how much is the premium version going to cost?

You built this? If you did....I am impressed. Nice work. I will buy a copy of that, if you decide to sell it. Looks really good, nice design sense.

I finally got it moved over. I had to do it one table at a time, and make quite a few adjustments, but was able to get it all imported. Thanks again guys for the feedback.

Any ideas for some simple (yet useful) C++ apps you have always wanted but can't find anywhere? I am feeling a little ambitious right now, but can't think of any decent ideas for desktop apps. I have been doing C++ For awhile. I am not extremely complex with it yet, but I can write just about any standard console app, and can probably do some simple windows apps now. Just can't seem to think of anything that would be halfway useful.

CREATE TABLE Areas ( Short varchar (3), `Long` varchar (50), Town smallint, Mappable bit ) CREATE TABLE BU ( LIST_NO int, BASEMENT_FEATURE varchar (10), BLDG_SQ_FEET numeric(12, 0), BUILDING_CONSTRUCTION varchar (20), BUSINESS_HRS varchar (10), BU_TYPE varchar (1), DOCUMENTS_ON_FILE varchar (40), ELEVATOR varchar (1), EQUIP_LIST_AVAIL varchar (1), FACILITIES varchar (20), FORM varchar (10), GROSS_ANNUAL_EXP numeric(12, 0), GROSS_ANNUAL_INCOME numeric(12, 0), HANDICAP_ACCESS varchar (1), INVENTORY_AVAIL varchar (1), LOCATION varchar (30), NET_OPERATING_INC numeric(12, 0), NO_OF_DRIVING_DOORS tinyint, NO_OF_LOADING_DOCKS tinyint, NO_OF_RESTROOMS tinyint, OWNER_TRAINING varchar (1), PARKING_SPCS smallint, REAL_ESTATE_INCLD varchar (1), REAL_ESTATE_LN varchar (, REASON_FOR_SELL varchar (20), SPECIAL_FINANCING varchar (1), SPECIAL_LICENSES varchar (10), SYSTEM varchar (20), TENANT_EXPENSES varchar (30), TERMS_FEATURE varchar (20), TRAFFIC_COUNT int, UTILITIES varchar (30), ZONE_DESCRIPTION varchar (10) ) CREATE TABLE CC ( LIST_NO int, AMENITIES varchar (21), APPLIANCES varchar (29), ASSC_FEE_INCLUDES varchar (65), ASSC_POOL varchar (1), ASSOC_SECURITY varchar (13), BEACH_DESCRIPTION varchar (13), BEACH_MILES_TO varchar (9), BEACH_OWNERSHIP varchar (9), BED2_DIMEN varchar (5), BED2_DSCRP varchar (39), BED2_LEVEL varchar (1), BED3_DIMEN varchar (5), BED3_DSCRP varchar (39), BED3_LEVEL varchar (1), BED4_DIMEN varchar (5), BED4_DSCRP varchar (39), BED4_LEVEL varchar (1), BTH1_DIMEN varchar (5), BTH1_DSCRP varchar (39), BTH1_LEVEL varchar (1), BTH2_DIMEN varchar (5), BTH2_DSCRP varchar (39), BTH2_LEVEL varchar (1), CC_TYPE varchar (1), COMPLEX_COMPLETE varchar (1), CONDOMINIUM_NAME varchar (40), CONDO_ASSOCIATION varchar (1), CONSTRUCTION varchar (15), COOLING varchar (23), COOLING_ZONES tinyint, DIN_DIMEN varchar (5), DIN_DSCRP varchar (39), DIN_LEVEL varchar (1), DOCUMENTS_ON_FILE varchar (17), ELECTRIC_FEATURE varchar (17), ENERGY_FEATURES varchar (17), EXTERIOR varchar (25), EXTERIOR_UNIT_FEATURES varchar (53), FAM_DIMEN varchar (5), FAM_DSCRP varchar (39), FAM_LEVEL varchar (1), FLOORING varchar (19), GARAGE_PARKING varchar (25), GARAGE_SPACES tinyint, HEATING varchar (41), HEAT_ZONES tinyint, HOA_FEE numeric(12, 2), HOT_WATER varchar (19), INSULATION_FEATURE varchar (19), INTERIOR_FEATURES varchar (19), KIT_DIMEN varchar (5), KIT_DSCRP varchar (39), KIT_LEVEL varchar (1), LAUNDRY_DIMEN varchar (5), LAUNDRY_DSCRP varchar (39), LAUNDRY_LEVEL varchar (1), LEAD_PAINT varchar (7), LIV_DIMEN varchar (5), LIV_DSCRP varchar (39), LIV_LEVEL varchar (1), MANAGEMENT varchar (15), MASTER_BOOK varchar (6), MASTER_PAGE varchar (4), MBR_DIMEN varchar (5), MBR_DSCRP varchar (39), MBR_LEVEL varchar (1), NO_LIVING_LEVELS smallint, NO_UNITS smallint, NO_UNITS_OWNER_OCC smallint, OPTIONAL_FEE numeric(12, 2), OPT_FEE_INCLUDES varchar (63), OTH1_DIMEN varchar (5), OTH1_DSCRP varchar (39), OTH1_LEVEL varchar (1), OTH1_ROOM_NAME varchar (3), OTH1_ROOM_NAME_LONG varchar (13), OTH2_DIMEN varchar (5), OTH2_DSCRP varchar (39), OTH2_LEVEL varchar (1), OTH2_ROOM_NAME varchar (3), OTH2_ROOM_NAME_LONG varchar (13), OTH3_DIMEN varchar (5), OTH3_DSCRP varchar (39), OTH3_LEVEL varchar (1), OTH3_ROOM_NAME_LONG varchar (3), OTH3_ROOM_NAME varchar (13), OTH4_DIMEN varchar (5), OTH4_DSCRP varchar (39), OTH4_LEVEL varchar (1), OTH4_ROOM_NAME varchar (3), OTH4_ROOM_NAME_LONG varchar (13), OTH5_DIMEN varchar (5), OTH5_DSCRP varchar (39), OTH5_LEVEL varchar (1), OTH5_ROOM_NAME varchar (3), OTH5_ROOM_NAME_LONG varchar (13), OTH6_DIMEN varchar (5), OTH6_DSCRP varchar (39), OTH6_LEVEL varchar (1), OTH6_ROOM_NAME varchar (3), OTH6_ROOM_NAME_LONG varchar (13), OWNER_OCC_SOURCE varchar (11), PARKING_FEATURE varchar (15), PARKING_SPACES smallint, POOL_DESCRIPTION varchar (9), RESTRICTIONS varchar (9), ROOF_MATERIAL varchar (17), SEWAGE_DISTRICT varchar (5), SEWER_AND_WATER varchar (17), STYLE varchar (39), TERMS_FEATURE varchar (15), UFFI varchar (1), UNIT_BUILDING varchar (11), UNIT_LEVEL tinyint, UNIT_PLACEMENT varchar (16), UTILITY_CONNECTIONS varchar (17), WARRANTY varchar (1), WATERFRONT varchar (25), YEAR_CONVERTED smallint, YEAR_ROUND varchar (1), BED5_DIMEN varchar (5), BED5_DSCRP varchar (39), BED5_LEVEL varchar (1), BTH3_DIMEN varchar (5), BTH3_DSCRP varchar (39), BTH3_LEVEL varchar (1), PETS_ALLOWED varchar (1) ) CREATE TABLE CI ( LIST_NO int, ON_FILE_21E varchar (1), ASSC_FEE_INCLUDES varchar (65), ASSESSED_VALUE_BLDG numeric(12, 0), ASSESSED_VALUE_LAND numeric(12, 0), CEILING_HEIGHT tinyint, CI_TYPE varchar (1), CONDO_ASSOCIATION varchar (1), CONSTRUCTION varchar (15), DEPTH int, DIVIDABLE varchar (1), EASEMENTS varchar (1), ELEVATOR varchar (1), EXCHANGE varchar (1), EXPANDABLE varchar (1), GROSS_ANNUAL_EXP numeric(12, 0), GROSS_ANNUAL_INCOME numeric(12, 0), HANDICAP_ACCESS varchar (1), HOA_FEE numeric(12, 2), LEASE varchar (1), LEASE_PRICE_INCLUDES varchar (9), LEASE_TYPE varchar (3), LIEN_AND_ENCUMBENT varchar (1), LOCATION varchar (27), MAF_BLDG_SF numeric(12, 0), MAU_UNITS tinyint, MILL_RATE numeric(12, 2), NET_OPERATING_INC numeric(12, 0), NO_BUILDINGS smallint, NO_OF_DRIVING_DOORS tinyint, NO_OF_LOADING_DOCKS tinyint, NO_OF_RESTROOMS tinyint, NO_STORIES smallint, NO_UNITS smallint, OFF_BLDG_SF numeric(12, 0), OFU_UNITS tinyint, PARKING_FEATURE varchar (15), PARKING_SPACES smallint, PLAT_PLAN varchar (1), RAILROAD_SIDING varchar (1), REF_BLDG_SF numeric(12, 0), REU_UNITS smallint, ROOF_MATERIAL varchar (11), RSF_BLDG_SF numeric(12, 0), RSU_UNITS smallint, SITE_CONDITION varchar (13), SPACE_AVAILABLE varchar (5), SPECIAL_FINANCING varchar (1), SPRINKLERS varchar (1), SUBLET varchar (1), SUB_DIVIDABLE varchar (1), SURVEY varchar (1), TOTAL_ASSESSED_VALUE numeric(12, 0), TOTAL_BLDG_SF numeric(12, 0), TOTAL_UNITS smallint, TRAFFIC_COUNT int, UNDRGRND_TANK varchar (1), UTILITIES varchar (25), WAF_BLDG_SF numeric(12, 0), WAU_UNITS tinyint, ZONE_DESCRIPTION varchar (5) ) CREATE TABLE Counties ( Short varchar (4), `Long` varchar (50) ) CREATE TABLE Field_Reference ( id int, sf bit, cc bit, mf bit, ld bit, ci bit, bu bit, rn bit, Field varchar (32), Short varchar (3), Medium varchar (5), `Long` varchar (50), mh bit ) CREATE TABLE HISTORY_BULK( KeyId int, Change_Date smalldatetime, LIST_NO int, Old_Value varchar(64), New_Value varchar(64), Who varchar(12), Field varchar(50), Update_Date smalldatetime, Active_Flag bit ) CREATE TABLE IDX_Optout ( Office ID nvarchar (6), Opt_Out_Date smalldatetime, msrepl_tran_version uniqueidentifier ) CREATE TABLE IDX_Optout_Listings ( LIST_NO char (, msrepl_tran_version uniqueidentifier ) CREATE TABLE LD ( LIST_NO int, AMENITIES varchar (21), BEACH_DESCRIPTION varchar (13), BEACH_MILES_TO varchar (9), BEACH_OWNERSHIP varchar (9), CABLE_AVAILABLE varchar (1), CULTIVATION_ACRES numeric(12, 2), DEQE varchar (10), DOCUMENTS_ON_FILE varchar (42), ELECTRIC_FEATURE varchar (11), GAS varchar (9), HOA_FEE numeric(12, 2), HOME_OWN_ASSOCIATION varchar (1), IMPROVEMENTS varchar (20), LAND_DESC varchar (30), LD_TYPE varchar (1), NO_LOTS smallint, PASTURE_ACRES numeric(12, 2), PERC_TEST varchar (1), PERC_TEST_DATE smalldatetime, REQD_OWN_ASSOCIATION varchar (1), ROAD_TYPE varchar (32), SEWAGE_DISTRICT varchar (5), SEWER varchar (11), TIMBER_ACRES numeric(12, 2), WATER varchar (11), WATERFRONT varchar (26), ZONE_USAGE varchar ( ) CREATE TABLE MF ( LIST_NO int, AMENITIES varchar (21), APOD_AVAILABLE varchar (1), APP_COMMON varchar (29), APP_DSCRP_1 varchar (29), APP_DSCRP_2 varchar (29), APP_DSCRP_3 varchar (29), APP_DSCRP_4 varchar (29), BASEMENT_FEATURE varchar (27), BEACH_DESCRIPTION varchar (13), BEACH_MILES_TO varchar (9), BEACH_OWNERSHIP varchar (9), BEDRMS_1 tinyint, BEDRMS_2 tinyint, BEDRMS_3 tinyint, BEDRMS_4 tinyint, COLOR varchar (10), COL_COMMON varchar (23), COL_DSCRP_1 varchar (23), COL_DSCRP_2 varchar (23), COL_DSCRP_3 varchar (23), COL_DSCRP_4 varchar (23), CONSTRUCTION varchar (15), COOLING_UNITS tinyint, COOLING_ZONES tinyint, ELEC smallint, ELECTRIC_FEATURE varchar (23), ENERGY_FEATURES varchar (19), EXPENSES_SOURCE varchar (17), EXPENSES_YEAR_END varchar (5), EXTERIOR varchar (27), EXTERIOR_FEATURES varchar (55), FLOORING varchar (19), FLRS_1 tinyint, FLRS_2 tinyint, FLRS_3 tinyint, FLRS_4 tinyint, FOUNDATION varchar (13), FOUNDATION_SIZE varchar (15), FRPLCS_1 tinyint, FRPLCS_2 tinyint, FRPLCS_3 tinyint, FRPLCS_4 tinyint, F_BTHS_1 tinyint, F_BTHS_2 tinyint, F_BTHS_3 tinyint, F_BTHS_4 tinyint, GARAGE_SPACES tinyint, GOI int, GRE int, GSE smallint, HEAT_UNITS tinyint, HEAT_ZONES tinyint, HEA_COMMON varchar (41), HEA_DSCRP_1 varchar (41), HEA_DSCRP_2 varchar (41), HEA_DSCRP_3 varchar (41), HEA_DSCRP_4 varchar (41), HOT_WATER varchar (21), HTE smallint, H_BTHS_1 tinyint, H_BTHS_2 tinyint, H_BTHS_3 tinyint, H_BTHS_4 tinyint, IFE_COMMON varchar (31), IFE_DSCRP_1 varchar (31), IFE_DSCRP_2 varchar (31), IFE_DSCRP_3 varchar (31), IFE_DSCRP_4 varchar (31), INSC smallint, LEAD_PAINT varchar (7), LEASE_1 varchar (1), LEASE_2 varchar (1), LEASE_3 varchar (1), LEASE_4 varchar (1), LEVELS tinyint, LEVELS_1 tinyint, LEVELS_2 tinyint, LEVELS_3 tinyint, LEVELS_4 tinyint, LOT_DESCRIPTION varchar (23), MF_TYPE varchar (1), MGF smallint, MSE smallint, NOI int, NO_UNITS smallint, PARKING_FEATURE varchar (11), PARKING_SPACES smallint, RENT1 smallint, RENT2 smallint, RENT3 smallint, RENT4 smallint, RFS smallint, RME smallint, RMS_1 tinyint, RMS_2 tinyint, RMS_3 tinyint, RMS_4 tinyint, RMS_COMMON varchar (11), RMS_DSCRP_1 varchar (11), RMS_DSCRP_2 varchar (11), RMS_DSCRP_3 varchar (11), RMS_DSCRP_4 varchar (11), RNT_DSCRP_1 varchar (13), RNT_DSCRP_2 varchar (13), RNT_DSCRP_3 varchar (13), RNT_DSCRP_4 varchar (13), ROAD_TYPE varchar (19), ROOF_MATERIAL varchar (17), SEW smallint, SEWAGE_DISTRICT varchar (5), SEWER_AND_WATER varchar (17), TERMS_FEATURE varchar (13), TOTAL_BRS tinyint, TOTAL_FBH tinyint, TOTAL_FLRS tinyint, TOTAL_FRPLCS tinyint, TOTAL_HBH tinyint, TOTAL_LEVELS tinyint, TOTAL_RENT smallint, TOTAL_RMS tinyint, TOTAL_ROOMS tinyint, UFFI varchar (1), UTILITY_CONNECTIONS varchar (17), WARRANTY varchar (1), WATERFRONT varchar (25), WSE smallint, YEAR_ROUND varchar (1) ) CREATE TABLE Member ( Member_Number int, Last_Name varchar(30), First_Name varchar(12), Middle_Initial varchar(1), Generation varchar(3), Full_Name varchar(34), Nickname varchar(12), Office_Number int, Title varchar(4), Salutation varchar(24), Designations varchar(1), Care_of varchar(30), Street_Address varchar(30), City varchar(21), State varchar(2), Home_Zip_Code varchar(5), Home_Zip_Plus_4 varchar(4), MLS_ID varchar(12), Home_Phone_Area varchar(3), Home_Phone_Number varchar(7), Preferred_Mail varchar(1), Last_Modify_Date char(, Office_ID varchar(12), Personal_Fax_Area varchar(3), Personal_Fax_Phone varchar(7), ) CREATE TABLE Member_Association ( Member_Number int, Association_ID varchar (4), Member_Type_Code varchar (3), Status varchar (1), Status_Date char (, Last_Modify_Date char (, Online_Status varchar (1) ) CREATE TABLE MH ( LIST_NO int, AMENITIES varchar (22), APPLIANCES varchar (29), BASEMENT_FEATURE varchar (27), BEACH_DESCRIPTION varchar (13), BEACH_MILES_TO varchar (9), BEACH_OWNERSHIP varchar (9), BED2_DIMEN varchar (5), BED2_DSCRP varchar (39), BED2_LEVEL varchar (1), BED3_DIMEN varchar (5), BED3_DSCRP varchar (39), BED3_LEVEL varchar (1), BED4_DIMEN varchar (5), BED4_DSCRP varchar (39), BED4_LEVEL varchar (1), BED5_DIMEN varchar (5), BED5_DSCRP varchar (39), BED5_LEVEL varchar (1), BTH1_DIMEN varchar (5), BTH1_DSCRP varchar (39), BTH1_LEVEL varchar (1), BTH2_DIMEN varchar (5), BTH2_DSCRP varchar (39), BTH2_LEVEL varchar (1), BTH3_DIMEN varchar (5), BTH3_DSCRP varchar (39), BTH3_LEVEL varchar (1), COLOR varchar (10), CONSTRUCTION varchar (15), COOLING varchar (15), COOLING_ZONES tinyint, DIN_DIMEN varchar (5), DIN_DSCRP varchar (39), DIN_LEVEL varchar (1), ELECTRIC_FEATURE varchar (17), ENERGY_FEATURES varchar (17), EXTERIOR varchar (25), EXTERIOR_FEATURES varchar (53), FAM_DIMEN varchar (5), FAM_DSCRP varchar (39), FAM_LEVEL varchar (1), FLOORING varchar (19), FOUNDATION varchar (13), FOUNDATION_SIZE varchar (15), GARAGE_PARKING varchar (25), GARAGE_SPACES tinyint, HEATING varchar (41), HEAT_ZONES tinyint, HOA_FEE numeric(12, 2), HOME_OWN_ASSOCIATION varchar (1), HOT_WATER varchar (21), INSULATION_FEATURE varchar (21), INTERIOR_FEATURES varchar (21), KIT_DIMEN varchar (5), KIT_DSCRP varchar (39), KIT_LEVEL varchar (1), LAUNDRY_DIMEN varchar (5), LAUNDRY_DSCRP varchar (39), LAUNDRY_LEVEL varchar (1), LEAD_PAINT varchar (7), LIV_DIMEN varchar (5), LIV_DSCRP varchar (39), LIV_LEVEL varchar (1), LOT_DESCRIPTION varchar (23), MBR_DIMEN varchar (5), MBR_DSCRP varchar (39), MBR_LEVEL varchar (1), OTH1_DIMEN varchar (5), OTH1_DSCRP varchar (39), OTH1_LEVEL varchar (1), OTH1_ROOM_NAME varchar (13), OTH2_DIMEN varchar (5), OTH2_DSCRP varchar (39), OTH2_LEVEL varchar (1), OTH2_ROOM_NAME varchar (13), OTH3_DIMEN varchar (5), OTH3_DSCRP varchar (39), OTH3_LEVEL varchar (1), OTH3_ROOM_NAME varchar (13), OTH4_DIMEN varchar (5), OTH4_DSCRP varchar (39), OTH4_LEVEL varchar (1), OTH4_ROOM_NAME varchar (13), OTH5_DIMEN varchar (5), OTH5_DSCRP varchar (39), OTH5_LEVEL varchar (1), OTH5_ROOM_NAME varchar (13), OTH6_DIMEN varchar (5), OTH6_DSCRP varchar (39), OTH6_LEVEL varchar (1), OTH6_ROOM_NAME varchar (13), PARKING_FEATURE varchar (9), PARKING_SPACES smallint, REQD_OWN_ASSOCIATION varchar (1), ROAD_TYPE varchar (19), ROOF_MATERIAL varchar (17), SEWAGE_DISTRICT varchar (5), SEWER_AND_WATER varchar (15), STYLE varchar (35), TERMS_FEATURE varchar (13), UFFI varchar (1), UTILITY_CONNECTIONS varchar (17), WARRANTY varchar (1), WATERFRONT varchar (25), YEAR_ROUND varchar (1) ) CREATE TABLE Office ( Office_Number int, Office_Name varchar (30), MLS_Number varchar (12), Street_Care_of varchar (30), Street_Address varchar (30), Street_City varchar (21), Street_State varchar (2), Street_Zip_Code varchar (5), Street_Zip_Plus_4 varchar (4), Street_Country_Code varchar (2), Mail_Care_of varchar (30), Mail_Address varchar (30), Mail_City varchar (21), Mail_State varchar (2), Mail_Zip_Code varchar (5), Mail_Zip_Plus_4 varchar (4), Mail_Country_Code varchar (2), Office_Area_Code varchar (3), Office_Phone varchar (7), Fax_Area_Code varchar (3), Fax_Phone varchar (7), Responsible_Member int, Office_Contact_Member int, Main_Office_Number int, Last_Modify_Date char (, Long_Name varchar (100) ) CREATE TABLE Office_Association ( Association_ID varchar (4), Office_Number int, Office_Type varchar (4), Status varchar (1), Status_Date char (, Last_Modify_Date char (, Online_Status varchar (1) ) CREATE TABLE Open_Houses ( LIST_NO int, Comments varchar (500), Start_Date smalldatetime, End_Date smalldatetime, Duration int, DateModified smalldatetime ) CREATE TABLE PAll ( LIST_NO int, ACRE numeric(12, 2), ANT_SOLD_DATE smalldatetime, AREA varchar (3), ASSESSMENTS numeric(12, 0), BASEMENT varchar (1), BEACHFRONT_FLAG varchar (1), BLOCK varchar (6), BOOK varchar (6), BUYER_BROKER_COMP varchar (10), CERTIFICATE_NUMBER varchar (10), DIRECTION varchar (100), DISCLOSURE varchar (1), ENTRY_ONLY varchar (1), FIN_CODE tinyint, FIRE_PLACES tinyint, FIRM_RMK1 varchar (100), TEAM_MEMBER varchar (60), FRONTAGE numeric(12, 0), GRADE_SCHOOL varchar (15), HIGH_SCHOOL varchar (15), LISTING_AGREEMENT varchar (19), LIST_AGENT varchar (, LIST_DATE smalldatetime, LIST_DATE_RCVD smalldatetime, LIST_OFFICE varchar (6), LIST_PRICE numeric(12, 2), LOT varchar (6), MAIN_LO varchar (6), MAIN_SO varchar (6), MAP varchar (6), MASTER_BATH varchar (1), MIDDLE_SCHOOL varchar (15), NO_BEDROOMS smallint, NO_FULL_BATHS smallint, NO_HALF_BATHS smallint, NO_ROOMS smallint, OFF_MKT_DATE smalldatetime, ORIG_PRICE numeric(12, 2), OTHER_AGENT_COMP varchar (10), PAGE varchar (4), PARCEL_NUMBER varchar (36), PHOTO_COUNT smallint, PHOTO_DATE smalldatetime, PHOTO_MASK int, PROP_TYPE varchar (2), REMARKS varchar (500), SALE_AGENT varchar (, SALE_OFFICE varchar (6), SALE_PRICE numeric(12, 2), SELLER_DISCOUNT_PTS varchar (10), SELLING_BROKER_COMP varchar (10), SETTLED_DATE smalldatetime, SHOW_INSTRUCTION varchar (100), SOLD_VS_RENT varchar (2), SQUARE_FEET numeric(12, 0), SQUARE_FEET_SOURCE varchar (2), STATUS varchar (3), STATUS_DATE smalldatetime, STREET_NO varchar (10), STREET_NAME varchar (30), SUB_AREA varchar (4), TAX_YEAR varchar (4), TAXES numeric(12, 2), TOWN_NUM smallint, UPDATE_DATE smalldatetime, WATERFRONT_FLAG varchar (1), YEAR_BUILT smallint, YEAR_BUILT_DESCRP varchar (16), YEAR_BUILT_SOURCE varchar (2), ZIP_CODE varchar (5), ZIP_CODE_4 varchar (4), ZONING varchar (10), LISTING_ALERT varchar (1), ALERT_COMMENTS varchar (100), RENT_PRICE decimal(11, 2), NEIGHBORHOOD varchar (100), STREET_NUM int, ADULT_COMMUNITY varchar (1), DISCLOSURES varchar (100), EXCLUSIONS varchar (100), HOW_SHOWN_BB varchar (25), HOW_SHOWN_FB varchar (25), HOW_SHOWN_SB varchar (25), LOT_SIZE numeric(12, 2), SHOWINGS_DEFERRAL_DATE smalldatetime, SQUARE_FEET_OTHER numeric(12, 2), SUB_AGENCY_OFFERED varchar (1), SELLER_CONCESSIONS_AT_CLOSING numeric(12, 2), UNIT_NO varchar (11), MARKET_TIME_BROKER int, MARKET_TIME_PROPERTY int, SQUARE_FEET_INCL_BASE varchar (1), SQUARE_FEET_DISCLOSURES varchar (100), LENDER_OWNED char (1), SHORT_SALE_LENDER_APP_REQD char (1) ) CREATE TABLE RN ( LIST_NO int, AIR_CONDITION varchar (1), AMENITIES varchar (21), APPLIANCES varchar (30), BEACH_MILES_TO varchar (10), CONDO_ASSOCIATION varchar (1), COOP_COMP varchar (10), DEPOSIT_REQD varchar (1), EXTERIOR_FEATURES varchar (53), FOR_SALE varchar (1), HEATING varchar (10), INSURANCE_REQD varchar (1), INTERIOR_BLDG_FEAT varchar (15), LAST_MON_REQD varchar (1), LEAD_PAINT varchar (10), LEASE_TERMS varchar (6), PARKING_SPACES smallint, PETS_ALLOWED varchar (1), POSSESSION varchar (11), REFERENCES_REQD varchar (1), RENTAL_TERMS varchar (10), RENT_FEE_INCLUDES varchar (41), RN_TYPE varchar (1), SEC_DEPOSIT numeric(12, 0), TERM_OF_RENTAL varchar (6), UFFI varchar (1), UNIT_BUILDING varchar (11), UNIT_LEVEL tinyint, YEAR_ROUND varchar (1), FIRST_MON_REQD varchar (1) ) CREATE TABLE Reference_Updates ( table_name varchar (50), Updated smalldatetime ) CREATE TABLE SF ( LIST_NO int, AMENITIES varchar (22), APPLIANCES varchar (29), BASEMENT_FEATURE varchar (27), BEACH_DESCRIPTION varchar (13), BEACH_MILES_TO varchar (9), BEACH_OWNERSHIP varchar (9), BED2_DIMEN varchar (5), BED2_DSCRP varchar (39), BED2_LEVEL varchar (1), BED3_DIMEN varchar (5), BED3_DSCRP varchar (39), BED3_LEVEL varchar (1), BED4_DIMEN varchar (5), BED4_DSCRP varchar (39), BED4_LEVEL varchar (1), BED5_DIMEN varchar (5), BED5_DSCRP varchar (39), BED5_LEVEL varchar (1), BTH1_DIMEN varchar (5), BTH1_DSCRP varchar (39), BTH1_LEVEL varchar (1), BTH2_DIMEN varchar (5), BTH2_DSCRP varchar (39), BTH2_LEVEL varchar (1), BTH3_DIMEN varchar (5), BTH3_DSCRP varchar (39), BTH3_LEVEL varchar (1), COLOR varchar (10), CONSTRUCTION varchar (15), COOLING varchar (15), COOLING_ZONES tinyint, DIN_DIMEN varchar (5), DIN_DSCRP varchar (39), DIN_LEVEL varchar (1), ELECTRIC_FEATURE varchar (17), ENERGY_FEATURES varchar (17), EXTERIOR varchar (25), EXTERIOR_FEATURES varchar (53), FAM_DIMEN varchar (5), FAM_DSCRP varchar (39), FAM_LEVEL varchar (1), FLOORING varchar (19), FOUNDATION varchar (13), FOUNDATION_SIZE varchar (15), GARAGE_PARKING varchar (25), GARAGE_SPACES tinyint, HEATING varchar (41), HEAT_ZONES tinyint, HOA_FEE numeric(12, 2), HOME_OWN_ASSOCIATION varchar (1), HOT_WATER varchar (21), INSULATION_FEATURE varchar (21), INTERIOR_FEATURES varchar (21), KIT_DIMEN varchar (5), KIT_DSCRP varchar (39), KIT_LEVEL varchar (1), LAUNDRY_DIMEN varchar (5), LAUNDRY_DSCRP varchar (39), LAUNDRY_LEVEL varchar (1), LEAD_PAINT varchar (7), LIV_DIMEN varchar (5), LIV_DSCRP varchar (39), LIV_LEVEL varchar (1), LOT_DESCRIPTION varchar (23), MBR_DIMEN varchar (5), MBR_DSCRP varchar (39), MBR_LEVEL varchar (1), OTH1_DIMEN varchar (5), OTH1_DSCRP varchar (39), OTH1_LEVEL varchar (1), OTH1_ROOM_NAME varchar (13), OTH2_DIMEN varchar (5), OTH2_DSCRP varchar (39), OTH2_LEVEL varchar (1), OTH2_ROOM_NAME varchar (13), OTH3_DIMEN varchar (5), OTH3_DSCRP varchar (39), OTH3_LEVEL varchar (1), OTH3_ROOM_NAME varchar (13), OTH4_DIMEN varchar (5), OTH4_DSCRP varchar (39), OTH4_LEVEL varchar (1), OTH4_ROOM_NAME varchar (13), OTH5_DIMEN varchar (5), OTH5_DSCRP varchar (39), OTH5_LEVEL varchar (1), OTH5_ROOM_NAME varchar (13), OTH6_DIMEN varchar (5), OTH6_DSCRP varchar (39), OTH6_LEVEL varchar (1), OTH6_ROOM_NAME varchar (13), PARKING_FEATURE varchar (9), PARKING_SPACES smallint, REQD_OWN_ASSOCIATION varchar (1), ROAD_TYPE varchar (19), ROOF_MATERIAL varchar (17), SEWAGE_DISTRICT varchar (5), SEWER_AND_WATER varchar (15), SF_TYPE varchar (1), STYLE varchar (39), TERMS_FEATURE varchar (13), UFFI varchar (1), UTILITY_CONNECTIONS varchar (17), WARRANTY varchar (1), WATERFRONT varchar (25), YEAR_ROUND varchar (1) ) CREATE TABLE Status ( Short varchar (4), `Long` varchar (50), STAT_SORT int, CMA_Sort int ) CREATE TABLE Towns ( Number smallint, `Long` varchar (64), Board varchar (4), County varchar (4), Short varchar (4), TaxNum smallint, State char (2), Region tinyint ) CREATE TABLE Virtual_Tour_Reference ( TOUR_TYPE smallint, ICON varchar (255), TOOLTIP varchar (255) ) CREATE TABLE Virtual_Tours ( id int, LIST_NO int, TOUR_URL varchar (255), TOUR_TYPE smallint, UPDATE_DATE smalldatetime ) CREATE TABLE PAll_Coords ( List_no int, Lat decimal(11, 6), `Long` decimal(11, 6), Coord_Source varchar(4), Prop_Id int ) CREATE TABLE Teams ( id int, AgentId varchar (, TeamId varchar ( ) Added Backticks. That got me further, now it's throwing... Error #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE BU ( LIST_NO int, BASEMENT_FEATURE varchar (10), BLDG_SQ_FEET' at line 8 Any feedback? I have to replicate pretty much this same SQL structure. I am interfacing with an external MLS structure, and the field names/table names have to all be the same, unfortunately. So I had to work around the reserved keywords (backticks).

Bah, this MLS system is killing me. I am trying to tap into an MLS and they have this database not setup right. I guess I will have to use Backticks, since I have to replicate the exact same data. So the keywords..I had a feeling, I already knew Long was a keyword..not sure why I didn't realize that to begin with. Thanks again.

Here is the SQL: CREATE TABLE Areas ( Short varchar (3), Long varchar (50), Town smallint, Mappable bit ) CREATE TABLE BU ( LIST_NO int, BASEMENT_FEATURE varchar (10), BLDG_SQ_FEET numeric(12, 0), BUILDING_CONSTRUCTION varchar (20), BUSINESS_HRS varchar (10), BU_TYPE varchar (1), DOCUMENTS_ON_FILE varchar (40), ELEVATOR varchar (1), EQUIP_LIST_AVAIL varchar (1), FACILITIES varchar (20), FORM varchar (10), GROSS_ANNUAL_EXP numeric(12, 0), GROSS_ANNUAL_INCOME numeric(12, 0), HANDICAP_ACCESS varchar (1), INVENTORY_AVAIL varchar (1), LOCATION varchar (30), NET_OPERATING_INC numeric(12, 0), NO_OF_DRIVING_DOORS tinyint, NO_OF_LOADING_DOCKS tinyint, NO_OF_RESTROOMS tinyint, OWNER_TRAINING varchar (1), PARKING_SPCS smallint, REAL_ESTATE_INCLD varchar (1), REAL_ESTATE_LN varchar (, REASON_FOR_SELL varchar (20), SPECIAL_FINANCING varchar (1), SPECIAL_LICENSES varchar (10), SYSTEM varchar (20), TENANT_EXPENSES varchar (30), TERMS_FEATURE varchar (20), TRAFFIC_COUNT int, UTILITIES varchar (30), ZONE_DESCRIPTION varchar (10) ) CREATE TABLE CC ( LIST_NO int, AMENITIES varchar (21), APPLIANCES varchar (29), ASSC_FEE_INCLUDES varchar (65), ASSC_POOL varchar (1), ASSOC_SECURITY varchar (13), BEACH_DESCRIPTION varchar (13), BEACH_MILES_TO varchar (9), BEACH_OWNERSHIP varchar (9), BED2_DIMEN varchar (5), BED2_DSCRP varchar (39), BED2_LEVEL varchar (1), BED3_DIMEN varchar (5), BED3_DSCRP varchar (39), BED3_LEVEL varchar (1), BED4_DIMEN varchar (5), BED4_DSCRP varchar (39), BED4_LEVEL varchar (1), BTH1_DIMEN varchar (5), BTH1_DSCRP varchar (39), BTH1_LEVEL varchar (1), BTH2_DIMEN varchar (5), BTH2_DSCRP varchar (39), BTH2_LEVEL varchar (1), CC_TYPE varchar (1), COMPLEX_COMPLETE varchar (1), CONDOMINIUM_NAME varchar (40), CONDO_ASSOCIATION varchar (1), CONSTRUCTION varchar (15), COOLING varchar (23), COOLING_ZONES tinyint, DIN_DIMEN varchar (5), DIN_DSCRP varchar (39), DIN_LEVEL varchar (1), DOCUMENTS_ON_FILE varchar (17), ELECTRIC_FEATURE varchar (17), ENERGY_FEATURES varchar (17), EXTERIOR varchar (25), EXTERIOR_UNIT_FEATURES varchar (53), FAM_DIMEN varchar (5), FAM_DSCRP varchar (39), FAM_LEVEL varchar (1), FLOORING varchar (19), GARAGE_PARKING varchar (25), GARAGE_SPACES tinyint, HEATING varchar (41), HEAT_ZONES tinyint, HOA_FEE numeric(12, 2), HOT_WATER varchar (19), INSULATION_FEATURE varchar (19), INTERIOR_FEATURES varchar (19), KIT_DIMEN varchar (5), KIT_DSCRP varchar (39), KIT_LEVEL varchar (1), LAUNDRY_DIMEN varchar (5), LAUNDRY_DSCRP varchar (39), LAUNDRY_LEVEL varchar (1), LEAD_PAINT varchar (7), LIV_DIMEN varchar (5), LIV_DSCRP varchar (39), LIV_LEVEL varchar (1), MANAGEMENT varchar (15), MASTER_BOOK varchar (6), MASTER_PAGE varchar (4), MBR_DIMEN varchar (5), MBR_DSCRP varchar (39), MBR_LEVEL varchar (1), NO_LIVING_LEVELS smallint, NO_UNITS smallint, NO_UNITS_OWNER_OCC smallint, OPTIONAL_FEE numeric(12, 2), OPT_FEE_INCLUDES varchar (63), OTH1_DIMEN varchar (5), OTH1_DSCRP varchar (39), OTH1_LEVEL varchar (1), OTH1_ROOM_NAME varchar (3), OTH1_ROOM_NAME_LONG varchar (13), OTH2_DIMEN varchar (5), OTH2_DSCRP varchar (39), OTH2_LEVEL varchar (1), OTH2_ROOM_NAME varchar (3), OTH2_ROOM_NAME_LONG varchar (13), OTH3_DIMEN varchar (5), OTH3_DSCRP varchar (39), OTH3_LEVEL varchar (1), OTH3_ROOM_NAME_LONG varchar (3), OTH3_ROOM_NAME varchar (13), OTH4_DIMEN varchar (5), OTH4_DSCRP varchar (39), OTH4_LEVEL varchar (1), OTH4_ROOM_NAME varchar (3), OTH4_ROOM_NAME_LONG varchar (13), OTH5_DIMEN varchar (5), OTH5_DSCRP varchar (39), OTH5_LEVEL varchar (1), OTH5_ROOM_NAME varchar (3), OTH5_ROOM_NAME_LONG varchar (13), OTH6_DIMEN varchar (5), OTH6_DSCRP varchar (39), OTH6_LEVEL varchar (1), OTH6_ROOM_NAME varchar (3), OTH6_ROOM_NAME_LONG varchar (13), OWNER_OCC_SOURCE varchar (11), PARKING_FEATURE varchar (15), PARKING_SPACES smallint, POOL_DESCRIPTION varchar (9), RESTRICTIONS varchar (9), ROOF_MATERIAL varchar (17), SEWAGE_DISTRICT varchar (5), SEWER_AND_WATER varchar (17), STYLE varchar (39), TERMS_FEATURE varchar (15), UFFI varchar (1), UNIT_BUILDING varchar (11), UNIT_LEVEL tinyint, UNIT_PLACEMENT varchar (16), UTILITY_CONNECTIONS varchar (17), WARRANTY varchar (1), WATERFRONT varchar (25), YEAR_CONVERTED smallint, YEAR_ROUND varchar (1), BED5_DIMEN varchar (5), BED5_DSCRP varchar (39), BED5_LEVEL varchar (1), BTH3_DIMEN varchar (5), BTH3_DSCRP varchar (39), BTH3_LEVEL varchar (1), PETS_ALLOWED varchar (1) ) CREATE TABLE CI ( LIST_NO int, ON_FILE_21E varchar (1), ASSC_FEE_INCLUDES varchar (65), ASSESSED_VALUE_BLDG numeric(12, 0), ASSESSED_VALUE_LAND numeric(12, 0), CEILING_HEIGHT tinyint, CI_TYPE varchar (1), CONDO_ASSOCIATION varchar (1), CONSTRUCTION varchar (15), DEPTH int, DIVIDABLE varchar (1), EASEMENTS varchar (1), ELEVATOR varchar (1), EXCHANGE varchar (1), EXPANDABLE varchar (1), GROSS_ANNUAL_EXP numeric(12, 0), GROSS_ANNUAL_INCOME numeric(12, 0), HANDICAP_ACCESS varchar (1), HOA_FEE numeric(12, 2), LEASE varchar (1), LEASE_PRICE_INCLUDES varchar (9), LEASE_TYPE varchar (3), LIEN_AND_ENCUMBENT varchar (1), LOCATION varchar (27), MAF_BLDG_SF numeric(12, 0), MAU_UNITS tinyint, MILL_RATE numeric(12, 2), NET_OPERATING_INC numeric(12, 0), NO_BUILDINGS smallint, NO_OF_DRIVING_DOORS tinyint, NO_OF_LOADING_DOCKS tinyint, NO_OF_RESTROOMS tinyint, NO_STORIES smallint, NO_UNITS smallint, OFF_BLDG_SF numeric(12, 0), OFU_UNITS tinyint, PARKING_FEATURE varchar (15), PARKING_SPACES smallint, PLAT_PLAN varchar (1), RAILROAD_SIDING varchar (1), REF_BLDG_SF numeric(12, 0), REU_UNITS smallint, ROOF_MATERIAL varchar (11), RSF_BLDG_SF numeric(12, 0), RSU_UNITS smallint, SITE_CONDITION varchar (13), SPACE_AVAILABLE varchar (5), SPECIAL_FINANCING varchar (1), SPRINKLERS varchar (1), SUBLET varchar (1), SUB_DIVIDABLE varchar (1), SURVEY varchar (1), TOTAL_ASSESSED_VALUE numeric(12, 0), TOTAL_BLDG_SF numeric(12, 0), TOTAL_UNITS smallint, TRAFFIC_COUNT int, UNDRGRND_TANK varchar (1), UTILITIES varchar (25), WAF_BLDG_SF numeric(12, 0), WAU_UNITS tinyint, ZONE_DESCRIPTION varchar (5) ) CREATE TABLE Counties ( Short varchar (4), Long varchar (50) ) CREATE TABLE Field_Reference ( id int, sf bit, cc bit, mf bit, ld bit, ci bit, bu bit, rn bit, Field varchar (32), Short varchar (3), Medium varchar (5), Long varchar (50), mh bit ) CREATE TABLE HISTORY_BULK( KeyId int, Change_Date smalldatetime, LIST_NO int, Old_Value varchar(64), New_Value varchar(64), Who varchar(12), Field varchar(50), Update_Date smalldatetime, Active_Flag bit ) CREATE TABLE IDX_Optout ( Office ID nvarchar (6), Opt_Out_Date smalldatetime, msrepl_tran_version uniqueidentifier ) CREATE TABLE IDX_Optout_Listings ( LIST_NO char (, msrepl_tran_version uniqueidentifier ) CREATE TABLE LD ( LIST_NO int, AMENITIES varchar (21), BEACH_DESCRIPTION varchar (13), BEACH_MILES_TO varchar (9), BEACH_OWNERSHIP varchar (9), CABLE_AVAILABLE varchar (1), CULTIVATION_ACRES numeric(12, 2), DEQE varchar (10), DOCUMENTS_ON_FILE varchar (42), ELECTRIC_FEATURE varchar (11), GAS varchar (9), HOA_FEE numeric(12, 2), HOME_OWN_ASSOCIATION varchar (1), IMPROVEMENTS varchar (20), LAND_DESC varchar (30), LD_TYPE varchar (1), NO_LOTS smallint, PASTURE_ACRES numeric(12, 2), PERC_TEST varchar (1), PERC_TEST_DATE smalldatetime, REQD_OWN_ASSOCIATION varchar (1), ROAD_TYPE varchar (32), SEWAGE_DISTRICT varchar (5), SEWER varchar (11), TIMBER_ACRES numeric(12, 2), WATER varchar (11), WATERFRONT varchar (26), ZONE_USAGE varchar ( ) CREATE TABLE MF ( LIST_NO int, AMENITIES varchar (21), APOD_AVAILABLE varchar (1), APP_COMMON varchar (29), APP_DSCRP_1 varchar (29), APP_DSCRP_2 varchar (29), APP_DSCRP_3 varchar (29), APP_DSCRP_4 varchar (29), BASEMENT_FEATURE varchar (27), BEACH_DESCRIPTION varchar (13), BEACH_MILES_TO varchar (9), BEACH_OWNERSHIP varchar (9), BEDRMS_1 tinyint, BEDRMS_2 tinyint, BEDRMS_3 tinyint, BEDRMS_4 tinyint, COLOR varchar (10), COL_COMMON varchar (23), COL_DSCRP_1 varchar (23), COL_DSCRP_2 varchar (23), COL_DSCRP_3 varchar (23), COL_DSCRP_4 varchar (23), CONSTRUCTION varchar (15), COOLING_UNITS tinyint, COOLING_ZONES tinyint, ELEC smallint, ELECTRIC_FEATURE varchar (23), ENERGY_FEATURES varchar (19), EXPENSES_SOURCE varchar (17), EXPENSES_YEAR_END varchar (5), EXTERIOR varchar (27), EXTERIOR_FEATURES varchar (55), FLOORING varchar (19), FLRS_1 tinyint, FLRS_2 tinyint, FLRS_3 tinyint, FLRS_4 tinyint, FOUNDATION varchar (13), FOUNDATION_SIZE varchar (15), FRPLCS_1 tinyint, FRPLCS_2 tinyint, FRPLCS_3 tinyint, FRPLCS_4 tinyint, F_BTHS_1 tinyint, F_BTHS_2 tinyint, F_BTHS_3 tinyint, F_BTHS_4 tinyint, GARAGE_SPACES tinyint, GOI int, GRE int, GSE smallint, HEAT_UNITS tinyint, HEAT_ZONES tinyint, HEA_COMMON varchar (41), HEA_DSCRP_1 varchar (41), HEA_DSCRP_2 varchar (41), HEA_DSCRP_3 varchar (41), HEA_DSCRP_4 varchar (41), HOT_WATER varchar (21), HTE smallint, H_BTHS_1 tinyint, H_BTHS_2 tinyint, H_BTHS_3 tinyint, H_BTHS_4 tinyint, IFE_COMMON varchar (31), IFE_DSCRP_1 varchar (31), IFE_DSCRP_2 varchar (31), IFE_DSCRP_3 varchar (31), IFE_DSCRP_4 varchar (31), INSC smallint, LEAD_PAINT varchar (7), LEASE_1 varchar (1), LEASE_2 varchar (1), LEASE_3 varchar (1), LEASE_4 varchar (1), LEVELS tinyint, LEVELS_1 tinyint, LEVELS_2 tinyint, LEVELS_3 tinyint, LEVELS_4 tinyint, LOT_DESCRIPTION varchar (23), MF_TYPE varchar (1), MGF smallint, MSE smallint, NOI int, NO_UNITS smallint, PARKING_FEATURE varchar (11), PARKING_SPACES smallint, RENT1 smallint, RENT2 smallint, RENT3 smallint, RENT4 smallint, RFS smallint, RME smallint, RMS_1 tinyint, RMS_2 tinyint, RMS_3 tinyint, RMS_4 tinyint, RMS_COMMON varchar (11), RMS_DSCRP_1 varchar (11), RMS_DSCRP_2 varchar (11), RMS_DSCRP_3 varchar (11), RMS_DSCRP_4 varchar (11), RNT_DSCRP_1 varchar (13), RNT_DSCRP_2 varchar (13), RNT_DSCRP_3 varchar (13), RNT_DSCRP_4 varchar (13), ROAD_TYPE varchar (19), ROOF_MATERIAL varchar (17), SEW smallint, SEWAGE_DISTRICT varchar (5), SEWER_AND_WATER varchar (17), TERMS_FEATURE varchar (13), TOTAL_BRS tinyint, TOTAL_FBH tinyint, TOTAL_FLRS tinyint, TOTAL_FRPLCS tinyint, TOTAL_HBH tinyint, TOTAL_LEVELS tinyint, TOTAL_RENT smallint, TOTAL_RMS tinyint, TOTAL_ROOMS tinyint, UFFI varchar (1), UTILITY_CONNECTIONS varchar (17), WARRANTY varchar (1), WATERFRONT varchar (25), WSE smallint, YEAR_ROUND varchar (1) ) CREATE TABLE Member ( Member_Number int, Last_Name varchar(30), First_Name varchar(12), Middle_Initial varchar(1), Generation varchar(3), Full_Name varchar(34), Nickname varchar(12), Office_Number int, Title varchar(4), Salutation varchar(24), Designations varchar(1), Care_of varchar(30), Street_Address varchar(30), City varchar(21), State varchar(2), Home_Zip_Code varchar(5), Home_Zip_Plus_4 varchar(4), MLS_ID varchar(12), Home_Phone_Area varchar(3), Home_Phone_Number varchar(7), Preferred_Mail varchar(1), Last_Modify_Date char(, Office_ID varchar(12), Personal_Fax_Area varchar(3), Personal_Fax_Phone varchar(7), ) CREATE TABLE Member_Association ( Member_Number int, Association_ID varchar (4), Member_Type_Code varchar (3), Status varchar (1), Status_Date char (, Last_Modify_Date char (, Online_Status varchar (1) ) CREATE TABLE MH ( LIST_NO int, AMENITIES varchar (22), APPLIANCES varchar (29), BASEMENT_FEATURE varchar (27), BEACH_DESCRIPTION varchar (13), BEACH_MILES_TO varchar (9), BEACH_OWNERSHIP varchar (9), BED2_DIMEN varchar (5), BED2_DSCRP varchar (39), BED2_LEVEL varchar (1), BED3_DIMEN varchar (5), BED3_DSCRP varchar (39), BED3_LEVEL varchar (1), BED4_DIMEN varchar (5), BED4_DSCRP varchar (39), BED4_LEVEL varchar (1), BED5_DIMEN varchar (5), BED5_DSCRP varchar (39), BED5_LEVEL varchar (1), BTH1_DIMEN varchar (5), BTH1_DSCRP varchar (39), BTH1_LEVEL varchar (1), BTH2_DIMEN varchar (5), BTH2_DSCRP varchar (39), BTH2_LEVEL varchar (1), BTH3_DIMEN varchar (5), BTH3_DSCRP varchar (39), BTH3_LEVEL varchar (1), COLOR varchar (10), CONSTRUCTION varchar (15), COOLING varchar (15), COOLING_ZONES tinyint, DIN_DIMEN varchar (5), DIN_DSCRP varchar (39), DIN_LEVEL varchar (1), ELECTRIC_FEATURE varchar (17), ENERGY_FEATURES varchar (17), EXTERIOR varchar (25), EXTERIOR_FEATURES varchar (53), FAM_DIMEN varchar (5), FAM_DSCRP varchar (39), FAM_LEVEL varchar (1), FLOORING varchar (19), FOUNDATION varchar (13), FOUNDATION_SIZE varchar (15), GARAGE_PARKING varchar (25), GARAGE_SPACES tinyint, HEATING varchar (41), HEAT_ZONES tinyint, HOA_FEE numeric(12, 2), HOME_OWN_ASSOCIATION varchar (1), HOT_WATER varchar (21), INSULATION_FEATURE varchar (21), INTERIOR_FEATURES varchar (21), KIT_DIMEN varchar (5), KIT_DSCRP varchar (39), KIT_LEVEL varchar (1), LAUNDRY_DIMEN varchar (5), LAUNDRY_DSCRP varchar (39), LAUNDRY_LEVEL varchar (1), LEAD_PAINT varchar (7), LIV_DIMEN varchar (5), LIV_DSCRP varchar (39), LIV_LEVEL varchar (1), LOT_DESCRIPTION varchar (23), MBR_DIMEN varchar (5), MBR_DSCRP varchar (39), MBR_LEVEL varchar (1), OTH1_DIMEN varchar (5), OTH1_DSCRP varchar (39), OTH1_LEVEL varchar (1), OTH1_ROOM_NAME varchar (13), OTH2_DIMEN varchar (5), OTH2_DSCRP varchar (39), OTH2_LEVEL varchar (1), OTH2_ROOM_NAME varchar (13), OTH3_DIMEN varchar (5), OTH3_DSCRP varchar (39), OTH3_LEVEL varchar (1), OTH3_ROOM_NAME varchar (13), OTH4_DIMEN varchar (5), OTH4_DSCRP varchar (39), OTH4_LEVEL varchar (1), OTH4_ROOM_NAME varchar (13), OTH5_DIMEN varchar (5), OTH5_DSCRP varchar (39), OTH5_LEVEL varchar (1), OTH5_ROOM_NAME varchar (13), OTH6_DIMEN varchar (5), OTH6_DSCRP varchar (39), OTH6_LEVEL varchar (1), OTH6_ROOM_NAME varchar (13), PARKING_FEATURE varchar (9), PARKING_SPACES smallint, REQD_OWN_ASSOCIATION varchar (1), ROAD_TYPE varchar (19), ROOF_MATERIAL varchar (17), SEWAGE_DISTRICT varchar (5), SEWER_AND_WATER varchar (15), STYLE varchar (35), TERMS_FEATURE varchar (13), UFFI varchar (1), UTILITY_CONNECTIONS varchar (17), WARRANTY varchar (1), WATERFRONT varchar (25), YEAR_ROUND varchar (1) ) CREATE TABLE Office ( Office_Number int, Office_Name varchar (30), MLS_Number varchar (12), Street_Care_of varchar (30), Street_Address varchar (30), Street_City varchar (21), Street_State varchar (2), Street_Zip_Code varchar (5), Street_Zip_Plus_4 varchar (4), Street_Country_Code varchar (2), Mail_Care_of varchar (30), Mail_Address varchar (30), Mail_City varchar (21), Mail_State varchar (2), Mail_Zip_Code varchar (5), Mail_Zip_Plus_4 varchar (4), Mail_Country_Code varchar (2), Office_Area_Code varchar (3), Office_Phone varchar (7), Fax_Area_Code varchar (3), Fax_Phone varchar (7), Responsible_Member int, Office_Contact_Member int, Main_Office_Number int, Last_Modify_Date char (, Long_Name varchar (100) ) CREATE TABLE Office_Association ( Association_ID varchar (4), Office_Number int, Office_Type varchar (4), Status varchar (1), Status_Date char (, Last_Modify_Date char (, Online_Status varchar (1) ) CREATE TABLE Open_Houses ( LIST_NO int, Comments varchar (500), Start_Date smalldatetime, End_Date smalldatetime, Duration int, DateModified smalldatetime ) CREATE TABLE PAll ( LIST_NO int, ACRE numeric(12, 2), ANT_SOLD_DATE smalldatetime, AREA varchar (3), ASSESSMENTS numeric(12, 0), BASEMENT varchar (1), BEACHFRONT_FLAG varchar (1), BLOCK varchar (6), BOOK varchar (6), BUYER_BROKER_COMP varchar (10), CERTIFICATE_NUMBER varchar (10), DIRECTION varchar (100), DISCLOSURE varchar (1), ENTRY_ONLY varchar (1), FIN_CODE tinyint, FIRE_PLACES tinyint, FIRM_RMK1 varchar (100), TEAM_MEMBER varchar (60), FRONTAGE numeric(12, 0), GRADE_SCHOOL varchar (15), HIGH_SCHOOL varchar (15), LISTING_AGREEMENT varchar (19), LIST_AGENT varchar (, LIST_DATE smalldatetime, LIST_DATE_RCVD smalldatetime, LIST_OFFICE varchar (6), LIST_PRICE numeric(12, 2), LOT varchar (6), MAIN_LO varchar (6), MAIN_SO varchar (6), MAP varchar (6), MASTER_BATH varchar (1), MIDDLE_SCHOOL varchar (15), NO_BEDROOMS smallint, NO_FULL_BATHS smallint, NO_HALF_BATHS smallint, NO_ROOMS smallint, OFF_MKT_DATE smalldatetime, ORIG_PRICE numeric(12, 2), OTHER_AGENT_COMP varchar (10), PAGE varchar (4), PARCEL_NUMBER varchar (36), PHOTO_COUNT smallint, PHOTO_DATE smalldatetime, PHOTO_MASK int, PROP_TYPE varchar (2), REMARKS varchar (500), SALE_AGENT varchar (, SALE_OFFICE varchar (6), SALE_PRICE numeric(12, 2), SELLER_DISCOUNT_PTS varchar (10), SELLING_BROKER_COMP varchar (10), SETTLED_DATE smalldatetime, SHOW_INSTRUCTION varchar (100), SOLD_VS_RENT varchar (2), SQUARE_FEET numeric(12, 0), SQUARE_FEET_SOURCE varchar (2), STATUS varchar (3), STATUS_DATE smalldatetime, STREET_NO varchar (10), STREET_NAME varchar (30), SUB_AREA varchar (4), TAX_YEAR varchar (4), TAXES numeric(12, 2), TOWN_NUM smallint, UPDATE_DATE smalldatetime, WATERFRONT_FLAG varchar (1), YEAR_BUILT smallint, YEAR_BUILT_DESCRP varchar (16), YEAR_BUILT_SOURCE varchar (2), ZIP_CODE varchar (5), ZIP_CODE_4 varchar (4), ZONING varchar (10), LISTING_ALERT varchar (1), ALERT_COMMENTS varchar (100), RENT_PRICE decimal(11, 2), NEIGHBORHOOD varchar (100), STREET_NUM int, ADULT_COMMUNITY varchar (1), DISCLOSURES varchar (100), EXCLUSIONS varchar (100), HOW_SHOWN_BB varchar (25), HOW_SHOWN_FB varchar (25), HOW_SHOWN_SB varchar (25), LOT_SIZE numeric(12, 2), SHOWINGS_DEFERRAL_DATE smalldatetime, SQUARE_FEET_OTHER numeric(12, 2), SUB_AGENCY_OFFERED varchar (1), SELLER_CONCESSIONS_AT_CLOSING numeric(12, 2), UNIT_NO varchar (11), MARKET_TIME_BROKER int, MARKET_TIME_PROPERTY int, SQUARE_FEET_INCL_BASE varchar (1), SQUARE_FEET_DISCLOSURES varchar (100), LENDER_OWNED char (1), SHORT_SALE_LENDER_APP_REQD char (1) ) CREATE TABLE RN ( LIST_NO int, AIR_CONDITION varchar (1), AMENITIES varchar (21), APPLIANCES varchar (30), BEACH_MILES_TO varchar (10), CONDO_ASSOCIATION varchar (1), COOP_COMP varchar (10), DEPOSIT_REQD varchar (1), EXTERIOR_FEATURES varchar (53), FOR_SALE varchar (1), HEATING varchar (10), INSURANCE_REQD varchar (1), INTERIOR_BLDG_FEAT varchar (15), LAST_MON_REQD varchar (1), LEAD_PAINT varchar (10), LEASE_TERMS varchar (6), PARKING_SPACES smallint, PETS_ALLOWED varchar (1), POSSESSION varchar (11), REFERENCES_REQD varchar (1), RENTAL_TERMS varchar (10), RENT_FEE_INCLUDES varchar (41), RN_TYPE varchar (1), SEC_DEPOSIT numeric(12, 0), TERM_OF_RENTAL varchar (6), UFFI varchar (1), UNIT_BUILDING varchar (11), UNIT_LEVEL tinyint, YEAR_ROUND varchar (1), FIRST_MON_REQD varchar (1) ) CREATE TABLE Reference_Updates ( table_name varchar (50), Updated smalldatetime ) CREATE TABLE SF ( LIST_NO int, AMENITIES varchar (22), APPLIANCES varchar (29), BASEMENT_FEATURE varchar (27), BEACH_DESCRIPTION varchar (13), BEACH_MILES_TO varchar (9), BEACH_OWNERSHIP varchar (9), BED2_DIMEN varchar (5), BED2_DSCRP varchar (39), BED2_LEVEL varchar (1), BED3_DIMEN varchar (5), BED3_DSCRP varchar (39), BED3_LEVEL varchar (1), BED4_DIMEN varchar (5), BED4_DSCRP varchar (39), BED4_LEVEL varchar (1), BED5_DIMEN varchar (5), BED5_DSCRP varchar (39), BED5_LEVEL varchar (1), BTH1_DIMEN varchar (5), BTH1_DSCRP varchar (39), BTH1_LEVEL varchar (1), BTH2_DIMEN varchar (5), BTH2_DSCRP varchar (39), BTH2_LEVEL varchar (1), BTH3_DIMEN varchar (5), BTH3_DSCRP varchar (39), BTH3_LEVEL varchar (1), COLOR varchar (10), CONSTRUCTION varchar (15), COOLING varchar (15), COOLING_ZONES tinyint, DIN_DIMEN varchar (5), DIN_DSCRP varchar (39), DIN_LEVEL varchar (1), ELECTRIC_FEATURE varchar (17), ENERGY_FEATURES varchar (17), EXTERIOR varchar (25), EXTERIOR_FEATURES varchar (53), FAM_DIMEN varchar (5), FAM_DSCRP varchar (39), FAM_LEVEL varchar (1), FLOORING varchar (19), FOUNDATION varchar (13), FOUNDATION_SIZE varchar (15), GARAGE_PARKING varchar (25), GARAGE_SPACES tinyint, HEATING varchar (41), HEAT_ZONES tinyint, HOA_FEE numeric(12, 2), HOME_OWN_ASSOCIATION varchar (1), HOT_WATER varchar (21), INSULATION_FEATURE varchar (21), INTERIOR_FEATURES varchar (21), KIT_DIMEN varchar (5), KIT_DSCRP varchar (39), KIT_LEVEL varchar (1), LAUNDRY_DIMEN varchar (5), LAUNDRY_DSCRP varchar (39), LAUNDRY_LEVEL varchar (1), LEAD_PAINT varchar (7), LIV_DIMEN varchar (5), LIV_DSCRP varchar (39), LIV_LEVEL varchar (1), LOT_DESCRIPTION varchar (23), MBR_DIMEN varchar (5), MBR_DSCRP varchar (39), MBR_LEVEL varchar (1), OTH1_DIMEN varchar (5), OTH1_DSCRP varchar (39), OTH1_LEVEL varchar (1), OTH1_ROOM_NAME varchar (13), OTH2_DIMEN varchar (5), OTH2_DSCRP varchar (39), OTH2_LEVEL varchar (1), OTH2_ROOM_NAME varchar (13), OTH3_DIMEN varchar (5), OTH3_DSCRP varchar (39), OTH3_LEVEL varchar (1), OTH3_ROOM_NAME varchar (13), OTH4_DIMEN varchar (5), OTH4_DSCRP varchar (39), OTH4_LEVEL varchar (1), OTH4_ROOM_NAME varchar (13), OTH5_DIMEN varchar (5), OTH5_DSCRP varchar (39), OTH5_LEVEL varchar (1), OTH5_ROOM_NAME varchar (13), OTH6_DIMEN varchar (5), OTH6_DSCRP varchar (39), OTH6_LEVEL varchar (1), OTH6_ROOM_NAME varchar (13), PARKING_FEATURE varchar (9), PARKING_SPACES smallint, REQD_OWN_ASSOCIATION varchar (1), ROAD_TYPE varchar (19), ROOF_MATERIAL varchar (17), SEWAGE_DISTRICT varchar (5), SEWER_AND_WATER varchar (15), SF_TYPE varchar (1), STYLE varchar (39), TERMS_FEATURE varchar (13), UFFI varchar (1), UTILITY_CONNECTIONS varchar (17), WARRANTY varchar (1), WATERFRONT varchar (25), YEAR_ROUND varchar (1) ) CREATE TABLE Status ( Short varchar (4), Long varchar (50), STAT_SORT int, CMA_Sort int ) CREATE TABLE Towns ( Number smallint, Long varchar (64), Board varchar (4), County varchar (4), Short varchar (4), TaxNum smallint, State char (2), Region tinyint ) CREATE TABLE Virtual_Tour_Reference ( TOUR_TYPE smallint, ICON varchar (255), TOOLTIP varchar (255) ) CREATE TABLE Virtual_Tours ( id int, LIST_NO int, TOUR_URL varchar (255), TOUR_TYPE smallint, UPDATE_DATE smalldatetime ) CREATE TABLE PAll_Coords ( List_no int, Lat decimal(11, 6), Long decimal(11, 6), Coord_Source varchar(4), Prop_Id int ) CREATE TABLE Teams ( id int, AgentId varchar (, TeamId varchar ( ) Error #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Long varchar (50), Town smallint, Mappable bit ) CREATE TABLE BU ( LIS' at line 3 Any advice would be appreciated.

It's all explained in the title. What is your personal favor Project Management System, and why?

I am kind of confused, my post here got deleted. I am not sure if it was because someone deleted it for some reason, or if it was because PHPFreaks was done earlier, perhaps some data was lost. Anyway, to repeat what I had put into my original post. There is an easy way to do what you are wanting. I did some digging on Google after reading your post here, and I found this: http://www.webshotspro.com/ You can go here and use Curl to get the screenshots. Just enter the URL, and then get the image. The official way to do it however, would be to use their API. Just sign up for an account, and you can utilize their API to do what you are wanting. Alternatively, here are some other options as well: http://mashable.com/2007/08/24/web-screenshots/

I agree, it does not have to be that involved to be very secure. If you want to get a little more safe, play around with something like this: http://www.krio.me/cleaning-php-input-variables-before-mysql-insertion/

Posting your code will help us to assist you better. If your somewhat new to PHP or having issues with this specific area, I recommend using some form of PHPMailer class that already works, and send your attachments that way. http://psoug.org/snippet/Email-w-attachments-class_401.htm http://w100w.com/english/php/email_systems/web-based_email/ http://www.geekology.co.za/blog/2009/06/sending-emails-with-attachments-using-php-mail-function/ http://www.devshed.com/c/a/PHP/Handling-Attachments-in-MIME-Email-with-PHP/

<script type="text/javascript"> function data_calculator() { var data = $('#data').val(); var data_one_conversion_type = $('#data_one_conversion_type').val(); var data_two_conversion_type = $('#data_two_conversion_type').val(); var data_storage_type = $('#data_storage_type').val(); var value_modifier = 0; if (data_storage_type == 'Processor or Virtual Storage') { value_modifier = 1024; }else if (data_storage_type == 'Disk Storage') { value_modifier = 1000; } var calculation = ''; switch(data_one_conversion_type) { case 'bits': switch(data_two_conversion_type) { case 'bits': calculation = data; break; case 'bytes': calculation = data / 8; calculation = bytesToSize(calculation, 'byte') break; case 'kb': calculation = data / 8; calculation = bytesToSize(calculation, 'kb'); break; case 'mb': calculation = data / 8; calculation = bytesToSize(calculation, 'mb'); break; case 'gb': calculation = data / 8; calculation = bytesToSize(calculation, 'gb'); break; case 'tb': calculation = data / 8; calculation = bytesToSize(calculation, 'tb'); break; case 'pb': calculation = data / 8; calculation = bytesToSize(calculation, 'pb'); break; case 'eb': calculation = data / 8; calculation = bytesToSize(calculation, 'eb'); break; case 'zb': calculation = data / 8; calculation = bytesToSize(calculation, 'zb'); break; case 'yb': calculation = data / 8; calculation = bytesToSize(calculation, 'yb'); break; case 'bb': calculation = data / 8; calculation = bytesToSize(calculation, 'bb'); break; } break; } $('#data_value').val(data + " " + data_one_conversion_type + ' = ' + calculation + " " + data_two_conversion_type); } function bytesToSize(bytes, data_format) { // Base values var kilobyte = 1024; var megabyte = kilobyte * 1024; var gigabyte = megabyte * 1024; var terabyte = gigabyte * 1024; var petabyte = terabyte * 1024; var exabyte = petabyte * 1024; var zettabyte = exabyte * 1024; var yottabyte = zettabyte * 1024; var brontobyte = yottabyte * 1024; if (data_format == 'byte') { return bytes; }else if (data_format == 'kb') { return bytes / kilobyte; }else if (data_format == 'mb') { return bytes / megabyte; }else if (data_format == 'gb') { return bytes / gigabyte; }else if (data_format == 'tb') { return bytes / terabyte; }else if (data_format == 'pb') { return bytes / petabyte; }else if (data_format == 'eb') { return bytes / exabyte; }else if (data_format == 'zb') { return bytes / zettabyte; }else if (data_format == 'yb') { return bytes / yottabyte; }else if (data_format == 'bb') { return bytes / brontobyte; } } </script> <p>This form allows you to convert one data amount, to another.</p> <form name="data_converter" id="data_converter" class="standard" method="post" action="Javascript: void();" onsubmit="data_calculator();"> <label for="data_storage_type">Data Storage Type:</label> <select name="data_storage_type" id="data_storage_type"> <option value="Processor or Virtual Storage">Processor or Virtual Storage (1024)</option> <option value="Disk Storage">Disk Storage (1000)</option> </select><br /> <label for="data">Data Amount:</label> <input name="data" id="data" type="text" /><br /> <label for="data_one_conversion_type">Conversion Type:</label> <select name="data_one_conversion_type" id="data_one_conversion_type"> <option value="bits">Bits</option> <option value="bytes">Bytes</option> <option value="kb">Kilobytes</option> <option value="mb">Megabytes</option> <option value="gb">Gigabytes</option> <option value="tb">Terabytes</option> <option value="pb">Petabytes</option> <option value="eb">Exabytes</option> <option value="zb">Zettabytes</option> <option value="yb">Yottabytes</option> <option value="bb">Brontobytes</option> </select><br /> <label for="data_two_conversion_type">Conversion Type:</label> <select name="data_two_conversion_type" id="data_two_conversion_type"> <option value="bits">Bits</option> <option value="bytes">Bytes</option> <option value="kb">Kilobytes</option> <option value="mb">Megabytes</option> <option value="gb">Gigabytes</option> <option value="tb">Terabytes</option> <option value="pb">Petabytes</option> <option value="eb">Exabytes</option> <option value="zb">Zettabytes</option> <option value="yb">Yottabytes</option> <option value="bb">Brontobytes</option> </select><br /> <label for="data_value">Data Value</label> <input name="data_value" id="data_value" type="text" /> <input name="submit" id="submit" type="submit" value="Convert" /> </form> Very simply. I want to build a converter. I want this converter to handle all data formats. I can't seem to get my calculations the same as what I am finding online (or on Google). I have tried to set this up in 10-15 different ways, but none of them are working. I have tried using Math.pow, and a variety of other attempts. I have tried handling the calculation in a variety of ways. I have not built out the other conversions because I am having trouble even on the bits. Right now I am trying to get even semi correct results before I working on taking into account the two data format types. For example.... You can see the live results of the code listed above here: http://www.onlinewasteland.com/index.php/tools/extremeconverter Any advice is appreciated.