Dumping Data into mySQL using PHP

$albumName = $_POST['albumName'];
//$albumName = $_POST['albumName'];
 
 
$result="CREATE TABLE ".$albumName." (id int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),albumName varchar(100) default NULL,imageName varchar(100) default NULL,imageText varchar(100) default NULL)";  
mysql_query("INSERT INTO $albumname (albumName, imageName, imageText)
VALUES ('test', 'test2', 'test3')");
 
 
if(mysql_query($result))
{
   echo("Error:".mysql_error()." For query:".$result);
} else { 
if($result) echo "writing=Ok&";
   else echo "writing=Error";
   }
   
   
   //$albumName = "testdir";  
mkdir("http://www.previewsample.com/album/" . $albumName . "/"); 
if(mkdir($albumName)){
echo 'successfully created directory';
} else {
die('problem creating directory'); 
}
?>  
                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:

<?php
$connect = mysql_connect("dxxxxx", "dxxxxxxx", "gxxxxxxxxx");
   mysql_select_db ("xxxxxxxxxx", $connect); 
 
 
$albumName = $_POST['albumName']; 
 
 
$result="CREATE TABLE ".$albumName." (id int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),albumName varchar(100) default NULL,imageName varchar(100) default NULL,imageText varchar(100) default NULL)"; 

$sql = "INSERT INTO users (name,city,web,age) VALUES ('Tom','Vegas','www.tom.com',5)";
$result = mysql_query($sql); 
mysql_query("INSERT INTO $albumName (albumName, imageName, imageText)
VALUES ('Peter', 'Griffin', '35')"); 
if($result) echo "writing=Ok&"; 
else echo "writing=Error";  
if(mysql_query($result)) 

mkdir("http://www.previewsample.com/album/" . $albumName . "/",0777); 
if(mkdir($albumName)){
echo 'successfully created directory';
} else {
die('problem creating directory'); 
}
?>  

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:

<?php
$connect = mysql_connect("dcccccc", "cccccccccc", "ccccccc");
   mysql_select_db ("cccccccccc", $connect); 
 
 
$albumName = $_POST['albumName']; 
 
 
$result="CREATE TABLE ".$albumName." (id int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),albumName varchar(100) default NULL,imageName varchar(100) default NULL,imageText varchar(100) default NULL)"; 
  
if($result) echo "writing=Ok&"; 
else echo "writing=Error";  
if(mysql_query($result))  
mkdir("http://www.previewsample.com/album/" . $albumName . "/",0777); 
if(mkdir($albumName)){
echo 'successfully created directory';
} else {
die('problem creating directory'); 
}
?>       

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21: