mysql_select_db problem

jamal_dakak

Hi,
I've got this error when I try to select a db and run the query bellow:
Error:
server - connected
db - error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /properties/test.php on line 22

include_once("../../library/config.inc.php");
include_once(INC_COMMON);
include_once(INC_TEMPLATE);

// Check maintenance mode
//check_maintenance_mode();
$link=mysql_connect("localhost","motn","82dh435f7848f");
if(mysql_connect("localhost","motn","82dh435f7848f")){
	echo "server - connected<br />";
} else {
	echo "server - error<br />";
}
if(mysql_select_db("MOTN", $link)){
	echo "db - connected<br />";
} else {
	echo "db - error<br />";
}

$q=mysql_query("SELECT * FROM postcodes");
while($r=mysql_fetch_array($q)){
	print_r($r);
}
exit;


session_start();
$template=new Template;

?>
Please Have you got any help :queasy:

TobyRT

Hi jamal,

Try something along these lines - I think you're making this perhaps a little more complicated than you need to.

I assume this is your line to connect to your server:
$link=mysql_connect("localhost","motn","82dh435f7848f");

If that is the case, why are you calling it when you try and select your db here?:
if(mysql_select_db("MOTN", $link)){

If you're after errors, try this:

mysql_connect ('localhost', 'motn', '82dh435f7848f') or die ('Unable to Connect');
mysql_select_db('motn') or die ('Unable to select database');

You're getting the invalid resource error because it's failing to connect to the database - if it can't connect to the database then your $q variable will be failing, if $q is failing, then obviously print_r($q) won't work either.

bpat1434

A few suggestions:

Check to make sure that you're using the correct database name. If you're on a shared server, usually database names are "username_databasename". So if your username is "motn" and your database is "motn" then your database name that you need to select might actually be: motn_motn. Make sense?

The easy way to check it is to go through phpMyAdmin or cPanel and look at the values it gives you.

~Brett