Connecting Tech Pros Worldwide Forums | Help | Site Map

'no database selected'

Newbie
 
Join Date: Feb 2008
Posts: 1
#1: Feb 9 '08
Hi there, I am getting a 'no database selected' error when I try to run a query on one of my pages.

[PHP]<?php
session_start();
require('safe/fhlogin.inc.php');
if (!isset($_SESSION['wagentje'])) {
$_SESSION['wagentje']['artikels'] = array();
}

$id = $_GET['id'];

if ($_GET['action'] == 'add') {
if (isset($_GET['aantal'])) $aantal = $_GET['aantal']; else $aantal = 1;
if (!isset($_SESSION['wagentje']['artikels'][$id])) $_SESSION['wagentje']['artikels'][$id] = 0;
$_SESSION['wagentje']['artikels'][$id] += $aantal;
} else if ($_GET['action'] == 'delete') {
unset($_SESSION['wagentje']['artikels'][$id]);
}
?>
<html>
<head>
</head>
<body>
<?php
$link = new mysqli($dbserver, $user, $passwd, $dbnaam);
foreach($_SESSION['wagentje']['artikels'] as $artikel => $sleutel) {

echo "$artikel\n <br>";
echo mysql_result(mysql_query("SELECT thumbnail FROM hellinx_artikel WHERE artikelnr=\"$artikel\"") or die (mysql_error()));

}
$link->close() or die("Kan link met $dbserver niet sluiten.");

?>
</body>
</html>[/PHP]

I am positive that the user has the right priviliges and that the login.inc file is correct ( since I use it on other pages and those work)

Thanks :)
mwasif's Avatar
Moderator
 
Join Date: Jul 2006
Location: Pakistan
Posts: 719
#2: Feb 9 '08

re: 'no database selected'


You need to use mysqli_query() instead of mysql_query().
ronverdonk's Avatar
Moderator
 
Join Date: Jul 2006
Location: The Netherlands
Posts: 4,139
#3: Feb 10 '08

re: 'no database selected'


Since you use the oo style, you have to use it like
[php]
if ($link->query .....
[/php]

Ronald
Reply