Search DaTutorials:  
HOME
Php Tutorials
Articles
Basics
Date and Time
File Manipulations
Forms
Functions
General
Interactivity
MySql
Navigation
News,Shoutboxes and Blogs
Language Structure and Data Types
Searching
Security
String Manipulation
User Information and Stats
Search For a Tutorial
Php Reference

mysql_select_db

(PHP 3, PHP 4 , PHP 5)

mysql_select_db -- Select a MySQL database

Description

bool mysql_select_db ( string database_name [, resource link_identifier])

Returns TRUE on success or FALSE on failure.

mysql_select_db() sets the current active database on the server that's associated with the specified link identifier. If no link identifier is specified, the last opened link is assumed. If no link is open, the function will try to establish a link as if mysql_connect() was called without arguments, and use it.

Every subsequent call to mysql_query() will be made on the active database.

Example 1. mysql_select_db() example

<?php

$link
= mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!
$link) {
   die(
'Not connected : ' . mysql_error());
}

// make foo the current db
$db_selected = mysql_select_db('foo', $link);
if (!
$db_selected) {
   die (
'Can\'t use foo : ' . mysql_error());
}
?>

See also mysql_connect(), mysql_pconnect() and mysql_query().

For downward compatibility mysql_selectdb() can also be used. This is deprecated however.



Copyright © 2001-2004 The PHP Group
All rights reserved.

     Loans | Car Finance | Life Insurance | Online Loans | Web Advertising
Home     Link To Us     Ad With Us     Contact Us     Tell A Friend     Affiliates     Blog     MsOfficeHelp