Create table

[Afzaal.Ahmad.Zeeshan]

i need to ask where to put this code ?? so that it could run.. CREATE TABLE Profiles( UniqueID AutoIncrement NOT NULL PRIMARY KEY, Username Text (255) NOT NULL, ApplicationName Text (255) NOT NULL, IsAnonymous YesNo, LastActivityDate DateTime, LastUpdatedDate DateTime, CONSTRAINT PKProfiles UNIQUE (Username, ApplicationName))

[niche]

Put it in a mysql_query(). Here's a n example:

<?php// connect to your MySQL database hererequire_once "connect_to_mysql.php";// Create an sql command structure for creating a table$tableCreate = "CREATE TABLE members (			    id int(11) NOT NULL auto_increment,			    username varchar(255) NOT NULL,			    email varchar(255) NOT NULL,			    password varchar(255) NOT NULL,			    website varchar(255) NULL,			    account_type enum('a','b','c') NOT NULL default 'a',			    PRIMARY KEY (id),			    UNIQUE KEY email (email)			    )";// This line uses the mysql_query() function to create the table now$queryResult = mysql_query($tableCreate);// Create a conditional to see if the query executed successfully or notif ($queryResult === TRUE) {	    print "<br /><br />Success in TABLE creation! Happy Coding!";} else {	    print "<br /><br />No TABLE created. Check";}// close mysql connectionmysql_close();?>

[birbal]

you can also do that in mysql console or use friednly convenient application like phpmyadmin. creating tables and databases usually done outside php script.

[niche]

Great point birbal. Frankly, that's the way I do it now, but in the beginning I used php.