Re: row pointer
| From: | Analysis & Solutions | Date: | Sun, 16 Jun 2002 02:04:23 +0000 |
| Subject: | Re: row pointer | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-102371@lists.php.net to get a copy of this message | ||
Zac:
> foreach($kywrd as $val) {
> $fndWrds .= "wrd = '$val' OR ";
> }
FYI, a simpler way to do that...
$fndWrds = "wrd IN ('" . implode("','", $kywrd) .
"')";
That aside, w/o completely analyzing your entire set of code, it sounds
like John is on the right track with putting a unique index on the wrd
column.
Enjoy,
--Dan
--
PHP classes that make web design easier
SQL Solution | Layout Solution | Form Solution
sqlsolution.info | layoutsolution.info | formsolution.info
T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y
4015 7 Av #4AJ, Brooklyn NY v: 718-854-0335 f: 718-854-0409