[Resolved] No Database Selected? strange happenings

[tuf-web_co_uk]

hey, quick question i keep getting no database select errors when i run this script, even though i have clearly select one on line 11

<?

session_start();

$db_host = "localhost";
$db_user = "*********";
$db_pass = "*********";
$db_name = "*********";

$conn = mysql_connect($db_host, $db_user, $db_pass);
$db = mysql_selectdb($db_name, $conn);

$sql = "SELECT * FROM `match` ORDER BY `id` DESC";
$query = mysql_query($sql, $conn) or die(mysql_error());

while ($matches = mysql_fecth_array($query)) {

$sql2 = "SELECT * FROM `match_r` WHERE `mid` = '".$matches['id']."'";
$query2 = mysql_query($sql2, $conn) or die(mysql_error());
$num = mysql_num_rows($query2);

$count = 0;

while ($wrestler = mysql_fetch_array($query2)) {

	$sql3 = "SELECT * FROM `roster` WHERE `id` = '".$wrestler['wid']."'";
	$query3 = mysql_query($sql3, $conn) or die(mysql_error());

	$name = mysql_fetch_array($query3);

	echo $name['w_name'];

	$count++;

	if ($count == '1' && $num == '2') {
		echo " vs. ";
	}
	else if ($count == '1' OR $count == '3' && $num == '4') {
		echo " & ";
	}
	else if ($count == '2' && $num == '4') {
		echo " vs. ";
	}

}

}

?>

anything else i should be looking for here?

thanks

[sglane]

But you missed an _

mysql_select_db();
not
mysql_selectdb();

I'm wondering why you aren't getting an error for function not found.

Hope this helps.

[tuf-web_co_uk]

i tried both functions

mysql_select_db()
mysql_selectdb()

and did not get an error for either, just no database selected

my php editor, says both are valid functions to select a db, eitherway, it still doesnt work

[superwormy]

You also spelled mysql_fetch_array() wrong...

Try appending an or die (mysql_error ()); statement.

mysql_select_db ("database_name", $connection) or die (mysql_error());

[tuf-web_co_uk]

thanks, that fixed the problem

it turned out i forgot to set permissions! :rolleyes:

how stupid of me

thanks all the same 😉