Function...

[rIkLuNd]

I have a problem with a function that I'm trying to create, and it's supposed to connect to the database, but it doesn't! I have an include on the top of the file, where the mysql variables are, but when I refer to them in the function, they don't show up.

An example:

<?php
include("config.php");

function connect_to_db()
{
global $link;

$link = mysql_connect($host,$user,$pass);
if(!$link)
die(mysql_error());

mysql_select_db($db) or die(mysql_error());

?>

When this is executed I get this error:
"No Database Selected".

What's wrong?!

[Kerry_Kobashi]

Whats your values of $host, $user, and $pass?

Are they global? 😮)

[rIkLuNd]

Does this do it?!

<?php
include("config.php");

function connect_to_db()
{
global $link;
global $host;
global $user;
global $pass;
global $db;

$link = mysql_connect($host,$user,$pass);
if(!$link)
die(mysql_error());

mysql_select_db($db) or die(mysql_error());

?>

[Kerry_Kobashi]

Yes.... if $host, $user, and $password are defined in config.php and set properly it will... 🙂

Kerry Kobashi
Kobashi Computing