Hi again 
Ive not really been working on this much recently but i have been trying to sort out the searching solution without much success and i cant even get sphider to work on my new hosting 
However through my research i think that i have worked out what i need but i need some guidance on where i should take it from here.
Basicly i want to use the fulltext search feature of mysql - ive read a couple of articles and one gave this basic script but it goes on to say this cant because:
I have done absolutely no error checking. The $query variable provides an easy opening for an intruder to input something nasty into your query that might destroy your data.
Also im guessing its missing some key features to do with cleaning the search terms.
So basically im just trying to work out whether im on the right track and maybe what i need to consider and if anyone knows of a much easier solution that would be good too!!
One other thing, is the $_GET['pages'] issue sorted by what mike w said??
Thanks!! 
This is the script i was talking about
PHP Code:
<?php
/* call this script "this.php" */
if ($c != 1) {
?>
<form action="this.php?c=1">
<input type="text" name="keyword">
<input type="submit" value="Search!">
</form>
<?php
} else if ($c==1) {
MySQL_connect("hostname", "username", "password");
MySQL_select_db("database");
$sql = "
SELECT *,
MATCH(title, body) AGAINST('$keyword') AS score
FROM articles
WHERE MATCH(title, body) AGAINST('$keyword')
ORDER BY score DESC
";
$res = MySQL_query($sql);
?>
<table>
<tr><td>SCORE</td><td>TITLE</td><td>ID#</td></tr>
<?php
while($row = MySQL_fetch_array($rest)) {
echo "<tr><td>{$sql2['score']}</td>";
echo "<td>{$sql2['title']}</td>";
echo "<td>{$sql2['id']}</td></tr>";
}
echo "</table>";
}
?>