[SOLVED] resourceid #5

iqra · 12-31-2010, 01:10 AM

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...

PHP Code:



 $query = "(SELECT *, 
    MATCH(industry, gender, maritalStatus , typeofWorkPosition , preferCity) AGAINST ('$jobTitle $industry $stationBase $gender $maritalStatus' IN BOOLEAN MODE) AS RELAVENCE  
          FROM membership_form  
       WHERE MATCH(industry, gender, maritalStatus , typeofWorkPosition , preferCity) AGAINST ('$jobTitle $city $industry $stationBase $gender $maritalStatus' IN BOOLEAN MODE))"; 
      // echo $query; 
        
      $result = mysql_query($query); 
        echo $result; 
      if(!$result) {  
         echo mysql_error()."<br>$query<br>";  
      }   
    while ($row=mysql_fetch_array($result)>0)  
        { 
            echo $row[0]; 
            }

Snark1994 · 01-01-2011, 09:41 AM

Quote:

Originally Posted by iqra

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..

What is the message? "No required output"? "Resource id #5"? Or something else? With regards to the code, it's "AS relevance" not "AS RELAVENCE" (I don't know if capitalisation matters, but spelling does

) Also, do you definitely want to be using BOOLEAN MODE? I haven't used MATCH() before, but the docs seemed to suggest that certain words are considered 'key words' and also that small words are ignored. Perhaps using the NATURAL LANGUAGE MODE would be better - but you probably know more about it than me... I got the impression BOOLEAN MODE was for doing clever things like searching for strings which don't have X in but do have Y in

Hope this helps,

iqra · 01-03-2011, 05:58 AM

thnx for the reply Snark1994

out put was "Resource id #5".
and now i changed my code a bit actual there was problem with my other code where i was getting input from previous page.
and i also changed the word AS RELAVENCE. i am using "As score" now... any how thanks for pointing out the error i will remember it for the next tym

now I am getting my desired out put but still along with that output resourceid #5 is coming on a side..

heres my new code that is giving right output..but resourceid #5 along with it!

Code:

 if((!$jobTitle) || ($jobTitle == "")) { $jobTitle = ""; } else { $jobTitle = "+(".$jobTitle.")"; }
   if((!$industry) || ($industry == "")) { $industry = ""; } 
   if((!$stationBase) || ($stationBase == "")) { $stationBase = ""; } else { $stationBase = "+(".$stationBase.")"; }
   if((!$gender) || ($gender == "")) { $gender = ""; } 
   if((!$maritalStatus) || ($maritalStatus == "")) { $maritalStatus = ""; } 

$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)) {
			$memberNo = $row['memberNo'];
			?>

HOPE you got my point what I am trying to ask!!

and about using Boolean mode... you are right about that... but i am using it here to give preference to some words( in match clause) AS in my if conditions I have used + and - signs to those words that must be included in search and words that have less priority relatively.
this is what I Know about using Boolean mode.. I can b wrong here..

Guttorm · 01-03-2011, 09:01 AM

Hi

I'm not sure if I understand, but "resourceid #5" comes from the line "echo $result;". It doesn't make sense to echo a database result, but when you do, the conversation from "resource" to string behaves like that. Just remove that line.

iqra · 01-05-2011, 06:56 AM

waoo thnx Guttorm!

its fine now... Resource ID # is Removed now.!!

Regards!