One last kick at the cat
| From: | jtjohnston | Date: | Sun, 28 Oct 2001 20:57:04 +0000 |
| Subject: | One last kick at the cat | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-72643@lists.php.net to get a copy of this message | ||
Sigh ...
I have "functions.inc" in which I have Table_Title().
As soon as I put my database connection inside my function called
Table_Title(), my database connection fails. (See second example below.)
My database connection works fine whenever IT IS NOT inside "function
Table_Title()". (See first example below.)
It seems that when I try to connect to my database inside "function
Table_Title()", my function cannot read the values of $server, $user,
$pass, "$db or $table ???
I call it normally??
<?php Table_Title() ?>
Can anyone help??
--------------SNIP THIS WORKS FINE! --------------------
<?php
$server = "localhost";
$user = "MyAccount";
$pass = "MyPassword";
$db = "MyDatabase";
$table = "bookmark_unit4";
$myconnection = mysql_pconnect($server,$user,$pass);
mysql_select_db($db,$myconnection);
$news = mysql_query("SHOW TABLE STATUS FROM ".$db." LIKE '$table'");
while ($news_story = mysql_fetch_array($news))
{
$table_comment = $news_story['Comment'];
}
echo $table_comment;
function Table_Title()
{
echo "Nothing";
}
?>
-------------- SNIP THIS DOES NOT WORK --------------------
<?php
$server = "localhost";
$user = "MyAccount";
$pass = "MyPassword";
$db = "MyDatabase";
$table = "bookmark_unit4";
function Table_Title()
{
$myconnection = mysql_pconnect($server,$user,$pass);
mysql_select_db($db,$myconnection);
$news = mysql_query("SHOW TABLE STATUS FROM ".$db." LIKE '$table'");
while ($news_story = mysql_fetch_array($news))
{
$table_comment = $news_story['Comment'];
}
echo $table_comment;
//echo "Nothing";
}
?>