Jump to content

custom where using custom fields


splreece-1450516766

Recommended Posts

splreece-1450516766

hi all, 

 

just a quick one, i am getting a syntax error on the following where.. (its a guess).

 

 

I have a custom field that lists all accessibility tags of a list and all i want to do is create a button of 'similar listings' based on geolocation to current listing and also to its already selected accessibility tags.

 

Ideally the tags would come from the user selected tags rather than the listed tags (user may select 1 tag however list may have 5 so i would prefer to use the 1 tag).

 

Am i right in thinking the where is simply  Field.jr_accessibility = {user_jr_accessibility}    

 

Error message is ----- but works when i remove the WHERE clause

1064

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '} ) ) ORDER BY Totals.user_rating DESC, Totals.listing_id DESC LIMIT 10' at line 79

The page you are looking for does not exist or an other error occurred.

Link to post
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Please refer to our Privacy Policy.