How to Insert More Tables!

[m92g11]

I want to add another table with more fields. How do I do this with the code below?

<?php
require_once("../config.php");

$connect = mysql_connect("$database_host", "$database_username", "$database_password") or die(mysql_error());
mysql_select_db("$database_name") or die(mysql_error());

[B]// Create table
mysql_select_db("$database_name", $connect);
$sql = "CREATE TABLE users
(
first_name varchar(15),
last_name varchar(15),
user_login varchar(15),
user_pass varchar(15),
blog_name varchar(15),
user_email varchar(15)
)";[/B]

// Execute query
mysql_query($sql,$connect);

mysql_select_db("$database_name", $connect);

$sql="INSERT INTO users (first_name, last_name, user_login, user_pass, blog_name, user_email)
VALUES
('$_POST[first_name]','$_POST[last_name]','$_POST[user_login]','$_POST[user_pass]','$_POST[blog_name]','$_POST[user_email]')";

if (!mysql_query($sql,$connect))
  {
  die('Error: ' . mysql_error());
  }
echo "Record's Have Been Added";

mysql_close($connect)
?>

[dagon]

your create table syntax is fine, what's the error?

also 15 is way to short for most of those fields.

[Channel5]

Maybe I don't understand what you want, but wouldn't you do it basically the same as your code above?

Just repeat the basic code but change the table name and fields to what you want.