1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

PHP - HTML - mysql error

Discussion in 'PHP' started by justineblain, Jul 31, 2012.

  1. #1
    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!!!
     
    justineblain, Jul 31, 2012 IP
  2. justineblain

    justineblain Active Member

    Messages:
    221
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    51
    #2
    Please Help someone help
     
    justineblain, Jul 31, 2012 IP
  3. freenet

    freenet Peon

    Messages:
    21
    Likes Received:
    1
    Best Answers:
    1
    Trophy Points:
    0
    #3
    Can you post the mysql query?
     
    freenet, Jul 31, 2012 IP
  4. justineblain

    justineblain Active Member

    Messages:
    221
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    51
    #4
    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.
     
    justineblain, Jul 31, 2012 IP