Script loopt vast in While
Script:
/// make a MySQL connection
$user = "root";
$pass = "root";
$Datum = "1990-01-01";
$Open = 0;
$tel = 0;
$Jaar = "2007";
$Jaar2 = "2007";
mysql_connect ("localhost:3306",$user,$pass) or die (mysql_error());
mysql_select_db("DAX Elixer") or die (mysql_error());
// Get all data from the database DAX Elixer
$result = mysql_query("SELECT * FROM Tickdata WHERE Datum >= '$Jaar-03-01' AND Datum < '$Jaar2-04-01'") or die (mysql_error());
while($row = mysql_fetch_array( $result ))
{
if ($Datum <> $row['Datum'])
{
$Datum = $row['Datum'];
$Open = 0;
$OptelID = $row['ID'];
$Optel = $row['Volume'];
}
if ($row['Tick'] == $Open)
{
$id = $row['ID'];
mysql_query("UPDATE Tickdata SET Trade = '555' where ID = $id");
$Optel = $Optel + $row['Volume'];
}
elseif ($row['Tick'] <> $Open)
{
$Open = $row['Tick'];
mysql_query("UPDATE Tickdata SET Volume = $Optel where ID = $OptelID");
$OptelID = $row['ID'];
$Optel = $row['Volume'];
}
}
echo "Klaar , $Jaar";
Wat doet die 2 daar?
