SitePoint Sponsor

User Tag List

Results 1 to 9 of 9
  1. #1
    SitePoint Addict tina88's Avatar
    Join Date
    Jan 2007
    Location
    UK
    Posts
    270
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Select by Country, Region and City

    Hiya everyone,

    I am building a form that allows the user to select a Country, Region and City from 3 select boxes, each one delimited by their previous choice. What I want to know is if there is already a database set up with all the countries, regions and cities that I can use as it would take ages to enter them all.

    Also, I need one for car manufacturers and car models if possible. I am guessing these must be available from somewhere, but I can't seem to find them.

    Thanks

  2. #2
    SitePoint Addict tina88's Avatar
    Join Date
    Jan 2007
    Location
    UK
    Posts
    270
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Update

    I have just found a useful piece of software from http://www.countrydatabase.dk/ which has countries, regions and cities so this part of the problem is solved.

    I still need a database for car makes and models which I don't think exists

    Please help

    Thanxs

  3. #3
    dooby dooby doo silver trophybronze trophy
    spikeZ's Avatar
    Join Date
    Aug 2004
    Location
    Manchester UK
    Posts
    13,804
    Mentioned
    157 Post(s)
    Tagged
    3 Thread(s)
    Morning Tina,

    If you go to Autotrader.co.uk and view their source, you can view the javascript they use and also how the effect the onChange for the selections.

    The script is located: http://autotrader.co.uk/CARS/common/_make_model.js

    Have a play with that.
    Mike Swiffin - Community Team Advisor
    Only a woman can read between the lines of a one word answer.....

  4. #4
    SitePoint Addict tina88's Avatar
    Join Date
    Jan 2007
    Location
    UK
    Posts
    270
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hiya, I am not too concerned about how to change the select boxes, I have that code already. What I need is a database or even just a complete list of all Car Makes and Models, so I can populate the select boxes. Is there anything like this available?

    Thanx

  5. #5
    dooby dooby doo silver trophybronze trophy
    spikeZ's Avatar
    Join Date
    Aug 2004
    Location
    Manchester UK
    Posts
    13,804
    Mentioned
    157 Post(s)
    Tagged
    3 Thread(s)
    What I meant was to take that list and reconstitute it into database!

    It has 2 arrays: make, model which can be manipulated into creating an insert query which when run would populate the database with the array values.

    Setup your database table:

    3 fields
    id (auto increment)
    make
    model

    Run the following script in a page and look at the output, then uncomment the query line!

    PHP Code:
    <?php
    //
    // Autogenerated on Thu Aug 09 10:40:44 BST 2007
    // V2
    // 
    $model =  Array(); 
    $model[0] =  Array('MODEL','ANY MODEL');
    $model[1] =  Array('MODEL','ANY MODEL');
    $model[2] =  Array('ANY','ACE','COBRA');
    $model[3] =  Array('ANY','500','500.4','500.5','A751');
    $model[4] =  Array('ANY','145','146','147','155','156','159','164','166','33','ALFASUD','BRERA','GT','GTV','MONTREAL','RZ','SPIDER','SPORTWAGON','SZ');
    $model[5] =  Array('ANY','A10','ECOSSE');
    $model[6] =  Array('ANY','ROCSTA');
    $model[7] =  Array('ANY','DB4','DB6','DB7','DB9','DBS','LAGONDA','V8','VANQUISH','VANTAGE','VIRAGE','VOLANTE');
    $model[8] =  Array('ANY','SPEEDSTER');
    $model[9] =  Array('ANY','100','100 AVANT','80','90','A2','A3','A4','A4 AVANT','A4 CABRIOLET','A5','A6','A6 AVANT','A8','ALLROAD','AVANT','CABRIOLET','CONVERTIBLE','COUPE','Q7','QUATTRO','R8','RS2','RS4','RS4 AVANT','RS6','S2','S3','S4','S4 AVANT','S5','S6','S6 AVANT','S8','TT','V8');
    $model[10] =  Array('ANY','1100','1300','A55','ALLEGRO','HEALEY','MAESTRO','METRO','MINI','MONTEGO');
    $model[11] =  Array('ANY','15HP');
    $model[12] =  Array('ANY','ARNAGE','AZURE','BROOKLANDS','CONTINENTAL','EIGHT','MKVI','MULSANNE','R-TYPE','SERIES III','T SERIES','TURBO R');
    $model[13] =  Array('ANY','SC');
    $model[14] =  Array('ANY','1 SERIES','2002','3 SERIES','5 SERIES','6 SERIES','7 SERIES','8 SERIES','ALPINA','M COUPE','M ROADSTER','M1','M3','M5','M6','X3','X5','Z1','Z3','Z4','Z8');
    $model[15] =  Array('ANY','408','FIGHTER');
    $model[16] =  Array('ANY','EB 110','VEYRON');
    $model[17] =  Array('ANY','ELECTRA','PARK AVENUE','SKYLARK');
    $model[18] =  Array('ANY','BLS','CTS','ELDORADO','ESCALADE','SEVILLE','SRX','STS','XLR');
    $model[19] =  Array('ANY','21','SUPER SEVEN','SUPER SPRINT');
    $model[20] =  Array('ANY','ASTRO','AVALANCHE','BLAZER','CAMARO','CAPRICE','CAPTIVA','COLORADO','CORVETTE','GMC','KALOS','LACETTI','LUMINA','MATIZ','MONTE CARLO','S10','SILVERADO','SSR','SUBURBAN','TACUMA','TAHOE');
    $model[21] =  Array('ANY','300C','300M','CHEROKEE','CROSSFIRE','GRAND CHEROKEE','GRAND VOYAGER','JEEP','LE BARON','NEON','PROWLER','PT CRUISER','SEBRING','VIPER','VOYAGER');
    $model[22] =  Array('ANY','2 CV','AMI','AX','BERLINGO','BX','C-CROSSER','C1','C2','C3','C4','C4 GRAND PICASSO','C4 PICASSO','C5','C6','C8','CX','DS','SAXO','SYNERGIE','XANTIA','XM','XSARA','XSARA PICASSO','ZX');
    $model[23] =  Array('ANY','DORCHESTER','GROSVENOR','LIMOUSINE','MINSTER');
    $model[24] =  Array('ANY','C6','Z06');
    $model[25] =  Array('ANY','ESPERO','KALOS','KORANDO','LACETTI','LANOS','LEGANZA','MATIZ','MUSSO','NEXIA','NUBIRA','TACUMA');
    $model[26] =  Array('ANY','CHARADE','COPEN','CUORE','FOURTRAK','GRAND MOVE','HIJET','MATERIA','MIRA','MOVE','SIRION','SPORTRAK','TERIOS','YRV');
    $model[27] =  Array('ANY','CONQUEST','DOUBLE SIX','DS420','LIMOUSINE','SALOON','SERIES III','SIX','SOVEREIGN','SUPER V8','V8','XJ SERIES','XJ12');
    $model[28] =  Array('ANY','240Z','280Z','DE LUXE','SUNNY');
    $model[29] =  Array('ANY','RUSH','TOJEIRO');
    $model[30] =  Array('ANY','MANGUSTA','PANTERA');
    $model[31] =  Array('ANY','AVENGER','CALIBER','CARAVAN','CHARGER','CORONET','CUSTOM ROYALE','DAKOTA','DART','DURANGO','MAGNUM','NITRO','RAM','SRT-10','STEALTH','VIPER');
    $model[32] =  Array('ANY','SERIES III');
    $model[33] =  Array('ANY','308','328','330','348','360','365','400','412','456','512','550','575M','599','612','DAYTONA','DINO','ENZO','F355','F40','F430','F50','F512','MONDIAL','TESTAROSSA');
    $model[34] =  Array('ANY','124','126','500','BARCHETTA','BRAVA','BRAVO','CINQUECENTO','COUPE','CROMA','DOBLO','GRANDE PUNTO','IDEA','MAREA','MULTIPLA','PANDA','PUNTO','SCUDO PANORAMA','SEDICI','SEICENTO','STILO','TEMPRA','TIPO','ULYSSE','UNO','X19');
    $model[35] =  Array('ANY','ANGLIA','C-MAX','CAPRI','CORTINA','COUGAR','CROWN VICTORIA','ECONOLINE','ESCORT','EXCURSION','EXPEDITION','EXPLORER','F150','F250','F350','FALCON','FIESTA','FOCUS','FOCUS C-MAX','FUSION','GALAXY','GRANADA','GT','KA','MAVERICK','MODEL T','MONDEO','MUSTANG','ORION','PREFECT','PROBE','PUMA','RANGER','RS200','S-MAX','SAPPHIRE','SCORPIO','SIERRA','STREETKA','THUNDERBIRD','WINDSTAR','ZODIAC');
    $model[36] =  Array('ANY','G SERIES');
    $model[37] =  Array('ANY','SAVANA','SIERRA','YUKON');
    $model[38] =  Array('ANY','IMP','MINX');
    $model[39] =  Array('ANY','HSV');
    $model[40] =  Array('ANY','ACCORD','AERODECK','BEAT','CIVIC','CONCERTO','CR-V','CR-X','ELEMENT','FR-V','HR-V','INSIGHT','INTEGRA','JAZZ','LEGEND','LOGO','NSX','ODYSSEY','PRELUDE','S-MX','S2000','SHUTTLE','STEPWAGON','STREAM');
    $model[41] =  Array('ANY','H1','H2','H3');
    $model[42] =  Array('ANY','ACCENT','AMICA','ATOZ','COUPE','ELANTRA','GETZ','GRANDEUR','LANTRA','MATRIX','PONY','S-COUPE','SANTA FE','SONATA','TERRACAN','TRAJET','TUCSON','X2','XG30');
    $model[43] =  Array('ANY','FX');
    $model[44] =  Array('ANY','BIGHORN','D-MAX','MU','RODEO','TF','TROOPER','VEHICROSS');
    $model[45] =  Array('ANY','420','E-TYPE','MARK II','MARK X','S-TYPE','SOVEREIGN','V8','X-TYPE','XJ SERIES','XJS','XK');
    $model[46] =  Array('ANY','CHEROKEE','COMMANDER','COMPASS','GRAND CHEROKEE','PATRIOT','RENEGADE','WRANGLER');
    $model[47] =  Array('ANY','C-V8','HEALEY','INTERCEPTOR','S-V8');
    $model[48] =  Array('ANY','CARENS','CEED','CERATO','CLARUS','MAGENTIS','MENTOR','PICANTO','PRIDE','RIO','SEDONA','SHUMA','SORENTO','SPORTAGE');
    $model[49] =  Array('ANY','CCR','CCX');
    $model[50] =  Array('ANY','SAMARA');
    $model[51] =  Array('ANY','COUNTACH','DIABLO','GALLARDO','JALPA','MURCIELAGO');
    $model[52] =  Array('ANY','BETA','DEDRA','DELTA');
    $model[53] =  Array('ANY','DEFENDER','DISCOVERY','FREELANDER','LIGHTWEIGHT','RANGE ROVER','RANGE ROVER SPORT','SERIES I','SERIES II','SERIES III');
    $model[54] =  Array('ANY','GS','IS','LS','RX','SC','SOARER');
    $model[55] =  Array('ANY','AMBRA');
    $model[56] =  Array('ANY','BLACKWOOD','CONTINENTAL','COSMOPOLITAN','NAVIGATOR','TOWN CAR');
    $model[57] =  Array('ANY','2-ELEVEN','340R','CARLTON','ECLAT','ELAN','ELISE','ELITE','ESPRIT','EUROPA','EXCEL','EXIGE','SEVEN');
    $model[58] =  Array('ANY','TXII');
    $model[59] =  Array('ANY','LM','MANTIS','MANTULA','TSO');
    $model[60] =  Array('ANY','SPORTSTER');
    $model[61] =  Array('ANY','3200','4200','BITURBO','COUPE','GHIBLI','GRANSPORT','INDY','QUATTROPORTE','SPYDER');
    $model[62] =  Array('ANY','57','62');
    $model[63] =  Array('ANY','121','323','626','B-SERIES','BONGO','BT-50','COSMO','CX-7','DEMIO','EUNOS','MAZDA2','MAZDA3','MAZDA5','MAZDA6','MPV','MX-3','MX-5','MX-6','PREMACY','RX7','RX8','TRIBUTE','XEDOS');
    $model[64] =  Array('ANY','M6');
    $model[65] =  Array('ANY','180','190','200','220','230','240','250','260','280','300','310','320','350','380','400','420','450','500','560','600','A CLASS','AMG','B CLASS','C CLASS','CE CLASS','CL','CLK','CLS','E CLASS','G CLASS','GL CLASS','M CLASS','R CLASS','S CLASS','SE CLASS','SEC SERIES','SEL SERIES','SL CLASS','SLK','SLR MCLAREN','TE SERIES','V CLASS','VANEO','VIANO');
    $model[66] =  Array('ANY','COUGAR','MONTEREY');
    $model[67] =  Array('ANY','METRO','MGA','MGB','MGC','MGF','MIDGET','MONTEGO','ROADSTER','RV8','SV','TD','TF','ZR','ZS','ZT','ZT-T');
    $model[68] =  Array('ANY','MC1','MC2','VIRGO');
    $model[69] =  Array('ANY','COOPER','COOPER S','ONE');
    $model[70] =  Array('ANY','3000GT','CARISMA','CHALLENGER','CHARIOT','COLT','DELICA','ECLIPSE','FTO','GALANT','GRANDIS','GTO','I-CAR','L200','LANCER','LEGNUM','OUTLANDER','PAJERO','RALLIART','RVR','SHOGUN','SHOGUN PININ','SHOGUN SPORT','SIGMA','SPACE RUNNER','SPACE STAR','SPACE WAGON','STARION','STRADA');
    $model[71] =  Array('ANY','VIEWT');
    $model[72] =  Array('ANY','4/4','AERO','PLUS 4','PLUS 8','ROADSTER');
    $model[73] =  Array('ANY','EIGHT','MINI','MINOR');
    $model[74] =  Array('ANY','TF1700');
    $model[75] =  Array('ANY','100 NX','200 SX','300 ZX','350 Z','ALMERA','ALMERA TINO','BLUEBIRD','CHERRY','CUBE','ELGRAND','FAIRLADY','FIGARO','GLORIA','LARGO','MAXIMA','MICRA','MISTRAL','MURANO','NAVARA','NOTE','PATHFINDER','PATROL','PRAIRIE','PRIMERA','PULSAR','QASHQAI','QX','SERENA','SILVIA','SKYLINE','STAGEA','SUNNY','TERRANO','X-TRAIL');
    $model[76] =  Array('ANY','M12','M400');
    $model[77] =  Array('ANY','ASTRA','CORSA','FRONTERA','GT','KADETT','MONZA','OMEGA','TIGRA','VECTRA','ZAFIRA');
    $model[78] =  Array('ANY','ZONDA');
    $model[79] =  Array('ANY','KALLISTA','LIMA');
    $model[80] =  Array('ANY','KELISA','KENARI','MYVI','NIPPA');
    $model[81] =  Array('ANY','1007','106','107','205','206','206 SW','207','305','306','307','307 SW','309','4007','405','406','407','504','605','607','806','807','EXPERT TEPEE','PARTNER COMBI');
    $model[82] =  Array('ANY','CEVENNES','SPEEDSTER II');
    $model[83] =  Array('ANY','SPEEDSTER','SUMO');
    $model[84] =  Array('ANY','PROWLER');
    $model[85] =  Array('ANY','FIERO','FIREBIRD','SOLSTICE','TRANS AM','TRANS SPORT');
    $model[86] =  Array('ANY','356','911','911 GT3','924','928','944','968','BOXSTER','CARRERA GT','CAYENNE','CAYMAN');
    $model[87] =  Array('ANY','COMPACT','COUPE','GEN-2','GL','GLS','IMPIAN','PERSONA','PROTON','SATRIA','SATRIA NEO','SAVVY','WIRA');
    $model[88] =  Array('ANY','2+2');
    $model[89] =  Array('ANY','SR3');
    $model[90] =  Array('ANY','RIALTO','ROBIN','SCIMITAR');
    $model[91] =  Array('ANY','19','21','5','6','7','AVANTIME','CLIO','ESPACE','GRAND ESPACE','GRAND SCENIC','GTA','KANGOO','LAGUNA','MEGANE','MEGANE SCENIC','MODUS','SAFRANE','SCENIC','SPORT SPIDER','TWINGO','VEL SATIS');
    $model[92] =  Array('ANY','CAMARGUE','CORNICHE','PHANTOM','SILVER CLOUD','SILVER DAWN','SILVER SERAPH','SILVER SHADOW','SILVER SPIRIT','SILVER SPUR','SILVER WRAITH');
    $model[93] =  Array('ANY','100','200','2000','2200','25','3500','400','45','600','75','800','CABRIOLET','CITY ROVER','COUPE','MAESTRO','METRO','MGF','MINI','P5','SD1','STERLING','STREETWISE','TOURER','VITESSE');
    $model[94] =  Array('ANY','9-3','9-5','90','900','9000','99');
    $model[95] =  Array('ANY','ALHAMBRA','ALTEA','AROSA','CORDOBA','IBIZA','LEON','TOLEDO','VARIO');
    $model[96] =  Array('ANY','MXR','SX');
    $model[97] =  Array('ANY','FABIA','FAVORIT','FELICIA','OCTAVIA','ROOMSTER','SUPERB');
    $model[98] =  Array('ANY','CDI','CITY-CABRIOLET','CITY-COUPE','CROSSBLADE','FORFOUR','FORTWO','PASSION','PULSE','PURE','ROADSTER','ROADSTER-COUPE');
    $model[99] =  Array('ANY','KORANDO','KYRON','MUSSO','REXTON','RODIUS','SPORTS');
    $model[100] =  Array('ANY','FORESTER','IMPREZA','JUSTY','LEGACY','OUTBACK','SVX','TRIBECA','VIVIO');
    $model[101] =  Array('ANY','ALPINE');
    $model[102] =  Array('ANY','ALTO','BALENO','CAPPUCCINO','GRAND VITARA','IGNIS','JIMNY','LIANA','SAMURAI','SJ','SWIFT','SX4','VITARA','WAGON R','X-90');
    $model[103] =  Array('ANY','MATRA','SUNBEAM');
    $model[104] =  Array('ANY','GURKHA','SAFARI');
    $model[105] =  Array('ANY','TD 2000');
    $model[106] =  Array('ANY','AVON');
    $model[107] =  Array('ANY','4-RUNNER','ALPHARD','ALTEZZA','ARISTO','AURIS','AVENSIS','AVENSIS VERSO','AYGO','BB','CAMRY','CARIB','CARINA','CELICA','CHASER','COROLLA','COROLLA VERSO','CORONA','ESTIMA','FJ CRUISER','GRANVIA','HARRIER','HIACE','HILUX','LANDCRUISER','LITEACE','LUCIDA','MR-S','MR2','NOAH','PASEO','PICNIC','PRADO','PREVIA','PRIUS','RAV-4','SERA','SOARER','SPACE CRUISER','STARLET','SUPRA','SURF','TOWNACE','VERSO','WILL','YARIS','YARIS VERSO');
    $model[108] =  Array('ANY','2000','ACCLAIM','DOLOMITE','GT6','HERALD','SPITFIRE','STAG','TOLEDO','TR3','TR4','TR6','TR7','TR8');
    $model[109] =  Array('ANY','1600M','3000M','350I','390','450','CERBERA','CHIMAERA','GRIFFITH','S CONVERTIBLE','S2','S3','SAGARIS','T350','TAIMAR','TAMORA','TASMIN','TUSCAN','V8','VIXEN');
    $model[110] =  Array('ANY','CAN-AM','GTR','SPYDER');
    $model[111] =  Array('ANY','AGILA','ANTARA','ASTRA','BELMONT','CALIBRA','CARLTON','CAVALIER','CORSA','FRONTERA','MERIVA','MONARO','MONTEREY','NOVA','OMEGA','SENATOR','SIGNUM','SINTRA','TIGRA','VECTRA','VICTOR','VIVA','VX220','VXR8','ZAFIRA');
    $model[112] =  Array('ANY','BEACH BUGGY','BEETLE','BORA','CARAVELLE','CORRADO','EOS','FOX','GOLF','GOLF PLUS','JETTA','KARMANN','LUPO','PASSAT','PHAETON','POLO','SANTANA','SCIROCCO','SHARAN','TOUAREG','TOURAN','VENTO');
    $model[113] =  Array('ANY','122','240','340','360','440','460','480','740','760','850','940','960','C30','C70','CROSS COUNTRY','S40','S60','S70','S80','S90','TORSLANDA','V40','V50','V70','V90','XC70','XC90');
    $model[114] =  Array('ANY','1600','1700','1800','2000','7','MEGABIRD','MEGABLADE','MEGABUSA','SE','SEI','SEIGHT');
    $model[115] =  Array('ANY','16/60','6/80');


     
    // List of makes:


    $make_v =  Array('MAKE','ANY','AC','AIXAM','ALFA ROMEO','ASCARI','ASIA','ASTON MARTIN','AUBURN','AUDI','AUSTIN','BELSIZE','BENTLEY','BITTER','BMW','BRISTOL','BUGATTI','BUICK','CADILLAC','CATERHAM','CHEVROLET','CHRYSLER','CITROEN','COLEMAN MILNE','CORVETTE','DAEWOO','DAIHATSU','DAIMLER','DATSUN','DAX','DE TOMASO','DODGE','EXCALIBUR','FERRARI','FIAT','FORD','GINETTA','GMC','HILLMAN','HOLDEN','HONDA','HUMMER','HYUNDAI','INFINITI','ISUZU','JAGUAR','JEEP','JENSEN','KIA','KOENIGSEGG','LADA','LAMBORGHINI','LANCIA','LAND ROVER','LEXUS','LIGIER','LINCOLN','LOTUS','LTI','MARCOS','MARLIN','MASERATI','MAYBACH','MAZDA','MCLAREN','MERCEDES-BENZ','MERCURY','MG','MICROCAR','MINI','MITSUBISHI','MITSUOKA','MORGAN','MORRIS','NAYLOR','NISSAN','NOBLE','OPEL','PAGANI','PANTHER','PERODUA','PEUGEOT','PGO','PILGRIM','PLYMOUTH','PONTIAC','PORSCHE','PROTON','QUANTUM','RADICAL','RELIANT','RENAULT','ROLLS-ROYCE','ROVER','SAAB','SEAT','SEBRING','SKODA','SMART','SSANGYONG','SUBARU','SUNBEAM','SUZUKI','TALBOT','TATA','TD CARS','TIGER','TOYOTA','TRIUMPH','TVR','ULTIMA','VAUXHALL','VOLKSWAGEN','VOLVO','WESTFIELD','WOLSELEY');

    $make_d =  Array('MAKE','ANY MAKE','AC','AIXAM','ALFA ROMEO','ASCARI','ASIA','ASTON MARTIN','AUBURN','AUDI','AUSTIN','BELSIZE','BENTLEY','BITTER','BMW','BRISTOL','BUGATTI','BUICK','CADILLAC','CATERHAM','CHEVROLET','CHRYSLER','CITROEN','COLEMAN MILNE','CORVETTE','DAEWOO','DAIHATSU','DAIMLER','DATSUN','DAX','DE TOMASO','DODGE','EXCALIBUR','FERRARI','FIAT','FORD','GINETTA','GMC','HILLMAN','HOLDEN','HONDA','HUMMER','HYUNDAI','INFINITI','ISUZU','JAGUAR','JEEP','JENSEN','KIA','KOENIGSEGG','LADA','LAMBORGHINI','LANCIA','LAND ROVER','LEXUS','LIGIER','LINCOLN','LOTUS','LTI','MARCOS','MARLIN','MASERATI','MAYBACH','MAZDA','MCLAREN','MERCEDES-BENZ','MERCURY','MG','MICROCAR','MINI','MITSUBISHI','MITSUOKA','MORGAN','MORRIS','NAYLOR','NISSAN','NOBLE','OPEL','PAGANI','PANTHER','PERODUA','PEUGEOT','PGO','PILGRIM','PLYMOUTH','PONTIAC','PORSCHE','PROTON','QUANTUM','RADICAL','RELIANT','RENAULT','ROLLS-ROYCE','ROVER','SAAB','SEAT','SEBRING','SKODA','SMART','SSANGYONG','SUBARU','SUNBEAM','SUZUKI','TALBOT','TATA','TD CARS','TIGER','TOYOTA','TRIUMPH','TVR','ULTIMA','VAUXHALL','VOLKSWAGEN','VOLVO','WESTFIELD','WOLSELEY');


    // add the cars to the database

    $sql "";
            
    foreach(
    $make_v as $key=>$data) {
        foreach(
    $model[$key] as $key2=>$data2) {
            
    $sql .= "insert into cars (make, model)    values('"$data ."', '"$data2 ."'); <br />";
        }
    }

    echo 
    $sql;
    mysql_query($sql) or die(MYSQL_ERROR());

    ?>
    Mike Swiffin - Community Team Advisor
    Only a woman can read between the lines of a one word answer.....

  6. #6
    SitePoint Addict tina88's Avatar
    Join Date
    Jan 2007
    Location
    UK
    Posts
    270
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Oh, I see Thanx. I will have a look at this when I get home.

  7. #7
    SitePoint Zealot darksystem's Avatar
    Join Date
    Jan 2005
    Location
    Fayettville, North Carolina
    Posts
    184
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I have the same problem and I think this will help.
    Ebay API, OSC/CRE/OscMax/ZenCart/SEO Services
    Lucki Multimedia - Email

  8. #8
    SitePoint Addict tina88's Avatar
    Join Date
    Jan 2007
    Location
    UK
    Posts
    270
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Sorry to reopen this thread again but I need a country,region and city database. I bought the one from the link I posted above but they never gave me it and when I try to contact them, they do not reply Is there another free (or very cheap) database available? I don't need distances and all that, I just need the names of places.

    Thanks

  9. #9
    SitePoint Zealot darksystem's Avatar
    Join Date
    Jan 2005
    Location
    Fayettville, North Carolina
    Posts
    184
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If I were you, I will try to pull the country, state, cities of the signup process of
    gmail or yahoomail and try to use or copy and save to database as your record.

    Hope it helps.

    Quote Originally Posted by tina88 View Post
    Sorry to reopen this thread again but I need a country,region and city database. I bought the one from the link I posted above but they never gave me it and when I try to contact them, they do not reply Is there another free (or very cheap) database available? I don't need distances and all that, I just need the names of places.

    Thanks
    Ebay API, OSC/CRE/OscMax/ZenCart/SEO Services
    Lucki Multimedia - Email


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •