// header ("Location: http://www.ericsson.fi/"); ?>
Creating news tables
$link = mysql_connect("p2", "jarde", "Nsp5lxYI")
or die("Could not connect");
mysql_select_db("jarde")
or die("Could not select database");
$query =
"create table news (".
"art_id integer not null auto_increment,".
"parent_id integer default 0,".
"topic varchar(255),".
"text text null,".
"picurl varchar(128),".
"pictext varchar(255),".
"datecreate timestamp,".
"datemodify timestamp,".
"datepublish timestamp,".
"author varchar(64),".
"authoremail varchar(128),".
"misc varchar(255),".
"key news_art_id (art_id)".
");";
echo $query;
$result = mysql_query($query)
or die("Query failed");
?>