search button

[ckwall]

I dont know if I am doing this right but here is what I have so far:

<?  

    $username="root";  

    $password="";  

    $database="tracker";  

    $server="localhost";  

mysql_connect($server,$username,$password);  
@mysql_select_db($database) or die( "Unable to select database");  
$result = mysql_query ("SELECT * FROM request WHERE Headline LIKE '%ticket_number_search%'");  
echo $result; 
mysql_close();  
?>

My intent is to have a text field (ticket_number_search) with a search button that when clicked searches for the value in the text field.

Im I on the right track?

How do I make the button do the search?

[mystrymaster]

html form that submits to another php page that actually searches the db

[ckwall]

Here is the form:

              <form name="ticket_number_search" method="post" action="search_script.php">
                <strong><font color="#FF0000" size="3" face="Arial, Helvetica, sans-serif">Enter 
                your ticket number: </font></strong> 
                <input type="text" name="ticket_number_search">
              </form>
              <form name="form1" method="post" action="">
                <input type="submit" name="Submit" value="Submit">
              </form>

Is this what you were suggesting?

I dont know if I am doing it right.

[ckwall]

wait... hold on
now I have it all messed up. Let me repost in just a minute.

[ckwall]

ok, here is my form

 <form name="ticket_number_search" method="post" action="search_script.php">
                <strong><font color="#FF0000" size="3" face="Arial, Helvetica, sans-serif">Enter 
                your ticket number: </font></strong> 
                <input type="text" name="ticket_number_search"><br><br>
				<input type="submit" name="Search" value="Search">
              </form>

[ckwall]

am I on the right track so far?