[ultra-net]

i got this coding for creating some part of a database

<?
$user="username";
$password="password";
$database="database";
mysql_connect(localhost,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="CREATE TABLE contacts (id int(6) NOT NULL auto_increment,first varchar(15) NOT NULL,last varchar(15) NOT NULL,phone varchar(20) NOT NULL,mobile varchar(20) NOT NULL,fax varchar(20) NOT NULL,email varchar(30) NOT NULL,web varchar(30) NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))";
mysql_query($query);
mysql_close();
?>

thast all very well, but i stil dont know how to actully make one and put things wherever they go. could someone maybe give me an example of one set-up or some help for this. thanks, and please someone repaly, none of my essages have been replied to yet on other boards

[1jetsam]

Code:

<?php
define('SQL_HOST','localhost');
define('SQL_USER','****');
define('SQL_PASS','****');
define('SQL_DB','****');

$conn = mysql_connect(SQL_HOST,SQL_USER,SQL_PASS)
  or die('A connection error occurred (1): ' . mysql_error());

mysql_select_db(SQL_DB,$conn)
  or die('A connection error occurred (2): ' . mysql_error());

$bank = "CREATE TABLE bank (
  bank_id int(11) NOT NULL auto_increment,
  bank_amount int(11) NOT NULL,
  bank_username text NOT NULL,
  bank_date datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY (bank_id)
)";
$results8 = mysql_query($bank) or die (mysql_error());
echo "Successfully created!";
?>

There is some copy and paste for you, just slightly edited.

[subnet_rx]

I'd look at some tutorials and there are many on the web about PHP/MySQL

[FiRe]

custom coding: jas[at]programmer[dot]net