Hi Richard,

Thank you for all your time. It is nearly midnight here!

All the code including // test sections is
<body background="#FFFFFF" bgcolor="#FFFFFF">
<p>
  <?
include("../include/config.php");
///
// To be finished
// if (checkdate($month, $day, $year)) {print ("header etc.........
redirection if date is wrong
////
        $exdate = "$year-$month-$day";
        $date = date("Y-m-d");
        $sql = "
        INSERT INTO $table
        (id,date,user,title,brief,body,expires,visible)

VALUES(NULL,\"$date\",\"$user\",\"$title\",\"$brief\",\"$body\",\"$exdate\",
\"1\")
        ";

////// test simple SQL
//      $sql = "
//      INSERT INTO $table
//
(NULL,\"$date\",\"$user\",\"$title\",\"$brief\",\"$body\",\"$exdate\",\"1\")
//      ";

        $connection = mysql_connect($dbhost, $dbusername, $dbpass) or die ("Could
not connect to database");
//      if ($connection) { $msg = "Database Connection Established"; }
//      echo ($msg);
        $db = mysql_select_db($dbname) or die ("could not select db.");
        $result = mysql_query($sql,$connection) or die ("Could not execute query");
//      $result = mysql_query("insert into $table (user) values
('toby');",$connection) or die ("Could not execute query");
//      if ($result) { $msg = "<br>News Article added"; }
//      echo ($msg);
        $close = mysql_close($connection) or die("Could not close database");
        if ($close) {echo ("<br>Database closed");};
?>


Toby Parkins


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to