File : step2crtdb.php. ID : 1503
Skin : Default | Sons-of-obsidian | Sunburst | Highlighter | Frame
<?
require("step1connect.php");
$tb="worker";
$result=mysql_create_db($db,$connect);
echo "Create database perlphpasp (table $tb)";
$query="create table $tb (eid char(4),ename char(40))";
$result=mysql_db_query($db,$query);
$sql="insert into $tb values('1001','Tom')";
$result=mysql_db_query($db,$sql);
$sql="insert into $tb values('1002','Dang')";
$result=mysql_db_query($db,$sql);
$sql="insert into $tb values('1003','Pom')";
$result=mysql_db_query($db,$sql);
mysql_close($connect);
?>