MySQL search not working

Discussion in 'MySQL' started by smudger, Jan 18, 2009.

0
  1. #1
    Hi, we have just moved our website to a new server, and since moving the site our searches no longer return any results

    the select looks like this

    $search = "SELECT * FROM kidz WHERE category LIKE '%$category%' AND licence_details LIKE '%$licence_details%'

    nothing has been changed to the websites code ... so i guess it is not working because of a newer version of MySQL / PHP - but how can i get things working again ?
     
    smudger, Jan 18, 2009 IP
  2. smudger

    smudger Active Member

    Messages:
    258
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    58
    #2
    hi !

    its ok i have sorted it, and working now

    i simply had to declare the variables

    $category = $_POST['category'];
    $licence_details = $_POST['licence_details'];

    etc
     
    smudger, Jan 18, 2009 IP