×
Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues
Select row where field contains certain values
Jan van de Laar
New Member
Posts: 5
10 года 4 дн. назад #460
от Jan van de Laar
Jan van de Laar создал тему: Select row where field contains certain values
Hi All
I've built a component with two tables, one of them is named 'categorie'. I can select more than one. In the database there is a field "categorie" and it contains " 1, 3 ". So this row matches with categories 1 and 3.
Now I want to select the proper rows in my frontend view and I want to use this where clause:
But this only works with value 1, when I try value 3 there are no database results. I tried using LIKE but that doen't work either. Can someone please help me with this?
I've built a component with two tables, one of them is named 'categorie'. I can select more than one. In the database there is a field "categorie" and it contains " 1, 3 ". So this row matches with categories 1 and 3.
Now I want to select the proper rows in my frontend view and I want to use this where clause:
$query->where($db->quoteName('categorie') . ' = 1 ');But this only works with value 1, when I try value 3 there are no database results. I tried using LIKE but that doen't work either. Can someone please help me with this?
Пожалуйста Войти или Регистрация, чтобы присоединиться к беседе.
Jan van de Laar
New Member
Posts: 5
10 года 4 дн. назад #461
от Jan van de Laar
Jan van de Laar ответил в теме Select row where field contains certain values
Just found the solution:
// Construct the search term by escaping the user-supplied string and, if required, adding the % wildcard characters manually.
// Construct the SQL query
// Construct the search term by escaping the user-supplied string and, if required, adding the % wildcard characters manually.
$cat = '%' . $db->escape( $cat, true ) . '%' ;// Construct the SQL query
$query = 'SELECT * FROM #__table WHERE `categorie` LIKE ' . $db->quote( $db->escape( $cat ), false );Пожалуйста Войти или Регистрация, чтобы присоединиться к беседе.
Время создания страницы: 0.053 секунд