is it correct? ...AS a WHERE...
-
New Commercial Services Section
We have now opened a commercial services section here on the forum for registered users. If you have a Fabrik project that you wish to have someone work on for you, post it under Help Wanted. If you are an application developer and wish to earn some money helping others, post your details under Fabrik Application Developers.
Both of these are unmoderated. It will be up to both parties to work out the details and come to an agreement.
-
Joomla 5.1
For running J!5.1 you must https://fabrikar.com/forums/index.php?wiki/update-from-github/ or include the new file manually https://fabrikar.com/forums/index.php?threads/joomla-5-1-and-fabrik-cannot-find-files-error.54473/post-285151 See also Announcements
Database join question...
- Thread starter frullix
- Start date
juuser
Well-Known Member
Unfortunately I'm not too good at writing code from just a top of my head without being in a real test environment.
You should also be able to have a single query inside loop like:
but then you need to handle the cases where there are different amount of qualificatiozes per athlete.
So you could do it with multiple queries inside loop like:
etc.
And then do your "if else".
You should also be able to have a single query inside loop like:
Code:
SELECT fs_score, qualificazione FROM scheda_atleta WHERE atleta = " . $mydb->Quote($myresult->id)." ORDER BY qualificazione ASC
$myscore = $mydb->loadObjectList();but then you need to handle the cases where there are different amount of qualificatiozes per athlete.
So you could do it with multiple queries inside loop like:
Code:
SELECT fs_score FROM scheda_atleta AS a WHERE qualificazione = 1 AND atleta = " . $mydb->Quote($myresult->id)
$myscore1 = $db->loadResult(); //returns one value, players score at qualificazione 1
SELECT fs_score FROM scheda_atleta AS a WHERE qualificazione = 2 AND atleta = " . $mydb->Quote($myresult->id)
$myscore2 = $db->loadResult();etc.
And then do your "if else".