select statement using forms from another page

[ckwall]

I have a search page set up. It is basically a text field and a submit button. I dont know how to do this, so I will post what I have so far. I know that it is probably all wrong, see how close I am and see if you can get me going in the right direction.
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>

I think that I have the form done right, but I dont know the slightest as to how to grab the values from the textfield and have my select statement pull the correct data. I have the action set to use search_script.php. This is where I am most confused.

Here is what I have. Like I said earlier, I know this is wrong. I am confused:

<?  

    $username="root";  

    $password="";  

    $database="tracker";  

    $server="localhost";  

mysql_connect($server,$username,$password);  
@mysql_select_db($database) or die( "Unable to select database");  

$query="SELECT * FROM request where timestamp LIKE %ticket_number_search%";
$result=mysql_query($query);

echo "
	$result
";

//print errors if any on page
echo mysql_error();

mysql_close();  
?>

I am using timestamp from the database as a ticket number on the page.

[kevinsequeira]

<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="column_value_from_form">
<input type="submit" name="Search" value="Search">
</form>
<?  

		//search_script.php
  // set up the database connections
		$username="root";  

  $password="";  

  $database="tracker";  

  $server="localhost";  

  // connect to server and database
  mysql_connect($server,$username,$password);  

  mysql_select_db($database) or die( "Unable to select database");  

		// get value from form
		$column_value_from_form = $_POST['column_value_from_form'];
		// construct the query  

  $query="SELECT * FROM table_name WHERE column_name='$column_value_from_form'";
		// run the query with error checking
  $result=mysql_query($query) or die(mysql_error());
		// see if query has any results
		if(mysql_num_rows($result)<1){
			echo "no results";
		}else{
		//loop through the results
			while($row = mysql_fetch_array($result)){
			// display indivdual values
			echo $row[0]." : ".$row[1];
			// to see all the values in each row use the next line
			print_r($row);
			}
		} 
		//close database conenctions 
  mysql_close();  

?> 

reg
kevin

[ckwall]

Thank you very much.
I have looked the code over and for the most part understand what you were showing me.

One question that I have is, on my search script, You have the array printing out. It seems to be displaying all the values twice.

Here is an example of the output in the browser.
: Array ( [0] => [assigned_3] => [1] => [assigned_2] => [2] => [assigned_1] => [3] => [approval] => [4] => [owner] => [5] => 2 [priority] => 2 [6] => asdf [first_name] => asdf [7] => [last_name] => [8] => Client Services [department] => Client Services [9] => [ext] => [10] => [email] => [11] => [summary] => [12] => [details] => [13] => DD [day] => DD [14] => MM [month] => MM [15] => YYYY [year] => YYYY [16] => 20030812143041 [timestamp] => 20030812143041 )

I would like to better format this so that it is more readable for users. But I have never used array, so I dont know what to do with it.