Jump to content

Archived

This topic is now archived and is closed to further replies.

luvburn

'no database select'

Recommended Posts

hi...

Why do i always get the error 'no database select' everytime i open a page that has sql statement in it. I have to view other page that has no sql statement before i could open the page.

Share this post


Link to post
Share on other sites
[quote]Why do i always get the error 'no database select' everytime i open a page that has sql statement in it.[/quote]

does this sql statement say

[code]mysql_select_db('name_of_database_to_select');[/code]

??

Share this post


Link to post
Share on other sites
Have you output to the browser which database you're trying to select?  I don't know your application layout but it seems like you might be including the files in the wrong order or perhaps not at all.  I run into problems often because I develop on a WinXP box and the server is Fedora Linux.  Sometimes I dont' pay attention to my capitalization which linux is strict about, windows isn't.

Just throwing that out there...

Share this post


Link to post
Share on other sites
This is my coding regarding the error. It's quite long but i just put the part where the php coding started.

[code]

<?php
include ('mysql_connect.php');
include ('papar_fungsi.php');
//$currentPage = $_SERVER["PHP_SELF"];
$age = $_GET["umur"];

session_name ('diagnos');
session_start();
if (!isset($_SESSION["diagnos"])) {
$_SESSION["diagnos"] = NULL;
}

$maxRows_Recordset1 = 1;
$pageNum_Recordset1 = 0;

if (isset($_GET['pageNum_Recordset1'])) {
  $pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}

$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

if ( $age == 1 ){

$query_Recordset1 = "SELECT * FROM simptom WHERE kategori='$tanda' AND bayi='y' ";
}else {
$query_Recordset1 = "SELECT * FROM simptom WHERE kategori = '$tanda'";
}

$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);

$id = $row_Recordset1['idsimptom'];

if (isset($_GET['totalRows_Recordset1'])) {
  $totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
} else {
  $all_Recordset1 = mysql_query($query_Recordset1);
  $totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}

$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;

$queryString_Recordset1 = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {

if (stristr($param, "pageNum_Recordset1") == false &&
stristr($param, "totalRows_Recordset1") == false) {
  array_push($newParams, $param);
}
  }
  if (count($newParams) != 0) {
$queryString_Recordset1 = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1);

$query= "SELECT * FROM jawapan WHERE kategori = '$tanda' AND idsimptom = '$id'";
$result = mysql_db_query($dbc,$query);
$myrow = mysql_fetch_array($result)

?>
[/code]

The problem is, if the error 'no database select' happened, i couldn't view anything in my page. Kindly please help me. Tq.  :(

Share this post


Link to post
Share on other sites
Actually, what we need to see is the content of mysql_connect.php (presumably where you make the database connection). Post all the code for that - putting **** for your username, password, etc.  'Somewhere' in that code there ought to be a line like ...

[code]mysql_select_db($dbname)[/code]

Share this post


Link to post
Share on other sites
ok then this is 'mysql_connect.php'

[code]
<?php
define("DATABASE_HOST", "localhost");
define("DATABASE_USER", "root");
define("DATABASE_PASSWORD", "");


mysql_pconnect(DATABASE_HOST,DATABASE_USER, DATABASE_PASSWORD) or trigger_error(mysql_error(),E_USER_ERROR);;
$dbc = "xpert";
?>
[/code]

But somehow i don' think the problem comes from this code. Eneway....i appreciate it if you could find the solution.

Share this post


Link to post
Share on other sites
[quote][code]<?php
define("DATABASE_HOST", "localhost");
define("DATABASE_USER", "root");
define("DATABASE_PASSWORD", "");


mysql_pconnect(DATABASE_HOST,DATABASE_USER, DATABASE_PASSWORD) or trigger_error(mysql_error(),E_USER_ERROR);;
$dbc = "xpert";
?>[/code][/quote]

looking at this code, can I assume that the database you wish to connect to is call 'xpert' ?
if that is the case then the above code would connect to your database host on a permanent basis and then assigns the string "xpert" to a variable called $dbc

if you wish to connect to your database called 'xpert' then you need the following code in there too
[code]
mysql_select_db($dbc) ;

[/code]

this will prevent no database selected errors, as you have told it which databse to connect to.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.