3 Posts
mattjohn
2 years ago
1
Topic

I am wanting to restrict a field based on another field value being greater then 200, I also have the field restriction plugin, but can only do greater than if by date not by field value:

At the moment I have the following:

SELECT price FROM #__content WHERE price = >200;

But this does not work, and have error in sql on front end :(

I have a price column in my content table, and i want to restrict a field from showing in the content view if the price is 200 or greater

Any ideas would be really helpful x

Get a Book for SEBLOD
134 Posts
root
2 years ago
0
Level 1

Try with >= for greater than or equal operator in mysql

Best regards

Get a VIP membership