<?php
# When you're making a script that needs to create tables and/or a database,
# you should put the setup stuff for the database in an installation script
# so that users of the script don't have to know all this stuff...
# 
# You can use this example as a starting point for creating that install script
# Just put in the values for setting up the databases (if necessary) and the
# table(s) your script will need. Once they are created, your script can work
# with whatever's in the tables.
#
# Optional: make a connection to an account which is allowed to create databases.
# You'll need to know the username and password for this account, of course. The
# command you'd use (most likely via telnet or SSH), looks like this: 
#
# $link = mysql_connect("host", "user", "password"); 
#
# Then you use this command to create a new database: 
#
# mysql_create_db("database_name", $link); 
# From here on out, we'll assume that a database exists and that you'll be using
# it in some script(s). So now your script must connect to it. First you assign
# values to the variables that will be used to make the connection:
#
$db_name = "sales_data";
$db_host = "21.41.103.8";
$db_user = "myHandle";
$db_pass = "myPassword";
#
# now you make the connection:
#
$db_conn = @mysql_connect("$db_host", "$db_user", "$db_pass") or die("Couldn't connect to mysql");
#
# and finally you "select" the database
#
$db = @mysql_select_db($db_name, $db_conn) or die("Couldn't select database $db_name");
#
# Now that you have a connection to the desired database, which is probably empty, you'll
# create one or more tables where you'll store some data. Here's a table-creation command:
# Edit the field/column names, data types, etc. as needed. Clone the command and edit the
# copy to create another table, and so on.

$query = "CREATE TABLE pipeline (LoanID INT NOT NULL PRIMARY KEY AUTO_INCREMENT,id
VARCHAR(12) NOT NULL,
LastName VARCHAR(30) NOT NULL,
FirstName VARCHAR(30) NOT NULL,
Address VARCHAR(60) NOT NULL,
City VARCHAR(30) NOT NULL,
State VARCHAR(2) NOT NULL,
AppDate VARCHAR(20) NOT NULL,
Price VARCHAR(12) NOT NULL,
T_Lender VARCHAR(60) NOT NULL,
Lien_Pos VARCHAR(3) NOT NULL,
Type VARCHAR(4) NOT NULL,
Purpose VARCHAR(3) NOT NULL,
Status VARCHAR(3) NOT NULL,
INDEX index1 (id, LoanID, Status))";
$results = mysql_db_query($db_name, $query, $db_conn) or die("Failed to create 'pipeline' table");

# if you get error messages, check your code for typos!
# lather, rinse, repeat...

# if you have other work for the install script to do, put that code here.

?>
# Paste in the HTML code for a simple page that will tell you the script has finished
# setting up the database stuff. Remember, if you want to show any specific results, 
# just plug some "echo" statements into the HTML to show the values of variables.

<?php
# Make sure the script stops running.
die();
?>