0

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";
       	  }
2
Contributors
2
Replies
3
Views
6 Years
Discussion Span
Last Post by iqra123
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.