find_step($sort_key = $table_primary_key(s), $offset = "0", $limit = "10000", $direction = "ASC", $search_string = '', $added_query = '', $added_query_type = 'AND')

Queries the database based on the currently set variables of the class. Class variables that aren't set are not used.

Returns false on error. On true, sets internal class variables to be used with step()

If $query_string is set, it'll split the query string (e.g. "term1 term2" or "term1, term2") and make sure each term is found at least once in a non-boolean field

If $added_query is set, it will add to the query "SELECT * FROM table WHERE $added_query" If there is already a WHERE in the query it will work like "SELECT * FROM table WHERE () $added_query_type $added_query"

SEARCHES DO NOT SEARCH "_LOOKUP" VARIABLES

Example:

example.php
<?php
include("lib.php");
load("person");

$results_per_page = 10;
$search_string = $_GET["search_string"];
$uss = urlencode($search_string);
if (!$offset = (int) $_GET["offset"])   $offset = 0;

$p = new person;
$p->find_step("name", $offset, $results_per_page, "ASC", $search_string);
$pagination = $p->get_find_pagination("index.php?search_string=$uss", $offset, $results_per_page, "", $search_string, 3, "2arrow");

$i = $offset;
while($r = $p->step())
{
        echo "Person: ".(++$i).": $r->name<br>";
}

if ($pagination["p_link"] || $pagination["middle_links"] || $pagination["n_link"])
echo "$pagination[p_link] &nbsp; $pagination[n_link] &nbsp; $pagination[middle_links]";

?>