| | |
| Stránka: 1 z 1
| [ Príspevok: 1 ] | |
Autor | Správa |
---|
Registrovaný: 02.04.11 Prihlásený: 14.08.14 Príspevky: 74 Témy: 31 |
Ahojte, riesim taky problem a ani nahodou ma nenapada, ako by som mohol postupovat... Pouzivam jQuery AutoComplete, kde chcem zobrazovat udaje z viacerych tabuliek v DB. Mam tabulky: accomodation db_countries db_regions db_provinces db_cities
Potrebujem spravit taky vystup, aby mi miesal vysledky zo vsetkych tabuliek podla relevancie, ale nenapada ma, ako to vobec spravit Pripajam moj kod, funguje dobre, ale zobrazuje to len z tabulky accomodation mysql select: Kód: SELECT accomodation.id, accomodation.aid, accomodation.title_sk, accomodation.title_cz, accomodation.title_en, accomodation.title_de, accomodation.address, accomodation.zip, accomodation.latitude, accomodation.longitude, db_countries.title_sk AS country_sk, db_countries.title_cz AS country_cz, db_countries.title_en AS country_en, db_countries.title_de AS country_de, db_cities.title_sk AS city_sk, db_cities.title_cz AS city_cz, db_cities.title_en AS city_en, db_cities.title_de AS city_de, db_provinces.title_sk AS province_sk, db_provinces.title_cz AS province_cz, db_provinces.title_en AS province_en, db_provinces.title_de AS province_de
FROM (SELECT id, aid, title_sk, title_cz, title_en, title_de, address, zip, latitude, longitude, city_id, province_id, country_id, valid_from, valid_to FROM accomodation ORDER BY info_date_add DESC) AS accomodation LEFT JOIN db_cities ON db_cities.id = accomodation.city_id JOIN db_countries ON db_countries.id = accomodation.country_id JOIN db_provinces ON db_provinces.id = accomodation.province_id WHERE accomodation.title_sk LIKE '%".$search."%' OR accomodation.title_cz LIKE '%".$search."%' OR accomodation.title_en LIKE '%".$search."%' OR accomodation.title_de LIKE '%".$search."%' OR accomodation.address LIKE '%".$search."%' OR accomodation.zip LIKE '%".$search."%' OR accomodation.latitude LIKE '%".$search."%' OR accomodation.longitude LIKE '%".$search."%' OR db_countries.title_sk LIKE '%".$search."%' OR db_countries.title_cz LIKE '%".$search."%' OR db_countries.title_en LIKE '%".$search."%' OR db_countries.title_de LIKE '%".$search."%' GROUP BY accomodation.aid ORDER BY CASE WHEN accomodation.valid_to>=NOW() AND accomodation.valid_from<=NOW() THEN 0 WHEN accomodation.valid_to<NOW() AND accomodation.valid_to!='0000-00-00' THEN 1 ELSE 2 END,
accomodation.title_$lang LIMIT 20
vystup pre autocomplete: Kód: while ($r = mysql_fetch_assoc($s))//loop through the retrieved values { $object["value"] = stripslashes($r["title_$lang"]); $object["id"] = (int)$r["id"]; $row_set[] = $object;//build an array } echo json_encode($row_set);//format the array into json data
|
|
| Stránka: 1 z 1
| [ Príspevok: 1 ] | |
Podobné témy | Témy | Odpovede | Zobrazenia | Posledný príspevok |
---|
| MySQL Select v Databázy | 2 | 403 | 07.04.2014 6:52 XOLOO | | select z mysql v PHP, ASP | 4 | 484 | 09.10.2007 21:23 bruno.b | | MySQL - SELECT JOIN v Databázy | 9 | 800 | 21.07.2017 18:19 lukas15 | | MySQL select date between v Databázy | 3 | 359 | 05.06.2013 20:48 stenley | | mysql: 2 tabulky - jeden select v Databázy | 16 | 707 | 09.11.2014 22:03 JanoF | | ako zmenit vystup - select mysql v PHP, ASP | 3 | 544 | 29.07.2008 8:02 stenley | | MySQL SELECT IN() a rovnake hodnoty v Databázy | 11 | 1238 | 25.08.2009 20:48 bmatias | | Z mySql do <select> v PHP, ASP | 13 | 600 | 02.05.2009 23:32 suchy | | SELECT z MySQL db medzi dvoma casmi v Databázy | 9 | 2112 | 11.07.2018 13:51 jumper | | Autocomplete pre hesla a loginy v Exploreri 8 mi nefunguje. v Sieťové a internetové programy | 1 | 299 | 07.11.2010 7:28 tairikuokami | | Automaticke doplnanie <select> po kliknuti , vyber z MySql v JavaScript, VBScript, Ajax | 1 | 448 | 22.05.2015 12:44 stenley | | Jquery autocomplete v JavaScript, VBScript, Ajax | 2 | 402 | 01.09.2011 12:23 Unlink | | Autocomplete nefunguje v chrome v Sieťové a internetové programy | 3 | 552 | 23.01.2011 12:38 izzi | | autocomplete ajax z externého xml súboru v JavaScript, VBScript, Ajax | 2 | 394 | 14.08.2018 10:24 Pablo Montero | | Prestal mi fungovat autocomplete v Expoloreri 8. v Operačné systémy Microsoft | 0 | 365 | 06.06.2010 14:47 Bobesko | | Problem s prikazom pre mysql v PHP, ASP | 4 | 291 | 01.03.2015 19:35 Kraliček |
| Nemôžete zakladať nové témy v tomto fóre Nemôžete odpovedať na témy v tomto fóre Nemôžete upravovať svoje príspevky v tomto fóre Nemôžete mazať svoje príspevky v tomto fóre
|
|