> -----Original Message-----
> From: Aaron Wolski [mailto:[EMAIL PROTECTED]
> Sent: 26 June 2003 16:12
>
> Solved my problem!
>
> Here's the code in case anyone really cares :P
>
> $col = explode(",",$threadsColumn);
>
> $col_search = "(";
> for ($i=0;$i<count($col);$i++) {
>
> $col_search .= $col[$i]." LIKE
> '%$threadsName%'";
> if ($i != (count($col) - 1)) {
> $col_search .= " OR ";
> }
> }
>
> $col_search .= ")";
Yes, that's about how I'd do it -- you may, however, be interested in this variation
on the theme:
$col = explode(",",$threadsColumn);
$col_search = array();
foreach ($col as $col_name) {
$col_search[] = "$col_name LIKE '%$threadsName%'";
$col_search = "(" . implode(' OR ', $col_search) . ")";
A completely different approach might be to do it like this:
$col_search = "("
. str_replace(',',
" LIKE '%$threadsName%' OR ",
$threadsColumn)
. " LIKE '%$threadsName%'"
. ")";
Cheers!
Mike
---------------------------------------------------------------------
Mike Ford, Electronic Information Services Adviser,
Learning Support Services, Learning & Information Services,
JG125, James Graham Building, Leeds Metropolitan University,
Beckett Park, LEEDS, LS6 3QS, United Kingdom
Email: [EMAIL PROTECTED]
Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
