Setting up a mysql table on Web Host

[John123]

I was wondering how I can set up a mysql Database to hold some info on my web host, it supports php and mysql etc, I just dont know how to create the table.
the table should be called users and should hold username email and password. can anyone help plz 😕

[cgraz]

<?

// Connect to MySQL Server
@mysql_connect($server, $username, $password) or DIE("Couldn't Connect to MySQL Database");

// Select Database
@mysql_select_db($database) or DIE("Couldn't Select Database");

// Create Table

$query = mysql_query("CREATE TABLE users (  

  id int(11) DEFAULT '' NOT NULL auto_increment, 
  username varchar(20) NOT NULL default '',
  email varchar(30) NOT NULL default '', 
  password varchar(20) NOT NULL default '',   

  PRIMARY KEY (id))");

echo "installation complete";

?>

Save this as table.php. Replace $server, $username, $password and $database with your mysql info (if you use variables, just set values for the variables. If you put the actual info into the parenthesis, make sure to use single quotes

mysql_connect('localhost', 'username', 'password');

as opposed too

mysql_connect($server, $username, $password);

Cgraz

[John123]

thx it worked 😃