zoekopdracht

<?php

mysql_connect("$database_url", "$gebruiker", "$wachtwoord") or die("Connectie met Database mislukt"); 
mysql_select_db("$database") or die("Fout bij het selecteren van de database"); 


if($_SERVER['REQUEST_METHOD'] == 'GET') { 

  $insert=mysql_query("INSERT INTO zoekwoord VALUES ('','$trefwoord')");       

$zoekwoord = ($trefwoord);
$split = explode(' ', $zoekwoord);
$zoekwoord = '+'.implode(' +', $split);

 
	$result0 = "SELECT * FROM **** WHERE MATCH(******) AGAINST('$zoekwoord' IN BOOLEAN MODE) ORDER BY rank DESC"; 
	$query0 = mysql_query($result0) or die("Er is iets fout gegaan!"); 
	$resultaten0 = mysql_num_rows($query0); 
         $pages=intval($resultaten0/$count); 

	$result = "SELECT *  FROM **** WHERE MATCH(*****) AGAINST('$woord' IN BOOLEAN MODE) ORDER BY rank DESC LIMIT $page,$count"; 
	$query = mysql_query($result) or die("Er is iets fout gegaan!"); 
	mysql_close(); 

	$page_next=$page+$count; 
	if($page_next>=$resultaten0){ 
	$link_next=""; 
	}elseif($page_next<1){ 
	$link_next=""; 
	}else{ 
	$link_next="<a href=\"scripten.php?q=$trefwoord&page=$page_next\" id=\"link_next\">Volgende &gt;&gt;</a>"; 



} 



$page_prev=$page-$count; 

if($page_prev<0){ 
	$link_prev=""; 
}else{ 
	$link_prev="<a href=\"scripten.php?q=$trefwoord&page=$page_prev\" id=\"link_prev\">&lt;&lt; Vorige</a> "; 
} 
?>