Help with Creating a MySQL table in PHP...

[Drags111]

Hello everyone, I am trying to make a table for my MySQL db. I have the info for creating the table here:

 

CREATE TABLE `members` (
  `user_id` mediumint( NOT NULL auto_increment,
  `username` varchar(25) NOT NULL default '',
  `user_password` varchar(32) NOT NULL default '',
  `user_email` varchar(255) NOT NULL default '',
    PRIMARY KEY  (`user_id`)
) TYPE=MyISAM AUTO_INCREMENT=60 ;

 

How would I go about doing this? Thanks for all suggestions.

[mybluehair]

ok. heres what to do. start a php file.

here are the codes:

 

 

<?php

$database = "yourDB";

$username = "yourUN";

$password = "yourPASS";

 

 

mysql_connect(localhost,$username,$password);

@mysql_select_db($database) or die ( "unable to connect");

$query="CREATE TABLE `members` (

  `user_id` mediumint( 8 ) NOT NULL auto_increment ,

  `username` varchar(25) NOT NULL default ,

  `user_password` varchar(32) NOT NULL default ,

  `user_email` varchar(255) NOT NULL default ,

    PRIMARY KEY  (`user_id`)

) TYPE=MyISAM AUTO_INCREMENT=60 ";

 

?>

and that should do it.

 

[Drags111]

Wow thanks man! Thanks for the fast reply. I'll learn this now

[mybluehair]

sure. let me know if that works. not sure if i wrote out that query right or not.

[Drags111]

how do i see the table? like what do i do to know its there? (sorry for the noob questions)

[Drags111]

i went to the phpmyadmin after using the script, and it said no tables found, so i just made it using the query there. But yah i guess it didnt work, but no error showed up when i ran it :S

[mybluehair]

well y didnt u just use phpadmin in the first place?

[Drags111]

.... because