Spamfilter

[nclemale36]

i have all the scripts the site but its the sql table am not sure wot to put in the table.

[WhiteWarrior]

i have all the scripts the site but its the sql table am not sure wot to put in the table.[/b]

what script you using?

[nclemale36]

what script you using?[/b]

sp

[nclemale36]

sp[/b]

$number_of_rows2 = mysql_num_rows($result);
$sql = "SELECT * FROM spamfilter LIMIT $limit,10";
$result = mysql_query($sql);

$number_of_rows = mysql_num_rows($result);
$start = $number_of_rows - $number_of_rows;
while ($start < $number_of_rows ){

(get errors on these 2 lines below)
$from_who=(mysql_result($result,$start,"from_usern ame"));
$been_read=(mysql_result($result,$start,"has_it_be en_read"));

this is the database

DROP TABLE IF EXISTS `spamfilter`;
CREATE TABLE IF NOT EXISTS `spamfilter` (
`id` int(100) NOT NULL auto_increment,
`word1` varchar(80) NOT NULL default &#39;&#39;,
`word2` varchar(80) NOT NULL default &#39;&#39;,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;