Okay. I THINK I've solved this one...
Code: Select all
<?php
/* Program: check.php
* Desc: Checks for used URN.
*/
// Get the search variable from URL
$var = $_GET['q']; //search term
$var = ucwords ($var);
// rows to return
$limit=500;
//connect to your database
include_once("../*******.inc.php");
mysql_connect("$host","$user","$password"); //(host, username, password)
//specify database
mysql_select_db($database) or die("Unable to select database");
// Build SQL Query
$query = "SELECT urn,motherurn,fatherurn,sibling1urn,sibling2urn,sibling3urn,sibling4urn,sibling5urn,sibling6urn,sibling7urn,sibling8urn,sibling9urn,sibling10urn,sibling11urn,sibling12urn,sibling13urn,sibling14urn,sibling15urn,sibling16urn,spouse1urn,spouse1child1urn,spouse1child2urn,spouse1child3urn,spouse1child4urn,spouse1child5urn,spouse1child6urn,spouse1child7urn,spouse1child8urn,spouse1child9urn,spouse1child10urn,spouse1child11urn,spouse1child12urn,spouse1child13urn,spouse1child14urn,spouse1child15urn,spouse1child16urn,spouse2urn,spouse2child1urn,spouse2child2urn,spouse2child3urn,spouse2child4urn,spouse2child5urn,spouse2child6urn,spouse2child7urn,spouse2child8urn,spouse2child9urn,spouse2child10urn,spouse2child11urn,spouse2child12urn,spouse2child13urn,spouse2child14urn,spouse2child15urn,spouse2child16urn FROM tree WHERE MATCH (urn,motherurn,fatherurn,sibling1urn,sibling2urn,sibling3urn,sibling4urn,sibling5urn,sibling6urn,sibling7urn,sibling8urn,sibling9urn,sibling10urn,sibling11urn,sibling12urn,sibling13urn,sibling14urn,sibling15urn,sibling16urn,spouse1urn,spouse1child1urn,spouse1child2urn,spouse1child3urn,spouse1child4urn,spouse1child5urn,spouse1child6urn,spouse1child7urn,spouse1child8urn,spouse1child9urn,spouse1child10urn,spouse1child11urn,spouse1child12urn,spouse1child13urn,spouse1child14urn,spouse1child15urn,spouse1child16urn,spouse2urn,spouse2child1urn,spouse2child2urn,spouse2child3urn,spouse2child4urn,spouse2child5urn,spouse2child6urn,spouse2child7urn,spouse2child8urn,spouse2child9urn,spouse2child10urn,spouse2child11urn,spouse2child12urn,spouse2child13urn,spouse2child14urn,spouse2child15urn,spouse2child16urn) AGAINST ('$var' IN BOOLEAN MODE)";
$numresults=mysql_query($query);
$numrows=mysql_num_rows($numresults);
// URN Available.
if ($numrows == 0)
{
echo "<font face='Arial' size='4'>URN $var is <font color='#00FF00'>AVAILABLE</font></font>";
exit;
}
// next determine if s has been passed to script, if not use 0
if (empty($s)) {
$s=0;
}
// get results
$query .= " limit $s,$limit";
$result = mysql_query ($query) or die(mysql_error());
// begin to show results set
$count = 1 + $s ;
// now you can display the results returned
/* Display results in a table */
$i=0;
while ($row = mysql_fetch_array($result))
{
extract($row);
$bg = ($i%2) ? $rowht : $rowcl;
$i++;
$count++ ;
echo "<font face='Arial' size='4'>URN $var is <font color='#FF0000'>NOT AVAILABLE</font></font>";
exit;
}
?>
It seems to work fine, interrogating my entire MySQL database and returning a message dependant on what it finds.