and then a table with its columns
using php and mysql database?
thnaks inadvance
peleg
[SOLVED] whats is the set of orders to build a database
Moderator: General Moderators
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
Start with the MySQL manual - http://www.mysql.com/doc - it has all the SQL commands you will need.
Mac
Mac
Also read into http://www.php.net/mysql 
definitely look through the manual and a tutorial or 3..
here is a sample once you are ready to tackle it:
here is a sample once you are ready to tackle it:
Code: Select all
<?php
$link=MYSQL_CONNECT($host,$username,$password) OR DIE("Unable to connect to database")
$query = "CREATE TABLE Browser (
id int(11) NOT NULL auto_increment,
data text NOT NULL,
platform varchar(25) NOT NULL default '',
type varchar(25) NOT NULL default '',
version varchar(25) NOT NULL default '',
PRIMARY KEY (id)
)";
$result=mysql_query($query,$link) or die(mysql_error()."$query");
?>