phpBB.nl

Code: Selecteer alles

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's', '50')' at line 1

Code: Selecteer alles

$sql = "SELECT id FROM top50info ORDER BY id DESC LIMIT 1";
$result=mysql_query($sql) or die(mysql_error());
if(mysql_num_rows($result))
{
	while ($row1 = mysql_fetch_assoc($result)) 
	{
		$hoogste_id = $row1["id"];
	}
}

$aantal = count($data); // Aantal waarden binnen $aantal array

for($i = 0; $i < $aantal; $i++) 
{

	$user_id = $data[$i]['user_id'];
	$posts = $data[$i]['user_maandscore'];
	$user_name = $data[$i]['username'];
	
  $weeknr = date("W");      
      $sql = "INSERT INTO ". top50uitslag ." (top50id, name, punten, user_name, weeknr) VALUES ('$hoogste_id', '$user_id', '$posts', '$user_name', '$weeknr')";   
$result=mysql_query($sql) or die(mysql_error());	
}

Code: Selecteer alles

INSERT INTO ". top50uitslag ."