Problem in getting query result

[harikr]

hi,

 

I am sending this string "ratings&reviews-projects" and trying the query for this string.I have encoded this string using encodeURIComponent() in javascript and it is sending the string perfectly to my php script. But i dont know why my query is not displaying anything evnthough the query has results.

 

Here is my code,

 

<?php

$prod=$_REQUEST['listPrdMenu'];

$result=mysql_query("SELECT name from components WHERE product_id=(SELECT id from products WHERE name='$prod')");

?>

<select name="compDetails[]" id="compDetails" size=7 class="style7" multiple >

<option value="">- Select -</option>

<?php

while ($row = mysql_fetch_row($result))

      {

        echo "<option>{$row[0]}</option>\n";

      }

?>

</select>

[getmukesh]

Let us try this query, i have replaced "in" instead of "="

 

SELECT name from components WHERE product_id in (SELECT id from products WHERE name='$prod')

 

Try this, i think it will solved the problem.

[harikr]

Sorry man my problem is it is not producing results for that string alone eventhough there are results. For other strings it is working fine