Query problem 1

[frozenpeas]

Hello,

For the life of me, I cannot get this to work. Can anyone see what is wrong?

<?php
require_once('connections/connect.php');
mysql_select_db($database_connect,$connect);
$query = "SELECT * FROM hectik ORDER BY date DESC,id";
$myQuery = mysql_query($query) or die("Could not query database. ".mysql_error().'. ('.mysql_errno().')');
while($row = mysql_fetch_assoc($myQuery)){
	echo "test";
}
?>

or

<?php
require_once('connections/connect.php');
mysql_select_db($database_connect, $connect);
$query = "SELECT * FROM hectik ORDER BY date DESC,id";
$myQuery = mysql_query($query) or die("Could not query database. ".mysql_error().'. ('.mysql_errno().')');
while($row = mysql_fetch_array($myQuery)){
	echo "test";
}
?>

Both of these result in:

Could not query database. No Database Selected. (1046)

Variable values are good, paths are good, database and table are there and contain data.

Any ideas? Thanks.

frozenpeas
--
Micfo.com Affiliate Program

 

[kenrbnsn]

Add an "or die" clause on to the mysql_select_db() function:

mysql_select_db($database_connect,$connect) or die('Could not select database<br>'.mysql_error());

and see what you get.

Ken

 

[frozenpeas]

Thanks, Ken. I somehow overlooked giving the user access to the db.

frozenpeas
--
Micfo.com Affiliate Program