Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
u5_databaser [2009-11-10 13:44] Joakim Forsgren |
u5_databaser [2009-11-10 13:50] Joakim Forsgren |
||
|---|---|---|---|
| Line 5: | Line 5: | ||
| Följande tabeller finns i databasen jf_select (i princip lika i varje fall…) \\ | Följande tabeller finns i databasen jf_select (i princip lika i varje fall…) \\ | ||
| {{: | {{: | ||
| + | <code SQL># kör först | ||
| + | SET NAMES utf8 COLLATE utf8_swedish_ci</ | ||
| - Visa alla fåglar | - Visa alla fåglar | ||
| Line 86: | Line 88: | ||
| <php> | <php> | ||
| /* | /* | ||
| + | <code SQL> | ||
| 1. | 1. | ||
| SELECT * FROM Birds; | SELECT * FROM Birds; | ||
| Line 122: | Line 125: | ||
| GROUP BY UserID | GROUP BY UserID | ||
| ORDER BY Antal DESC; | ORDER BY Antal DESC; | ||
| + | </ | ||
| */ | */ | ||
| </ | </ | ||