no database selected, when including function

[bluns]

Hi guys i have a function to create a header.

 
function do_header($title)
{
include('data_fns.php');
  $db_conn = mysql_connect($db_servername, $db_username, $db_password);
  if (!$db_conn)
  {
     echo 'Error: Could not connect to database.  Please try again later.';
     exit;
  }
  mysql_select_db($db_name);
?>

//HEADER STUFF HERE
			$query="SELECT button FROM miscpage";
			$result = mysql_query($query);
			$row=mysql_fetch_object($result);
			if($result)
			{
			echo '<td width="75" background="'.$path.'images/middlenav.png" align="center"><div align="center"><span class="style7"><a href="'.$path.'misc.php">'.$row->button.'</a></span></div></td>';  

			}echo mysql_error();?>


<?php
}
?>
 

if i echo it in the function file, it works fine, connecting to database fine

But when i include it via a php file, i get the error "supplied arguement is not a valid MySQL result..."

mysql_error() says no database selected

but i have selected a database, and even included function after i declared the database

 
include('data_fns.php');
  $db_conn = mysql_connect($db_servername, $db_username, $db_password);
  if (!$db_conn)
  {
     echo 'Error: Could not connect to database.  Please try again later.';
     exit;
  }

mysql_select_db($db_name);
do_header('Title goes here');

So my question is, is it not possible to post data from mysql via a function?

[sidney]

your selecting the database before your connecting to mysql

mysql_select_db($db_name); 
do_header('Title goes here');  

you may also want to make $db_conn global

[bluns]

thanks for your reply

  do_header('Cardealer Software');

$db_conn = mysql_connect($db_servername, $db_username, $db_password);
  if (!$db_conn)
  {
     echo 'Error: Could not connect to database.  Please try again later.';
     exit;
  }
  mysql_select_db($db_name);

 

or

    $db_conn = mysql_connect($db_servername, $db_username, $db_password);
  if (!$db_conn)
  {
     echo 'Error: Could not connect to database.  Please try again later.';
     exit;
  }
  mysql_select_db($db_name);
  do_header('Cardealer Software');
 

Still says, database not selected

it connects to my database fine in my file, just wont connect to the function include database... 🙁

[sidney]

mysql_select_db($db_name, $db_con);

and set the values global in function

global $db_con, $db_name;