It seems like whenever I try to edit user_email int in insert.php, my script creates the tables, but does not insert the data entered in from the form. Now I know it does work, because of previous tries. But the data just doesn't show up. And its just stuck there. What I'm wanting to do is create another table called posts, with more fields. Any help would be greatly appreciated!!!
Thanks in Advance!
- Michael!
insert.php
<?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());
// 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 int
)";
// 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]')";
require_once ("done.php")
?>
