Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision Both sides next revision
u4_databaser [2011-03-30 10:32]
Joakim Forsgren 		u4_databaser [2011-03-30 10:47]
Joakim Forsgren
Line 9: Line 9:
 // Ni måste ju koppla upp er mot databasen mm... // Ni måste ju koppla upp er mot databasen mm...
 for($i=0; $i<100000; $i++) { for($i=0; $i<100000; $i++) {
-    //$sql =  "INSERT INTO `Dates` (`DateTime` ,`Temp`) VALUES (...resten ska ni göra själva..."; +    $sql =  "INSERT INTO `Dates` (`DateTime` ,`Temp`) VALUES (...resten ska ni göra själva...";
-    $sql = "INSERT INTO `Dates` (`DateTime` ,`Temp`)  +
-    VALUES (DATE_ADD('1970-01-01 00:00:00',INTERVAL " .($i*5). " HOUR),ROUND(RAND()*20))"; +
     mysql_query($sql);     mysql_query($sql);
 } }
 ?> ?>
 </code> </code>
 +<php>
 +//    $sql = "INSERT INTO `Dates` (`DateTime` ,`Temp`) VALUES (DATE_ADD('1970-01-01 00:00:00',INTERVAL " .($i*5). " HOUR),ROUND(RAND()*20))";
 +</php>
 +
  
 Tips! DATE_ADD, RAND, ROUND Tips! DATE_ADD, RAND, ROUND