Posted by Captain Paralytic on 11/01/07 12:14

On 1 Nov, 10:32, joanna <m...@barrelofcrafts.com> wrote:
> Okay, my snippet goes hand in hand it is supposed to not show bad
> words that were searched for and it is supposed to show the 10 most
> recent searches. Here's my problem, it is only showing the 10th row as
> far as recent searches and the filtering of bad words doesn't work.
>
> $query=@mysql_query("SELECT search,recent FROM search
> ORDER BY recent ASC LIMIT 0,10 ");
>
> while($row = mysql_fetch_array( $query ))
> {
>
> $badWords = array('stupid', 'Jerk');
> $numBadWords = count($badWords);
>
> for($i="0";$i<$numBadWords;$i++){
> if(stripos($ss_mess,$badWords[$i]) != FALSE){
>
> }
>
> }
>
> $recent=($row['search']);
>
> }
>
> echo $recent;
>
> I should note that search is both a field and the name of the table (i
> know not the best design) and the field "recent" is timestamp type.

Your snippet uses a variable called $ss_mess which never seems to be
set. But then the if statement containing it has no code to do
anything either.

So all in all, I wouldn't expect this to do anything.

[Back to original message]