Medal Assignment
MEDAL TALLY
🏅 Medal Tally - Sports Event
| Country/Team | Gold 🥇 | Silver 🥈 | Bronze 🥉 | Total 🏆 |
|---|---|---|---|---|
| Malaysia | 5 | 3 | 2 | |
| Thailand | 2 | 4 | 5 | |
| Indonesia | 3 | 2 | 1 |
KEPUTUSAN
defined('_JEXEC') or die; $db = JFactory::getDbo(); // Example Query - Get Athlete Names $query = $db->getQuery(true); $query->select($db->quoteName('name')) ->from($db->quoteName('#__athletes')) ->order($db->quoteName('name') . ' ASC'); $db->setQuery($query); $results = $db->loadColumn(); // Output echo "
- ";
foreach ($results as $name) {
echo "
- " . htmlspecialchars($name) . " "; } echo "