01.<?php
02.$strSQL = "SELECT * FROM member WHERE Username = '".$_POST['txtUsername']."' ";
03.echo $strSQL;
04.die();
05.$objQuery = mysql_query($strSQL);
06.$objResult = mysql_fetch_array($objQuery);
07.if(!$objResult)
08.{
09.$strSQL2 = "INSERT INTO member (Username, Password, Name, Status) VALUES ('".$_POST['txtUsername']."', '".$_POST['txtPassword']."', '".$_POST['txtName']."', 'USER')";
10.$objQuery2 = mysql_query($strSQL2)
11.
12.$strSQL3 = "CREATE TABLE ".$_POST["txtUsername"]." (UserID VARCHAR NOT NULL,
13.CourseID VARCHAR(20),
14.CourseName VARCHAR(200),
15.Tutor VARCHAR(20),
16.CourseTime VARCHAR(100),
17.Status ENUM('Active','Expired') DEFAULT Active,
18.Expired DATE,
19.PRIMARY KEY(CourseID)
20.)";
21.$objQuery3 = mysql_query($strSQL3)
22.
23.if ($objQuery2 && $objQuery3){
24.echo "บันทึกข้อมูลเรียบร้อยแล้วครับ!";
25.} else {
26.echo "Error creating table";
27.}
28.}
29.mysql_close();
30.?>
