php - WHERE clause not working, code sample included -

php - WHERE clause not working, code sample included -

i have mysql query below. works fine.

$query = sprintf("select id, name, fee, lat, lng, ( 3959 * acos( cos( radians('%s') ) * cos( radians( lat ) ) * cos( radians( lng ) - radians('%s') ) + sin( radians('%s') ) * sin( radians( lat ) ) ) ) distance markers having distance < '%s' order distance limit 0 , 20", mysql_real_escape_string($center_lat), mysql_real_escape_string($center_lng), mysql_real_escape_string($center_lat), mysql_real_escape_string($radius));

i'm trying add together where clause follows , not working

$query = sprintf("select id, name, fee, lat, lng, ( 3959 * acos( cos( radians('%s') ) * cos( radians( lat ) ) * cos( radians( lng ) - radians('%s') ) + sin( radians('%s') ) * sin( radians( lat ) ) ) ) distance markers show <> 0 having distance < '%s' order distance limit 0 , 20", mysql_real_escape_string($center_lat), mysql_real_escape_string($center_lng), mysql_real_escape_string($center_lat), mysql_real_escape_string($radius));

show field acts flag. if contains 0, record ignored in above query. show defined tinyint(1) in mysql database.

may it's backtick issue :

i've surrounded word 'show' backtick. here's query part. seek this.

select id, name, fee, lat, lng, ( 3959 * acos(cos(radians('%s')) * cos(radians(lat)) * cos( radians(lng) - radians('%s')) + sin (radians('%s')) * sin(radians(lat))) ) distance markers `show` <> 0 having distance < '%s' order distance limit 0, 20

edit :

backticks used table , column identifiers, necessary when identifier mysql reserved keyword, or when identifier contains whitespace characters or characters beyond limited set. recommended avoid using reserved keywords column or table identifiers when possible, avoiding quoting issue.

php mysql