samedi 12 septembre 2015

I cannot use SQL LIKE on php

Cant seem to use like there is always this error anyone can help

Search Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'WHERE des\n\t\t\tLIKE \'%Hgfddfhbb\'\' at line 10\n'

Version: 5.5.44

$search = $json['search'];

        $sql = 
        "SELECT des, lat, lng,
            ( 6371 * acos( cos( radians($lat) ) * 
            cos( radians( lat ) ) * 
            cos( radians( lng ) - radians($lng) ) + 
            sin( radians($lat) ) * 
            sin( radians( lat ) ) ) ) 
        AS distance 
        FROM problem 
        HAVING distance < 5
        WHERE des
        LIKE '%$search%'";

Aucun commentaire:

Enregistrer un commentaire