search database

[CrusaderSean]

I'm wondering how I can (easiest way) to use a search form to search through my database.

today I finished most of my site (except for search, couple navigation extras, and stats stuff)

AnimeDB

i have detailed view done (check love hina) and list view for unfinished ones (check witch hunter robin) and movie ones just a cover (check any movie)

sorry for the slow upload.

[jeremuck]

it all depends on what you want to search for, what results you want, which fields you want to search....

probably the easiest way is to have one text field.

then build a select query that asks each field for a match.
You can get the list of fields by 1.) supplying them explicity or 2.) Getting a list of fields from the DB.

once you have a list of fields, build a SELECT statement like...

$sql = "SELECT field1, field2 FROM table WHERE";

$criteria = array();

foreach($fieldlist as $field)
{
  $criteria[$field] = $field . " LIKE '%" . $searchValue . "%'";
}

$sql .= implode(" OR ", $criteria);

echo $sql;

something like that.