<?php
include "dbconf.php";
if(mysql_connect($db_hostname,$db_username,$db_password) && mysql_select_db($db_database))
{
$query = "DELETE FROM `defence_player` WHERE 1;";
if(!mysql_query($query))
{
$query = "CREATE TABLE defence_player (
id INT(2) UNSIGNED PRIMARY KEY,
room INT(2),
row INT(2),
col INT(2)
)";
mysql_query($query);
}
for($i=1;$i<10;$i++)
{
$query = "INSERT INTO `defence_player` (`id`, `room`, `row`, `col`) VALUES ('$i', '$i', '9', '5');";
echo $query.'<br>';
mysql_query($query);
}
for($i=10;$i<=50;$i++)
{
$query = "INSERT INTO `defence_player` (`id`, `room`, `row`, `col`) VALUES ('$i', '$i', '9', '5');";
echo $query.'<br>';
mysql_query($query);
}
}
?>