I have a list menu and depending on its value the search is done, the gets redirected to itself by The table name is package_mst and one of the column name is Adventure also another is status(which may be 1 or 0 - but that is not an issue) The problem is: when i submit search button it shows me this error my list box coding is this: <select name="mnusearch" id="mnusearch"> <option <?php if (isset($_REQUEST['mnusearch']) && $_REQUEST['mnusearch']=="") { ?> selected="selected" <?php } ?> value="" >All</option> <option <?php if (isset($_REQUEST['mnusearch']) && $_REQUEST['mnusearch']==" and p_adventure='Adventure'") { ?> selected="selected" <?php } ?> value=" and p_adventure='Adventure'">Adventure</option> </select> HTML: when i run it on localhost , it runs perfect , but after uploading to server it shows me the above error, Can anyone tell me why is it showing such error!!!
Problem Solved I apply $string=stripslashes($string); function to remove slash from the string . @ freenet : The Mysql query is : select * from package_mst where p_type='Domestic' and p_status=1 and p_adventure=\'Adventure\' order by p_id desc BTW thanks for taking interest.. Regards.