Hi, what is the right way to translate this: SELECT COUNT(DISTINCT column) FROM table into kirby database class? This: $db->table('table')->select('column')->distinct()->count(); not work…:frowning: Thanks!

Select distinct on database

texnixe March 29, 2018, 2:25pm 6

Yes, but using the query method is fine, I think, as long as you use placeholders for user data and as long as you don’t manually concatenate user input, see also these topics:

Using db::query with prepared statements?
Do Kirby's MySQL methods protect against injection attacks?

1 Like

Topic		Replies	Views
Database: number of rows when using Db::select? Solved ✅	3	228	March 18, 2021
Mysql query, successful? Solved ✅	3	785	September 23, 2016
MySQL and more complex queries Solved ✅	2	1406	March 30, 2015
Database select and group Questions 🤔	0	213	August 11, 2020
Using db::query with prepared statements? Solved ✅	3	988	November 15, 2017

Select distinct on database

Related Topics