Hello,
 
I have the following code and I am searching records from a table. I am getting 
all the results, but when I "un"comment the  lines I do not get the first 
record from the search result. I want to have those comment lines executing 
when no records are found, I want to display a message. 
 
I am searching from seven fields: native, from1, to1, from2, to2, from3 and 
to3, these fields have language names. Any help would be appreciated.
 
================
$sql = "SELECT
user_id, fname, mi, lname, native, from1, to1, from2, to2, from3, to3 
from memberinfo 
WHERE native='$_POST[language]' OR from1='$_POST[language]' OR 
to1='$_POST[language]'
OR from2='$_POST[language]' OR to2='$_POST[language]' OR 
from3='$_POST[language]'  OR from3='$_POST[language]'
ORDER BY lname"  ;

$result = @mysql_query($sql, $connection) or die(mysql_error());
 
/*
if (($row = mysql_fetch_array($result)) == 0)
{
 $member_list = "Sorry, we do not have any translators for $_POST[language]";
}
*/
 

$member_list = "<ul>";
while ($row = mysql_fetch_array($result))
{
$user_id = $row['user_id'];
$fname = $row['fname'];
$lname = $row['lname'];
$native = $row['native'];
$from1 = $row['from1'];
$to1 = $row['to1'];
$from2 = $row['from2'];
$to2 = $row['to2'];
$from3 = $row['from3'];
$to3 = $row['to3'];

$member_list .= "<li><a href=\"show_details.php?lname=$lname\">$lname, 
$fname</a>";
}
$member_list .= "</ul>";
 

?>


                
---------------------------------
Do you Yahoo!?
 The all-new My Yahoo!  What will yours do?

Reply via email to