[SOLVED] create 2 tables

[saltedm8]

i am trying to create 2 tables, the first is my form, and the second is for my login script and then i want to insert data into the members table

PHP: Select all

<?php include 'config.php';?>
<?php
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
$db  = 'CREATE DATABASE '.$dbname;
mysql_select_db($db);
$result = mysql_query($db);
 $db = mysql_select_db($dbname) or die('Cannot select database');
// Create a MySQL table in the selected database
 
    $db="CREATE TABLE form (
        title TEXT NOT NULL,
        date VARCHAR(25) NOT NULL, 
        subject VARCHAR(30) NOT NULL, 
        blog_mes TEXT NOT NULL ) ";
 
  $db="CREATE TABLE `members` (
        `id` int(4) NOT NULL auto_increment,
        `username` varchar(65) NOT NULL default '',
        `password` varchar(65) NOT NULL default '',
         PRIMARY KEY (`id`)
       ) TYPE=MyISAM AUTO_INCREMENT=2" ;
 
    $db="INSERT INTO `members` VALUES (1, 'myusername', 'mypassword')" ;
 
  mysql_query($db) or die (mysql_error());
mysql_close($conn);
?>

the problems i am having are,
if i removed the insert into part, it will only create the members table, but if i leave it on, it wont create my database at all

please advise, thanks

[Rakuli]

take the quotes away from the the table name

eg.

PHP: Select all

$db="INSERT INTO members VALUES (1, 'myusername', 'mypassword')" ; 

You only need the quotes when creating the table, not referencing it.

Hope that helps,

[saltedm8]

tryed that before, that is where i get this

Table 'saltyblog.members' doesn't exist

thats with this

PHP: Select all

<?php include 'config.php';?>
<?php
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
$db  = 'CREATE DATABASE '.$dbname;
$result = mysql_query($db);
 $db = mysql_select_db($dbname) or die('Cannot select database');
// Create a MySQL table in the selected database
 
    $db="CREATE TABLE form (
        title TEXT NOT NULL,
        date VARCHAR(25) NOT NULL, 
        subject VARCHAR(30) NOT NULL, 
        blog_mes TEXT NOT NULL ) ";
 
  $db="CREATE TABLE `members` (
        `id` int(4) NOT NULL auto_increment,
        `username` varchar(65) NOT NULL default '',
        `password` varchar(65) NOT NULL default '',
         PRIMARY KEY (`id`)
       ) TYPE=MyISAM AUTO_INCREMENT=2" ;
 
    $db="INSERT INTO `members` VALUES (1, myusername, mypassword)" ;
 
  mysql_query($db) or die (mysql_error());
mysql_close($conn);
?>

with that, its not creating any database

[Rakuli]

Sorry mate, got a bit confused.

You don't need quotes around *any* table names, even when creating them. Have you tried that?

If you have, still get rid of the quotes and try closing the connection before running your insert query..

PHP: Select all

mysql_close($conn);

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('How many lives?');

mysql_select_db($dbname);



$db="INSERT INTO members VALUES (1, myusername, mypassword)" ; 

[saltedm8]

after a bit of messing around i finally managed it with this

PHP: Select all

<?php include 'config.php';?>
<?php
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
$db  = 'CREATE DATABASE '.$dbname;
mysql_select_db($db);
$result = mysql_query($db);
 $db = mysql_select_db($dbname) or die('Cannot select database');
// Create a MySQL table in the selected database
       $db="CREATE TABLE form (
        title TEXT NOT NULL,
        date VARCHAR(25) NOT NULL, 
        subject VARCHAR(30) NOT NULL, 
        blog_mes TEXT NOT NULL ) ";
  
  $mem="CREATE TABLE members (
  id int(4) NOT NULL auto_increment,
        username varchar(65) NOT NULL default '',
       password varchar(65) NOT NULL default '',
        PRIMARY KEY (id)
      ) TYPE=MyISAM AUTO_INCREMENT=2 ";
   
  mysql_query($db) or die (mysql_error());
  mysql_query($mem) or die (mysql_error());
  mysql_query ("INSERT INTO `members` VALUES (1, 'saltedm8', 'alarm7')");
  
mysql_close($conn);
?>

thanks for your help