Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with mysql
Search options answers only
not deleted
user 154
MySQL is a database system used by many websites on the Internet. Joomla is based on PHP and MySQL.
2
votes
Accepted
Ordering a UNION
It's currently not possible to apply set functions like ORDER BY, HAVING or GROUP BY to UNION queries, see https://github.com/joomla/joomla-cms/issues/6789.
But you can build your query a little diff …
- 3,733
2
votes
Accepted
Database datatype for Joomla Standard Form Field "usergrouplist"
The usergrouplist is just a list of user group IDs in Joomla.
If you're going to save a single user group ID then any INT type (e.g. SMALLINT) should be fine.
However you can use this field (as any …
- 3,733
2
votes
Accepted
How can I modify/control the HTML output of my Module?
case 'image':
$result = '<img src="' . $field_value . '" />';
break;
How about this for example?
- 3,733
2
votes
How to refactor my iterated sequence of queries?
At least I see a way how to combine your first 2 select queries into one with the help of SQL JOIN:
$query->select('sid')->from('#__student')->where('id = '.$pk);
$db->setQuery($query);
$sid = …
- 3,733
2
votes
Accepted
Transforming a Query for JDATABASE
$query = $db->getQuery(true);
$query->select($db->quoteName(array('artist', 'title')));
$query->select('COUNT(*) AS tracks');
$query->from($db->quoteName('history'));
$query->where('TIMESTAMPDIFF(DAY, …
- 3,733