Changeset 238 for trunk

Timestamp:

Jul 31, 2009, 8:43:23 AM (15 years ago)

Author:

george

Message:

• Smazáno: Staré již nepoužité tabulky.
• Upraveno: Názvy sloupců v tabulce TKR.

Location:

trunk

Files:

• sql/updates/238.sql (added)
• tkr.php (modified) (1 diff)

trunk/tkr.php

@@ -12 +12 @@
 '<table class="WideTable">'.
 '<tr><th>Číslo</th<th>Jméno stanice</th><th>Frekvence [MHz]</th><th>Jazyk</th></tr>';
-    $DbResult = $this->Database->select('tkr', '*', ' 1 ORDER BY id');
+    $DbResult = $this->Database->select('TKR', '*', ' 1 ORDER BY Id');
     while($Row = $DbResult->fetch_array())
     {
-      $Output .= '<tr><td>'.$Row['id'].'</td><td><a href="'.$Row['www'].'">'.$Row['name'].'</a></td><td align="right">'.($Row['freq']/1000).'</td><td>'.$Row['lang'].'</td></tr>';
+      $Output .= '<tr><td>'.$Row['Id'].'</td><td><a href="'.$Row['Homepage'].'">'.$Row['Name'].'</a></td><td align="right">'.($Row['Frequency'] / 1000).'</td><td>'.$Row['Language'].'</td></tr>';
     }
     $Output .= '</table>Aktualizováno dne 17.12.2007<br></div>';