PHP/MySQL count script

[freeflow]

How can I count the number of times http appears in a table space entry?
I would like to use that number for an if statement to delete automated spam
entries from my forum when http appears more than 10 times.

 

[Peter]

you could for example do :-

<?php
$a = 'this is my http test which has a few http in it http';
$expression = '/http/';
preg_match_all($expression, $a, $matches);
$count = count($matches[0]);
echo $count;
?>

 

[Eric]

Simpler way:

<?php

$text = 'this is my http test which has a few http in it http';

echo substr_count($text, 'http'); // 3

?>

 

[chadsmith]

What forum are you using? Also, are you wanting it to check retroactively (existing posts) or just have it check them from now on?

 

[freeflow]

Thanks everyone for your help! The spam filter works now. :D