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 22
MySQL is a database system used by many websites on the Internet. Joomla is based on PHP and MySQL.
4
votes
Accepted
Database query outputting twice
You are likely getting duplicate items because of the join of the categories table. And since you don't actually select anything from the categories table, why not just do this:
$database->setQuery(" …
- 4,066
4
votes
Accepted
How to sort my query's results by publish_up value?
There are probably other differences (or maybe not: https://stackoverflow.com/questions/2193049/php-objects-vs-arrays) between objects and arrays, but it is mostly a style difference (at least when us …
- 4,066
8
votes
Accepted
Two left join in one query to Joomla database
$db = JFactory::getDBO();
$query = $db->getQuery(true);
$query->select('a.id, a.name, c.id as parent_id, c.name as parent_name')
->from('#__records as a');
$query->select('b.parent as parentid');
…
- 4,066