Mysql Select

[Mister-Mind]

Does anyone know the MYSQL code To Select a database. Not the PHP code but the Syntax please.

[SpamBurgeralt]

mysql_select_database('database');

??

[Ross]

use <databasename>;

[JeremysFilms]

Before selecting a database, make sure you are connected to MySQL. The following lines show how to connect to MySQL and how to select a database:

@mysql_connect('localhost','usernameToData
base','password') OR die('Could not connect to MySQL.');
@mysql_select_db('databaseName') OR die('Could not connect to database.');

*NOTE: the @ preceeding the mysql functions are used to suppress any errors that would be returned. Using "or" after these functions instructs execution of the next command if the first execution returns false. In this case, and better understood, if the mysql function fails, it's error will be suppressed and a die function will execute in order to output a more "user-friendly" error message.

Also, you need to actually feed queries to PHP to carry out tasks to the database.