[SOLVED] Database error.

[plutomed]

$DBCon = mysql_connect("localhost", "uname", "pword") or die();
mysql_select_db("plutomed_dsb", $DBCon) or die();


function login($UName, $Pass)
{
$LoginQuery = mysql_query("SELECT * FROM users") or die();

while($LoginInfo = mysql_fetch_array($LoginQuery))
{

	<No code here yet>

}

$_SESSION['LoggedIn'] = "1";
$_SESSION['UName'] = $UName;
}

 

It comes up with this error:

 

Warning: mysql_query() [function.mysql-query]: Access denied for user 'nobody'@'localhost' (using password: NO) in /home/plutomed/public_html/DSB/includes/functions.php on line 36

 

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/plutomed/public_html/DSB/includes/functions.php on line 36

 

Why is it saying I haven't connected? This page is included in a main page and then the function "login" is called later.

[gevans]

If you managed to connect it might be a privileges issue. Check your user privilege to see if they allow you to do any queries on the db

[plutomed]

I created the database, and gave that uname full permissions.

 

It works when called from outside of the function.

[gevans]

I created the database, and gave that uname full permissions.

 

haha... in which case, it might be due to your running the query within a function when the connection is done outside. Try passing the connection to the function and applying it to the query...

 

<?php
$DBCon = mysql_connect("localhost", "uname", "pword") or die();
mysql_select_db("plutomed_dsb", $DBCon) or die();

function login($UName, $Pass, $DB)
{
$LoginQuery = mysql_query("SELECT * FROM users", $DB) or die();

if($LoginInfo = mysql_fetch_array($LoginQuery)){

<No code here yet>


$_SESSION['LoggedIn'] = "1";
$_SESSION['UName'] = $UName;
}

 

Then your function reference would look like;

 

login('username','password',$DBCon);

[plutomed]

Yep, that works.

 

Thanx alot.