Inside your function define: global $server; global $pass; global $user; etc....
It is using variables insides it's own scope and unless you have use GLOBAL_VARIABLES defined in your php.config file, it won't go outside of it's scope to look for values, hence they are getting asigned NULL and you can't connect to a NULL DB :) Henrik On Sunday 28 October 2001 14:57, jtjohnston wrote: > 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"; > } > ?> -- Henrik Hudson [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]