<?php

$dbhost="localhost";
$dbusername="root";
$dbpassword="pass";
$dbname="bombibiza";

$connect = mysql_connect($dbhost, $dbusername, $dbpassword);

mysql_create_db("bombibiza") or die (mysql_error());

mysql_select_db("bombibiza");


$Main = "CREATE TABLE `news` (
  `newsid` int(11) NOT NULL auto_increment;
  `dtime` datetime default NULL;
  `title` varchar(255) default NULL;
  `text1` text;
  `text2` text;
  PRIMARY KEY  (`newsid`)
) TYPE=MyISAM AUTO_INCREMENT=1  "  ;

echo "tables are complete"
?>

<?php
// load the configuration file.
include("config.php");
        //load all news from the database and then OREDER them by newsid
        //you will notice that newlly added news will appeare first.
        //also you can OREDER by (dtime) instaed of (news id)
        $result = mysql_query("SELECT * FROM news ORDER BY newsid DESC",$connect);
        //lets make a loop and get all news from the database
        *****while($myrow = mysql_fetch_row($result))*****
             {//begin of loop
               //now print the results:
               echo "<b>Title: ";
               echo $myrow[2];
               echo "</b><br>On: <i>";
               echo $myrow[1];
               echo "</i><hr align=left width=160>";
               echo $myrow[3];
               // Now print the options to (Read,Edit & Delete the news)
               echo "<br><a href=\"read_more.php?newsid=$myrow[newsid]\">Read More...</a>
                || <a href=\"edit_news.php?newsid=$myrow[newsid]\">Edit</a>
                 || <a href=\"delete_news.php?newsid=$myrow[newsid]\">Delete</a><br><hr>";
             }//end of loop
?>

<?php
// Set Mysql Variables
//Change the following
$dbhost="localhost";
$dbusername="root";
$dbpassword="pass";
$dbname="bombibiza";

// Don't touch here anything.
// Connect to Mysql
$connect = mysql_connect($dbhost, $dbusername, $dbpassword);
//Select the correct database.
mysql_select_db($dbname,$connect) or die ("Could not select database");
?>