<?
$sql_usr="_$email";
$sql_usr1="$ownername$sql_usr";

$conn2  = mysql_connect($dbhost, $sql_usr1, $password) or die(mysql_error( ));
mysql_select_db($sql_usr1,$conn2) or die(mysql_error( ));


$get_items="CREATE TABLE `countries` (
  `CountryId` tinyint(4) NOT NULL auto_increment,
  `Country` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`CountryId`)
);" ;
$get_items_res=mysql_query($get_items)  or die(mysql_error( ));



$get_items="INSERT INTO `countries` VALUES (1, 'Algeria');" ;
$get_items_res=mysql_query($get_items)  or die(mysql_error( ));
$get_items="INSERT INTO `countries` VALUES (2, 'Argentina');" ;
$get_items_res=mysql_query($get_items)  or die(mysql_error( ));
$get_items="INSERT INTO `countries` VALUES (3, 'Philippines');" ;
$get_items_res=mysql_query($get_items)  or die(mysql_error( ));
$get_items="INSERT INTO `countries` VALUES (4, 'USA');" ;
$get_items_res=mysql_query($get_items)  or die(mysql_error( ));
$get_items="INSERT INTO `countries` VALUES (5, 'China');" ;
$get_items_res=mysql_query($get_items)  or die(mysql_error( ));
$get_items="INSERT INTO `countries` VALUES (6, 'Malaysia');" ;
$get_items_res=mysql_query($get_items)  or die(mysql_error( ));
$get_items="INSERT INTO `countries` VALUES (7, 'Singapore');" ;
$get_items_res=mysql_query($get_items)  or die(mysql_error( ));
$get_items="INSERT INTO `countries` VALUES (8, 'Thailand');" ;
$get_items_res=mysql_query($get_items)  or die(mysql_error( ));
$get_items="INSERT INTO `countries` VALUES (9, 'Japan');" ;
$get_items_res=mysql_query($get_items)  or die(mysql_error( ));
$get_items="INSERT INTO `countries` VALUES (10, 'Singapore');" ;
$get_items_res=mysql_query($get_items)  or die(mysql_error( ));
$get_items="INSERT INTO `countries` VALUES (11, 'India'); " ;
$get_items_res=mysql_query($get_items)  or die(mysql_error( ));
$get_items="INSERT INTO `countries` VALUES (12, 'Russia');" ;
$get_items_res=mysql_query($get_items)  or die(mysql_error( ));



$get_items="CREATE TABLE `myphpguest` (
  `GuestId` int(11) NOT NULL auto_increment,
  `GuestName` varchar(50) NOT NULL default '',
  `GuestEmail` varchar(50) default NULL,
  `GuestURL` varchar(50) default NULL,
  `GuestMessage` text NOT NULL,
  `GuestEntry` date NOT NULL default '0000-00-00',
  `CountryId` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`GuestId`)
);" ;
$get_items_res=mysql_query($get_items)  or die(mysql_error( ));

$get_items="INSERT INTO `myphpguest` VALUES (55, 'Ramil Alcibar', 'webmaster@triphp.com', 'http://www.triphp.com', 'Another test on fixing the layout bug. If a user enters a very long word, let\'s break it into smaller one to avoid destruction of the layout. Tesssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssst', '2005-04-24', 3);" ;
$get_items_res=mysql_query($get_items)  or die(mysql_error( ));
$get_items="INSERT INTO `myphpguest` VALUES (56, 'Ramil Alcibar', 'webmaster@triphp.com', 'http://www.triphp.com', 'Alright! Seems that all major functionality are fixed. HTML code is disabled, long word will be break into maximum of 15 cahracters, pagination is also fixed, email and web links are fixed. It\'s great. What are the remaining bugs? Mostly JavaScript so I will give this task to anyone who use this script. What I mean is Email and URL has no format checking. I\'m not realyy good at JavaScript so play with it with your own. :( =boggle =cool ;) =rolleyes :) =razz :D =lol', '2005-04-24', 3);" ;
$get_items_res=mysql_query($get_items)  or die(mysql_error( ));
$get_items="INSERT INTO `myphpguest` VALUES (53, 'Ramil Alcibar', 'webmaster@triphp.com', 'http://www.triphp.com', 'MyPHPGuest 1.1 officially released. Has a little bug fixes and added some features. :)', '2005-04-24', 3);" ;
$get_items_res=mysql_query($get_items)  or die(mysql_error( ));
$get_items="INSERT INTO `myphpguest` VALUES (54, 'Ramil Alcibar', 'webmaster@triphp.com', 'http://www.triphp.com', 'Test on fixing the bug. Disallowing input of HTML code. Example: &lt;table&gt;&lt;tr&gt;&lt;/tr&gt;&lt;td&gt;&lt;/td&gt; that could destory layout of the output. :p', '2005-04-24', 3);" ;
$get_items_res=mysql_query($get_items)  or die(mysql_error( ));
$get_items="INSERT INTO `myphpguest` VALUES (59, 'Ramil Alcibar', 'webmaster@triphp.com', 'http://www.triphp.com', 'One thing also is the countries list. Just add other countries not mentioned below. The table name is `countries`. Just used phpMyAdmin or similar tools to add missing countries. And no changes on the Admin Panel coz it\'s hidden by the ordinary visitors. [B][U][I]Thanks to everyone! [/I][/U][/B] :)', '2005-04-24', 3);" ;
$get_items_res=mysql_query($get_items)  or die(mysql_error( ));

mysql_close($conn2);
    ?>