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 database
Search options not deleted
user 7730
A database is an organized collection of data typically used to model certain situations. Use this tag if you have questions about designing a database. If it is about a particular database management system, (e.g., MySQL), please use that tag instead.
1
vote
Accepted
Build a query with JOIN, but filter and sort that joined table first
If all you are wanting to do is add the WHERE clause that is no different than any other DB Query for Joomla. You will need to group things by your user and query the MIN price. The example below shou …
- 1,834
2
votes
Accepted
select data from several tables in one query - how to control JOIN?
Joomla doesn't handle subqueries very well since there is no real $query->subQuery method. In this instance it is easiest to format the query as a standard MySQL query and let Joomla process the resul …
- 1,834
1
vote
Preprocessing form data before saving to the database
Have you tried retrieving the form input directly without using JFilterInput?
Try this:
replace:
$filter = JFilterInput::getInstance();
with:
$dancers = $input->get('dancer','','array');
you …
- 1,834
1
vote
Accepted
Get user id from user form field type
Here is the code you would put in your models/forms XML file:
<field
name="modified_user_id"
type="sql"
label="JGLOBAL_FIELD_MODIFIED_BY_LABEL"
description="Assign …
- 1,834
0
votes
UPDATE query to add 1 to multiple columns
Change the following:
$playername = $jinput->getString('playername');
to:
$playername = $jinput->get('playername','','array');
That should give you an array with all of the names you enter into …
- 1,834
2
votes
Accepted
custom table display - help turning static html to dynamic php
The jQuery function was operating against all elements with the assigned target class. The result of that was all dropdowns opening simultaneously. The resolution was to assign a unique ID to each of …
- 1,834