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 | ||
u4_databaser [2011-03-30 10:13] Joakim Forsgren |
u4_databaser [2011-03-30 10:47] Joakim Forsgren |
||
---|---|---|---|
Line 10: | Line 10: | ||
for($i=0; $i< | for($i=0; $i< | ||
$sql = " | $sql = " | ||
- | $sql = " | ||
- | VALUES (DATE_ADD(' | ||
- | |||
mysql_query($sql); | mysql_query($sql); | ||
} | } | ||
?> | ?> | ||
</ | </ | ||
+ | <php> | ||
+ | // $sql = " | ||
+ | </ | ||
+ | |||
Tips! DATE_ADD, RAND, ROUND | Tips! DATE_ADD, RAND, ROUND | ||
Line 49: | Line 50: | ||
+------+-----------------+-------+ | +------+-----------------+-------+ | ||
</ | </ | ||
+ | |||
<php> | <php> | ||
- | <? | ||
/* | /* | ||
SELECT YEAR(DateTime) AS Year, AVG(Temp) AS avg_TEMP, COUNT(ID) AS Antal FROM Dates | SELECT YEAR(DateTime) AS Year, AVG(Temp) AS avg_TEMP, COUNT(ID) AS Antal FROM Dates |