In a message dated Wed, 3 Jul 2002 8:18:35 PM Eastern Standard Time, yomama@u... writes:

>  $WHERE_EXPRS = array();
> 
>  // build an array of all the WHERE expressions
>  foreach column in the table
>  {
>     if column type is text
>     {
>         $WHERE_EXPRS[] = "(column LIKE '%searchtext%')";
>     }
>  }
Heres the form itself, how would I need to modify it?

<form method="POST" action="--WEBBOT-SELF--">
   <p>Basic Search Form (for registered users who have subscribed)</p>
  <p>Surname: <input type="text" name="T1" size="20"></p>
  <p>Forenames: <input type="text" name="T2" size="20"></p>
  <p>Date: <input type="text" name="T3" size="20"></p>
  <p>Place: <input type="text" name="T8" size="20"></p>
  <p>State: <select size="1" name="D1">
    <option value=""> </option>
    <option value="ACT">Australian Capital Territory</option>
    <option value="NSW">New South Wales</option>
    <option value="NT">Northern Territory</option>
    <option value="QLD">Queensland</option>
    <option value="SA">South Australia</option>
    <option value="TAS">Tasmania</option>
    <option value="VIC">Victoria</option>
    <option value="WA">Western Australia</option>
  </select></p>
  <p>Contact: <select size="1" name="D2">
    <option value=""> </option>
    <option>1</option>
    <option>2</option>
    <option>3</option>
  </select></p>
  <p>Type: <select size="1" name="D3">

THIS PART BELOW TELLS IT WHICH TABLE TO SEARCH
    <option value=""> </option>
    <option value="AUSBIR">Australia: Civil Registrations: Births</option>
    <option value="AUSDEA">Australia: Civil Registrations: Deaths</option>
    <option value="AUSMAR">Australia: Civil Registrations: Marriages</option>
    <option value="AUSBAP">Australia: Parish Registrations: Baptisms</option>
    <option value="AUSBUR">Australia: Parish Registrations: Burials</option>
    <option value="AUSPMA">Australia: Parish Registrations: Marriages</option>
    <option value="NZLBIR">New Zealand: Civil Registrations: Births</option>
    <option value="NZLDEA">New Zealand: Civil Registrations: Deaths</option>
    <option value="NZLMAR">New Zealand: Civil Registrations: Marriages</option>
  </select></p>
  <p><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"><input
type="submit" value="Advanced Search" name="B3"><input type="button" value="Edit My Records" name="B5"><input
type="submit" value="Logout" name="B4"></p>
</form>