I'm gradually learning php and mysql and it has been a problem connecting to mysql with the mysql_connect(). How do I connect to a database name "test" and table name "members". Help of out. Thanks for your input.

emmanuelatas:
I'm gradually learning php and mysql and it has been a problem connecting to mysql with the mysql_connect(). How do I connect to a database name "test" and table name "members". Help of out. Thanks for your input.

Mysql_connect("localhost", "database username", "databasepassword"];

Mysql_select_db("test"];

You should have posted the code u hv written so far, the php version u are using. There several ways to achieve this;-

For latest version of MySQLi (improved):

<?php
$servername = "localhost";
$username = "username";
$password = "password";

// Create connection
$conn = new mysqli($servername, $username, $password);

// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
?>

NOTE
-----
This "MySQL" extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should be used.

Here's how to create a mysql database connection using PDO
<?php
$dsn = 'mysql:dbname=testdb;host=127. 0.0.1'; $user = 'dbuser'; $password = 'dbpass'; try { $dbh = new PDO ($dsn, $user, $password); } catch (PDOException $e) { echo 'Connection failed: ' . $e- >getMessage(); } ?>