SQL search - Script written but doesn't work

[pinehead18]

if ($_POST['search']) {
        $rarray = array($relation,$friend,$online,$activity);
$relationship = implode(",", $rarray);
        $con = mysql_connect("localhost","p","") or die(mysql_error());
        $db = mysql_select_db("pinehead",$con) or die(mysql_error());
        $sql = " SELECT * FROM users WHERE (age > $agemin) AND (age < $agemax) AND city like '%$city%' limit 0,5";                  

        $result = mysql_query($sql,$con) or die(mysql_error());
        while ($row = mysql_fetch_array($result)) {
}
        $name = $row['fname'];
        echo "A search has been performed";
        echo $name;
        echo $sql; 

}

Ok, i know i have feilds in the sql table that match the search criteira i search for. However it will never echo any results.

Any ideas
This is my code, thank you.
Anthony

[sid]

if ($_POST['search']) { 
        $rarray = array($relation,$friend,$online,$activity); 
$relationship = implode(",", $rarray); 
        $con = mysql_connect("localhost","p","") or die(mysql_error()); 
        $db = mysql_select_db("pinehead",$con) or die(mysql_error()); 
        $sql = " SELECT * FROM users WHERE (age > $agemin) AND (age < $agemax) AND city like '%$city%' limit 0,5";                   

        $result = mysql_query($sql,$con) or die(mysql_error()); 
        while ($row = mysql_fetch_array($result)) { 
            $name .= $row['fname'] . "<BR>"; 
        } 
        echo "A search has been performed"; 
        echo $name; 
        echo $sql;  

}

[cwissy]

while ($row = mysql_fetch_array($result)) {
}
        $name = $row['fname']; 

when the code gets to $name=$row[...etc
$row is false because of the while clause (while loop will exit when there is no more data to assign from the db.) so, $row['fname'] doesn't exist now.

try popping the $name=$row['fname'] statement within the while loop.

[sid]

i was faster :-Þ, yet even the initial version should return at leaste the fname of the last record shouldnt it?

[Lahloob]

Just as a good programming practice

it's useful to check the function ( var_dump($var) )

This function wil echo the contents of the variable $var .. so this might help you a bit...

try :
var_dump($name);