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 [2012-03-18 20:36] 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># ev måste ni först köra i UTF8... | ||
+ | SET NAMES utf8 COLLATE utf8_swedish_ci | ||
+ | eller | ||
+ | SET NAMES utf8</ | ||
- Visa alla fåglar | - Visa alla fåglar | ||
Line 86: | Line 90: | ||
<php> | <php> | ||
/* | /* | ||
+ | <code SQL> | ||
1. | 1. | ||
SELECT * FROM Birds; | SELECT * FROM Birds; | ||
Line 122: | Line 127: | ||
GROUP BY UserID | GROUP BY UserID | ||
ORDER BY Antal DESC; | ORDER BY Antal DESC; | ||
+ | </ | ||
*/ | */ | ||
</ | </ | ||