	Submit Your Code
	SEO Monitor
	UpTime Monitor
	PHP Code Contest
	My Favorite Examples
	My Favorite Articles
	Update Your Profile

More Weber Sites
	PHP Code Search
	Web Development Forums
	Learn MySQL Playing Trivia
	PHPBB2 Templates
	Web Development Index
	Web Development Resources
	Web Development Content

Recommended Links
	PHPClasses
	PHP Editor
	PHP Jobs
	Vision.To Design
	Ajax Tutorials
	PHP Programming Help
	PHP/MySQL Programming
	Webmaster Resources
	Webmaster Forum
	XML meta language
	website builder

Recommended
	Mobile Dev World

Select a MySQL database

mysql_set_charset

MySQL Functions

mysql_select_db

(PHP 4, PHP 5)

mysql_select_db — Select a MySQL database

Description

bool mysql_select_db ( string $database_name [, resource $link_identifier ] )

Sets the current active database on the server that's associated with the specified link identifier. Every subsequent call to mysql_query() will be made on the active database.

Parameters

database_name: The name of the database that is to be selected.
link_identifier: The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect() is assumed. If no such link is found, it will try to create one as if mysql_connect() was called with no arguments. If by chance no connection is found or established, an E_WARNING level error is generated.

Return Values

Returns TRUE on success or FALSE on failure.

Examples

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());
}
?>

Notes

Note: For backward compatibility, the following deprecated alias may be used: mysql_selectdb()

See Also

mysql_connect() - Open a connection to a MySQL Server
mysql_pconnect() - Open a persistent connection to a MySQL server
mysql_query() - Send a MySQL query

mysql_set_charset

MySQL Functions

Related Code Examples

	You have a set of many resources , and You need to know wich of these resources are available for a given use during a given period but MySql does not allow SUB-Selection :( here is the right way to do that in a single query Categories : MySQL, General SQL, Databases, Algorithms
	A simple script to count and report hits and the last modification time of an HTML page. Requires MySQL support (other DBs should work too, except possibly mSQL). Categories : HTTP
	mediaCat-GTK v2.0.0 - an mp3/cd/dvd cataloging utility written in php-gtk which interfaces with mysql and ms access (or db supported by PHP's Unified ODBC Functions) Categories : PHP, MySQL, MS Access, Utilities, Databases

	PHP Object Example of the Perl DBI with MySQL Categories : PHP, PHP Classes, MySQL, Databases, Perl
	Designed to help those implementing a MySQL search engine. Generates select query strings, given logical querys.I made a search engine class that extends this one mail me if intrested.Needs a few changes ( well its only version 1.0 ;) Categories : PHP Classes, MySQL, Search, Regexps
	ADODB Database Wrapper Abstraction Library for PHP: MySQL, MSSQL, Oracle, Interbase,ODBC, Microsoft Access and FoxPro. Categories : PHP Classes, Databases, PHP, General SQL, ODBC
	a function that builds an HTML select list from any mysql table. Categories : PHP, MySQL, HTML and PHP
	Three ways to access data selected by a mysql query Categories : MySQL, PHP, Databases
	It's easy to select multiple rows from a mySql Table. Categories : PHP, MySQL, Databases
	IdealMySQL Database Class - Connect and Query a mysql database including INSERT \| DELETE \| UPDATE \| REPLACE \| DROP \| SELECT \| SHOW \| DESCRIBE \| EXPLAIN, Catch errors and email them,Check variables to make sure they only contain particular characters. Categories : PHP, PHP Classes, Databases, MySQL
	Accepts a database & hostname from a user and then HTTP username and password. Uses this to connect to a MySQL database. Produces a form based on the tables it finds there to allow the user to do SELECTs, INSERTs, and DELETEs. Categories : Databases, PHP, MySQL, Complete Programs
	db Field Finder - A Cheezy Script to Search For MySQL tablenames Categories : PHP, Databases, MySQL
	A Simple Script to randomly select a CSS from MySQL Categories : PHP, Databases, MySQL, CSS
	Writing Portable MySQL Code in PHP: Porting to Oracle, Microsoft SQL Server, Sybase, Interbase, PostgreSQL and other databases using ADODB class library. Categories : MySQL, PHP, PHP Classes, ODBC, General SQL