[RESOLVED] annoying warning??

[crazylegseddie]

have a search script that I have inputted at the home of my site and works correctly but with the following script:

$sql = "SELECT pd_id, pd_name, pd_more, pd_more2,  

               MATCH(pd_name, pd_more, pd_more2)  

               AGAINST ('$searchstring' IN BOOLEAN MODE) FROM tbl_product
               WHERE MATCH(pd_name, pd_more, pd_more2)  

               AGAINST ('$searchstring' IN BOOLEAN MODE) ORDER BY pd_name DESC"; 
     }    

     $result = mysql_query($sql) or die (mysql_error()); 

   while($row = mysql_fetch_assoc($result)) 
    { 
      echo "<a href='categories.php?c=0&p=". $row['pd_id']. "'>".stripslashes(htmlspecialchars($row['pd_name'])).'</a><br />'; 
    } 

 

A message saying 'query is empy' is displayed and cancels the rest of my html page. But if i remove 'or die (mysql_error());' then i get the following warning.

'Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result' but the rest of the page now loads correctly.

How do i overcome this problem im having?

Any help will be cool.

[bradgrafelman]

You marked this thread resolved, though there are no replies... did you mean to do that?

As to your question, it looks like the $sql variable isn't getting set properly. Have you tried echo'ing out the $sql variable just before you try to use mysql_query() with it?

EDIT: Looking at the full source from your other post, I think your issue lies with your malformed switch() syntax. In this case, I wouldn't use a switch() at all, but if() statements - ditch the switch() statement, and wrap the entire search SQL and accompanying code in an if statement instead:

$cmd = (isset($_GET['cmd']) ? $_GET['cmd'] : ''); 
if($cmd == '') {

 searchForm();

} elseif($cmd == 'search') {

 // search SQL and whatnot here

}