3 Posts
2 years ago

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 VIP membership
120 Posts
2 years ago
Level 1

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

Best regards

Get a VIP membership