Jump to content
Sign in to follow this  
splreece-1450516766

custom where using custom fields

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.

Share this post


Link to post
Alejandro

This section is only visible with a valid subscription. If you have a valid subscription, please login.

Share this post


Link to post
Sign in to follow this  

×
×
  • 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.