<?php

$user[0]["username"] = "jhdithmar";
$user[0]["password"] = "testpwd";
$user[0]["user_name"] = "Dithmar";
$user[0]["user_gname"] = "Jan Hendrik";

$connectionID = mysql_connect($hostname,$username,$password);
if(!mysql_select_db($database, $connectionID))
{
	die ("Connection failed.");
}

mysql_query ("DELETE * FROM userdata");

while(list ($key,$value) = each ($user))
{
	$sql = "INSERT INTO userdata (username, password, name, gname) ".
			"VALUES ('".$value["username"]."', '".md5($value["password"])."', '".$value["user_name"]."', '".$value["user_gname"]."')";
	mysql_query($sql);
	
	if(mysql_affected_rows($connectionID) > 0)
	{
		echo "User created successfully.<br>\n";
	}
	else
	{
		echo "Creating user failed.<br>\n";
	}
}

mysql_close($connectionID);

?>