<?php
   /* Connecting, selecting database */
   $link = mysql_connect("localhost", "username", "password")
       or die("Could not connect");
   print "Connected successfully";
   mysql_select_db("database") or die("Could not select database");

$query = "CREATE TABLE my_news {
     id int (10 )  NOT NULL auto_increment ,
     title varchar (100 )  NOT NULL ,
     text text NOT NULL ,
     PRIMARY KEY  (id )
}";

echo "
creating table [b]my_news[/b]... ";
$q = mysql_query($query) or die ("<font face=ff0000>failed</font>");
echo "<font color=00ff00>succeeded</font>
";

  /* Closing connection */
   mysql_close($link);

?>

$q = mysql_query($query) or die (mysql_error());

while($news = mysql_fetch_array($query))

<?php
   /* Connecting, selecting database */
   $link = mysql_connect("localhost", "base", "password")
       or die("Could not connect");
   print "Connected successfully";
   mysql_select_db("base") or die("Could not select database");
    
$query = mysql_query('SELECT * FROM my_news');
    // get all the news in the 'news' table
while($news = mysql_fetch_array($query)) {
    echo "Title: " . $news['title'] . "n";
    echo $news['text'] . "n";
    echo "---------------------n";
}
?>