What's wrong with this inplode / array / mysql-querry ??
>From an html site i get the following variables
zimmermulreg bezirkmul: Usually string arrays from a multiselect-field
qmvon, qmbis, mietebis: string
if ( $mietebis == '') {$mietebis='1000000';};
if ( $qmvon == '') {$qmvon='-1';};
if ( $qmbis == '') {$qmbis='1000000';};
$result = MysqlQuery( "SELECT * FROM $db_angebotetabelle WHERE (( (" . implode("',
'" , $zimmermulreg) . ") == '') OR ($db_angebotetabelle.zimmerzahl IN ('" .
implode("', '" , $zimmermulreg) . "') )) AND (( (" . implode( "', '" , $bezirkmul) .
") == '') OR ($db_angebotetabelle.bezirk IN ('" . implode( "', '" , $bezirkmul) . "')
)) AND ($db_angebotetabelle.groesse BETWEEN $qmvon AND $qmbis) AND
($db_angebotetabelle.miete <= $mietebis) ORDER BY bezirk, zimmerzahl, groesse" );
Which does result in:
--
Warning: Bad arguments to implode() in admin/search.php3 on line 19
Warning: Bad arguments to implode() in admin/search.php3 on line 19
Warning: Bad arguments to implode() in admin/search.php3 on line 19
Warning: Bad arguments to implode() in admin/search.php3 on line 19
Bei der Abfrage: "SELECT * FROM angebotetable WHERE (( () == '') OR
(angebotetable.zimmerzahl IN ('') )) AND (( () == '') OR (angebotetable.bezirk IN ('')
)) AND (angebotetable.groesse BETWEEN 0 AND 5555) AND (angebotetable.miete <= 3652269)
ORDER BY bezirk, zimmerzahl, groesse" ist folgender Fehler aufgetreten:
You have an error in your SQL syntax near ') == '') OR (angebotetable.zimmerzahl IN
('') )) AND (( () == '') OR (angeboteta' at line 1
Warning: 0 is not a MySQL result index in admin/search.php3 on line 21
--
You could try the search and look at the html-code for the user if you want at:
http://www.tageskurier.de/search_vermietungsangebote.htm
THANK you very much in advance
Dieter Hansen
[EMAIL PROTECTED]
______________________________________________________________________________
Geben Sie Ihren Lottotipp gerne auf den letzten Drücker ab?Beim WEB.DE
Lottoservice gibt's keine Warteschlangen. http://tippen2.web.de/?x=9
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
