GoFuckYourself.com - Adult Webmaster Forum - View Single Post - Tech Is there a quicker / easier way to do this?

Azamat · 05-29-2022, 05:01 PM

SELECT COUNT(*) AS Total FROM Recipe WHERE Category REGEXP 'diabetic'" something like this, you are not counting in php or in mysql query of your result. Also double check your REGEXP value is correct. https://www.geeksforgeeks.org/mysql-...ssions-regexp/

echo $data['Total'];

05-29-2022, 05:01 PM
Azamat Confirmed User Industry Role: Join Date: Dec 2018 Location: Ulaanbaatar, Mongolia Posts: 61	SELECT COUNT(*) AS Total FROM Recipe WHERE Category REGEXP 'diabetic'" something like this, you are not counting in php or in mysql query of your result. Also double check your REGEXP value is correct. https://www.geeksforgeeks.org/mysql-...ssions-regexp/ echo $data['Total']; __________________ KVS, Mechbunny, API's, Elevatedx, NATS, dating sites, Symfony, Laravel, LAMP stack development.