Hi!
The set: I have a variable in my table with ONE of the following as blob:
1.0
1.5
...
12.5
The search the user does with a htlm-select (arrayvar[]) with multipe-selections
where possible selectabe values could be:
""
"1.0','1.5"
"2.0','2.5"
"3.0','3.5"
"4.0','4.5"
"5.0','5.5"
"6.0','6.5"
"7.0','7.5','8.0','8.5','9.0','9.5','10.0','10.5','11.0','11.5','12.0','12.5"
Then on the server I do for the mysql-search out of php:
$result = MysqlQuery( "SELECT * FROM $db_mytable WHERE $db_mytable.field IN ('" .
implode("', '" , $zimmermulreg) . "') " );
If for example the user selects
1.0','1.5 and 4.0','4.5
the term
('" . implode("', '" , $zimmermulreg)
should cause this:
$result = MysqlQuery( "SELECT * FROM $db_mytable WHERE $db_mytable.field IN
('1.0','1.5','4.0','4.5') " );
so result would get all rows of the table where field is 1.0 or 1.5 or 4.0 or 4.5.
But it doesn't work ):
I hope i described it well and someone could give me a hint.
Thanks
Dieter Hansen
[EMAIL PROTECTED]
________________________________________________________________
Keine verlorenen Lotto-Quittungen, keine vergessenen Gewinne mehr!
Beim WEB.DE Lottoservice: http://tippen2.web.de/?x=13
---------------------------------------------------------------------
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
