Tweet
Ich bastle gerade ein Script welches mir Mitglieder geordnet nach der Entfernung anzeigt, mein Script speichert dazu die Reihenfolge der Distanzen der Postleitzahlen in einen String, das Problem ist, dass die Reihenfolge natürlich bei der Ausgabe nicht mehr stimmt. Daher versuche ich es nun mit SELECT FIELD (postleitzahlen)...
Hier der genaue Code, gibt allerdings immer den gleichen Fehler aus, siehe darunter:
$result = db_res( "SELECT FIELD(zip,'72760','72766','72764','72762','72768', '72770','72827','72793','72800','72124','72138','7 2127','72555','72585','72658','72657','72805','721 41','72813','72655','72661','72654','72810','72667 ','72074','72072','72581','72664','72076','72663', '72666','72639','72144','72574','72070','72820','7 2135','72147','72631','72829','72584','72829','728 29','72829','71111','72660','71093','72636','72116 ','72131','72622','72649','73268','70794','71144', '72532','72119','72531','70629','72669','71088','7 1101','72531','72644','73765','71155','72531','705 99','72393','70771','73770','72531','72531','70599 ','73240','70599','72417','73257','70599','70565', '71032','72818','70599','70567','73760','70565','7 0565','70567','70565','70597','70563','70565','705 99','70619','70569','70563','70597','70569','70597 ','73734') AS index, * FROM `Profiles` WHERE `zip` IN (72760,72766,72764,72762,72768,72770,72827,72793,7 2800,72124,72138,72127,72555,72585,72658,72657,728 05,72141,72813,72655,72661,72654,72810,72667,72074 ,72072,72581,72664,72076,72663,72666,72639,72144,7 2574,72070,72820,72135,72147,72631,72829,72584,728 29,72829,72829,71111,72660,71093,72636,72116,72131 ,72622,72649,73268,70794,71144,72532,72119,72531,7 0629,72669,71088,71101,72531,72644,73765,71155,725 31,70599,72393,70771,73770,72531,72531,70599,73240 ,70599,72417,73257,70599,70565,71032,72818,70599,7 0567,73760,70565,70565,70567,70565,70597,70563,705 65,70599,70619,70569,70563,70597,70569,70597,73734 ) AND `Status` = 'Active' AND (`Couple`=0 OR `Couple`>`ID`) ORDER BY `index` ASC LIMIT 0, 8" );
Mysql error:
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 'index, zip FROM `Profiles` WHERE `zip` IN (72760,72766,72764,72762,72768,72770,7' at line 1
Hier der genaue Code, gibt allerdings immer den gleichen Fehler aus, siehe darunter:
$result = db_res( "SELECT FIELD(zip,'72760','72766','72764','72762','72768', '72770','72827','72793','72800','72124','72138','7 2127','72555','72585','72658','72657','72805','721 41','72813','72655','72661','72654','72810','72667 ','72074','72072','72581','72664','72076','72663', '72666','72639','72144','72574','72070','72820','7 2135','72147','72631','72829','72584','72829','728 29','72829','71111','72660','71093','72636','72116 ','72131','72622','72649','73268','70794','71144', '72532','72119','72531','70629','72669','71088','7 1101','72531','72644','73765','71155','72531','705 99','72393','70771','73770','72531','72531','70599 ','73240','70599','72417','73257','70599','70565', '71032','72818','70599','70567','73760','70565','7 0565','70567','70565','70597','70563','70565','705 99','70619','70569','70563','70597','70569','70597 ','73734') AS index, * FROM `Profiles` WHERE `zip` IN (72760,72766,72764,72762,72768,72770,72827,72793,7 2800,72124,72138,72127,72555,72585,72658,72657,728 05,72141,72813,72655,72661,72654,72810,72667,72074 ,72072,72581,72664,72076,72663,72666,72639,72144,7 2574,72070,72820,72135,72147,72631,72829,72584,728 29,72829,72829,71111,72660,71093,72636,72116,72131 ,72622,72649,73268,70794,71144,72532,72119,72531,7 0629,72669,71088,71101,72531,72644,73765,71155,725 31,70599,72393,70771,73770,72531,72531,70599,73240 ,70599,72417,73257,70599,70565,71032,72818,70599,7 0567,73760,70565,70565,70567,70565,70597,70563,705 65,70599,70619,70569,70563,70597,70569,70597,73734 ) AND `Status` = 'Active' AND (`Couple`=0 OR `Couple`>`ID`) ORDER BY `index` ASC LIMIT 0, 8" );
Mysql error:
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 'index, zip FROM `Profiles` WHERE `zip` IN (72760,72766,72764,72762,72768,72770,7' at line 1