hi guys, im abit stuck with sumink and well if any one here can help me id really appreciate it!

anyway i have a form where people type what they wana search click the button and go..

rite i can do that and i can get it to produce the results matching the criteria the thing is i wana do 3 results per page so there will be a dynamic link system at the bottom. well.. ive looked around and i can pretty much sort out the links.. i can get the search bit to work.

$result = mysql_query("SELECT * FROM table_name LIMIT $recordsfrom,
$pagelimit");
while ($row = mysql_fetch_array($result)) {
{
?>
<?=$row['field_name']?>
<?
}
?>

this i can understand with the limit bit which helps the dynamic links but when i add the search stuff i just get an error.

$result = mysql_query("SELECT * FROM table_name WHERE prop_type='$type' AND town='$town' AND range='$range' ORDER BY id ASC LIMIT $recordsfrom,
$pagelimit");
while ($row = mysql_fetch_array($result)) {
{
?>
<?=$row['field_name']?>
<?
}
?>

can any 1 help me pleaaaaase!?!?!.. i guess it works abit like a search engine but feck knows how!

PHP Code:

<?php

$sql = mysql_query('SELECT field1,field2 FROM 
                `table_name` 
            WHERE 
                prop_type LIKE "%'.$_GET['type'].'%" 
            AND
                town LIKE "%'.$_GET['town'].'%" 
            AND
                range LIKE "%'.$_GET['range'].'%" 
            ORDER by id ASC LIMIT '.$recordsfrom.','.$pagelimit.'')or die( mysql_error() );

If( mysql_num_rows($sql) )
{
    while( $r = mysql_fetch_assoc($sql) )
    {
        echo $r['field1'].' - '.$r['field2'].'<br>';
    }
}
Else
{
    echo 'No results..';
}

mysql_free_result($sql);
mysql_close();

?>