Search query with newline for textarea data
===

i was using a input tag for entering the address in the form.

Input form code :
    
    <input type="text" name="address">

and the search query for searching the addresses, worked without any problem

Search form code:

        <input type="hidden" name="category_address" value="address"/>
        <select name='criteria_address'">
            <option selected="selected"> </option>
        <?php
            $order = "SELECT DISTINCT address FROM lh_clients ORDER BY clientname" or die (mysql_error());
            $result = mysql_query($order);	
            while($data = mysql_fetch_array($result))
            {
             echo ("<option> $data[address] </option>");
            }
        ?>


Search Result Display code :

    if(isset($_POST['criteria_address']))
	{
	$category_address = $_POST['category_address'];
        $criteria_address = $_POST['criteria_address'];

    $query = "SELECT * FROM lh_clients WHERE $category_address LIKE '%".$criteria_address."%'";

    echo "<tr><td colspan='8'>$num_rows Results Found</td></tr>";
	while($data = mysql_fetch_array($result))
	{
	echo("<tr>
	        <td>$data[clientname]</td>
	        <td>$data[clienttype]</td>
		<td>$data[address]</td>
		<td>$data[contacts]</td>
		<td>$data[sensitivity]</td>
		<td>$data[acountmanager]</td>
		<td>$data[responsibleexecutive]</td>
		</tr>");
	}

But now when i replacing the input tag and using <textarea> tag instead of it

textarea code :

    <textarea name="address"></textarea>

The Search code doesn't work. The <option> tag works fine, it pop up data from the address column but doesn't providing any search result according to that address.

By the way, when i give input something with out entering newline it works.
If any one can understand my problem please reply.
Thanks a lot in advance.