searching the database

[Paul_Ferrie]

Right so i have built the database, able to return and display contents in the browser. Now i want to search and display results.
Here is what i have so far:
http://www.ancilehosting.co.uk/~pferrie/records4sale/phpHTML/list.php

The search faciltiy does nothing at this point apart from refresh the page.
How do i take whats in the textbox and the Ddmenu and and it to the form action?

Cheers Paul

[Frederick]

your query will be something like this

if (isset($submit)) {
    $sql = mysql_query("SELECT * FROM '$select' LIKE '%$stringer%' ") or die (mysql_error());
    while ($row = mysql_fetch_array($sql)) {
        // info here
    }
} else {
    // your existing table here
}