database connection

[Anon]

how do i connect to a database? (mine is at brinkster.com)

[Anon]

Here's a basic connecion script:

<?php
$dbServer = "http://www.brinkster.com";
$dbUserName = "your_username";
$dbPassword = "your_password";
$dbDatabase = "your_database_name";

$con = mysql_connect("$dbServer","$dbUserName","$dbPassword")
or die ("Connection Error to Server");
$db = mysql_select_db("$dbDatabase",$con)
or die("Connection Error to Database");

?>

[kaizix]

the thing i do is set all my username and password in a file and include it..

$dbhost = "localhost";
$dbuser = "username";
$dbpass = "password";
$dbname = "database";
$table = "tablename";

and then use the following statement to connect to it and select the database.

$connect = mysql_connect($dbhost, $dbuser, $dbpass) or die('not connected');
if(mysql_select_db($dbname,$connect));
else die ("not connected to db");