How to get wrong values when executing MySQL query?

[west158]

What i would do personally is query each row individually, i'm sure theres a more efficient way but i'm not the best at php...but this is how i'd do it...

<?php
$query=mysql_query("SELECT  * FROM    students_results WHERE   full_name LIKE '".trim($_POST['full_name'])."'  AND mother_name LIKE '".$database->escape_value(trim($_POST['mother_name']))."'  AND birthday = '".$database->escape_value($_POST['year2'])."'")
$count=mysql_num_rows($query)
if($count==0)
{
echo "Nothing found";
die();
}
else
{
while($row=mysql_fetch_array($query)
{
if($row['full_name']==0)
{
echo "Full name not found";
}
if($row['mother_name']==0)
{
echo "Mother name not found";
}
//etc etc
}
}
?>

that's how i'd do it, if the above doesn't work it may need some tweaking. Admins/mods feel free to edit if this doesn't work...