helloooo
i am trying this query to compare records of two different tables...
i m geting this message!! no required out put
pplzz somebody help me its really urgent..
values for these ($jobTitle $industry $stationBase $gender $maritalStatus)are coming from textboxes!
here is the code...
$query = "SELECT *,
MATCH(industry, gender, maritalStatus, typeofWorkPosition, preferCity) AGAINST ('$industry $gender $maritalStatus $jobTitle $stationBase' IN BOOLEAN MODE) AS score
FROM membership_form
WHERE MATCH(industry, gender, maritalStatus, typeofWorkPosition, preferCity) AGAINST ('$industry $gender $maritalStatus $jobTitle $stationBase' IN BOOLEAN MODE)";
echo $query;
$result = mysql_query($query);
echo $result;
if(!$result) {
echo mysql_error()."<br>$query<br>";
}
if(mysql_num_rows($result)>0)
{
while($row = mysql_fetch_array($result)) {
echo "$row[industry]";
echo "$row[gender]";
echo "$row[maritalStatus]";
echo "$row[typeofWorkPosition]";
}
}
else {
echo "sorryyyyyyyyy";
}