[SOLVED] include() and function..

[clown[NOR]]

i have been fighting this problem for a while now, but with no luck.. i just cant see why it wont work... it might be the function... it's the first time i'm working with it... so..

 

this is the error message i get:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ODBC'@'localhost' (using password: NO) in F:\root\oleaa.com\index.php on line 21

Unable to connect to DB

 

this is the code:

<?php
include('config/db.php');
function freshNews() {

	if (!mysql_connect($dbHost, $dbUser, $dbPass)) { die("Unable to connect to DB"); } //This is line 21
	if (!mysql_select_db($dbName)) { die("Unable to select DB"); }

	$query = "SELECT * FROM news";
	$result = mysql_query($query);

	if (!$result) { die("Could not run query from DB"); }

	$dbNumRows = mysql_num_rows($result);

	if ($dbNumRows > 0) {
		echo $dbNumRows . " news found.";
	} else { echo "No news found."; }


}

 

 

Thanks In Advance

- Clown

[clown[NOR]]

ok.. i figured it out... i had to move the include() inside the function... but... is there a way so I dont have to do that?

[taith]

not sure why it needs to be in the function for that... shouldnt need to be... but if you include_once(); you can put it in either/both spots... problem solved :-)

[clown[NOR]]

hehe... oh well... i tried to add it as include_once() outside the function ... didnt work.. if that's what you ment tho... oh well.. it's jsut the db.php... so it's ok... but if anyone have an solution for this.. please let me know...

[Guest prozente]

http://us2.php.net/manual/en/language.variables.scope.php

[clown[NOR]]

this is the db file.. tried to make the variables global... but it didn't work

<?php

 

global $dbHost, $dbUser, $dbPass, $dbName;

 

$dbHost = "localhost";

$dbUser = "root";

$dbPass = "";

$dbName = "oleaa";

 

?>

[Guest prozente]

put

 

global $dbHost, $dbUser, $dbPass, $dbName;

 

in your function before you use the variables

[clown[NOR]]

aaahhh...  *feeling stupid* haha... thanks m8