blira Posted June 20, 2006 Share Posted June 20, 2006 Hi all... first post.I have a site (PHP/MySQL) and receive the "No Database Selected". The /Connections/connect.php file includes the following code:<?php# FileName="Connection_php_mysql.htm"# Type="MYSQL"# HTTP="true"$hostname_cirpeduc = "localhost"; $database_cirpeduc = "ciruja_cirpeduc"; $username_cirpeduc = "ciruja_root"; $password_cirpeduc = "root"; $cirpeduc = mysql_pconnect($hostname_cirpeduc, $username_cirpeduc, $password_cirpeduc) or trigger_error(mysql_error(),E_USER_ERROR); ?>As far as I understand there must be no blank lines after the "?>" (this file has no such blank lines). Every value is correct (such as localhost, curuja_cirpeduc, and so forth).Any ideas?TIABernardo, from Chile. Link to comment https://forums.phpfreaks.com/topic/12428-no-database-selected/ Share on other sites More sharing options...
High_-_Tek Posted June 20, 2006 Share Posted June 20, 2006 mysql_select_db('database') Link to comment https://forums.phpfreaks.com/topic/12428-no-database-selected/#findComment-47505 Share on other sites More sharing options...
blira Posted June 20, 2006 Author Share Posted June 20, 2006 Here is a file that requires the connection file described above.<?php require_once('Connections/connect.php'); ?><?php$currentPage = $_SERVER["PHP_SELF"];$maxRows_noticias = 10;$pageNum_noticias = 0;if (isset($_GET['pageNum_noticias'])) { $pageNum_noticias = $_GET['pageNum_noticias'];}$startRow_noticias = $pageNum_noticias * $maxRows_noticias;mysql_select_db($database_cirpeduc, $cirpeduc);$query_noticias = "SELECT * FROM noticia ORDER BY fecha DESC";$query_limit_noticias = sprintf("%s LIMIT %d, %d", $query_noticias, $startRow_noticias, $maxRows_noticias);$noticias = mysql_query($query_limit_noticias, $cirpeduc) or die(mysql_error());$row_noticias = mysql_fetch_assoc($noticias);{etc}This is the php file that shows the "No Database Selected" message. Link to comment https://forums.phpfreaks.com/topic/12428-no-database-selected/#findComment-47508 Share on other sites More sharing options...
wildteen88 Posted June 20, 2006 Share Posted June 20, 2006 Change this:mysql_select_db($database_cirpeduc, $cirpeduc);to:mysql_select_db($database_cirpeduc, $cirpeduc) or die("Unable to select database: " . mysql_error()); Link to comment https://forums.phpfreaks.com/topic/12428-no-database-selected/#findComment-47593 Share on other sites More sharing options...
blira Posted June 20, 2006 Author Share Posted June 20, 2006 Thanks, wildteen88, your help showed me the problem.My DBA didn't grant me permission to the database... now it's working fine.Thanks again!! Link to comment https://forums.phpfreaks.com/topic/12428-no-database-selected/#findComment-47666 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.