db connect error or sumthing else?

devilinlondon

Helloall
I am trying to make a simple counter and am having trouble connecting to my database i think :-s

<?php 
session_start();  

include 'dbconnect.inc.php';  

if (!session_is_registered("counted")){  

    mysql_query("UPDATE simplecount SET count=(count + 1) WHERE count_id=1");  

session_register("counted"); 
} 
?>

dbconnect.in.php

    <?php  

$host = "localhost";  

$username = "root";  

$pass = "";  

$database = "mysql";  

mysql_connect($host,$username,$pass);  

mysql_select_db($database);  

?>

Now I am WoNdErIng that my 'simplecount' table has been under a database called 'mysql'

-How do I go about defining that
or
- has that been done right?

The Original file now runs ok(ie. no error on page) however when I browse the Sql table 'simplecount' after refreshing the page a coupe of times, the id's their have not been updated to say if any one has been or not.

azunoman

$database = "mysql";

you don't code mysql, it should be the name of the database you want to write to under mysql.

// This file contains the database access information. This file also establishes a connection to MySQL and selects the database.
// Set the database access information as constants.
define ('DB_USER', 'root');
define ('DB_PASSWORD', '');
define ('DB_HOST', 'localhost');
define ('DB_NAME', 'stats_keeper');
if ($dbc = @mysql_connect (DB_HOST, DB_USER, DB_PASSWORD)) { // Make the connnection.
if (!mysql_select_db (DB_NAME)) { // If it can't select the database.
// Handle the error.
my_error_handler (mysql_errno(), 'Could not select the database: ' . mysql_error());
// Print a message to the user, include the footer, and kill the script.
echo 'The site is currently experiencing technical difficulties. We apologize for any inconvenience.';
exit();
} // End of mysql_select_db IF.
} else { // If it couldn't connect to MySQL.
// Print a message to the user, include the footer, and kill the script.
my_error_handler (mysql_errno(), 'Could not connect to the database: ' . mysql_error());
echo 'The site is currently experiencing technical difficulties. We apologize for any inconvenience.';
include_once ('includes/footer.html');
exit();

 } // End of $dbc IF.