Taking values from 'multiple select'
| From: | Russ Michell | Date: | Thu, 01 Jan 1970 00:00:00 +0000 |
| Subject: | Taking values from 'multiple select' | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-5990@lists.php.net to get a copy of this message | ||
Hello everyone:
I am using PHP4 on MySQL 3.22.32
I wish to take multiple values from an html multiple select form
element, Where they will be compared to the content of a MySQL table
field containing multiple entries.
For Example: One field named 'sport' contains: soccer, basketball, golf
(separated by commas)
A user should be able view all table entries relevant to him if his
[potentially] multiple entries match those in the DB table. (above)
Are there any specific php + SQL techiques for this? has anyone else
come across a solution to this on their web-travels?
Cheers.
Russ
#-------------------------------------------------------#
"Believe nothing - consider everything"
Russ Michell
Anglia Polytechnic University Webteam
www.anglia.ac.uk/webteam
r.j.michell@anglia.ac.uk
+44 (0)1223 363271 ext 2331
www.theruss.com
#-------------------------------------------------------#