Re: database connection question

Hello, please forward user questions to the php-general@lists.php.net mailinglist, this list is for development _OF_ PHP, not development _with_ PHP. Derick On Sat, 28 Dec 2002, Edmund Yap wrote: > Hi, > a function display_categories() in display.php tries to connect to a > database with the function db_connect() residing in db_connections.php. > However, this results in the error "mysql_query(): supplied argument is not > a valid MySQL-Link resource ". I still can't figure out the error in my > code. Can someone enlighten me? Thanks! > > Best Regards, > Edmund Yap > *********** > display.php: > ************ > <? > include ("db_connections.php"); > function display_categories() > { > db_connect(); > echo $mysql_link; > $query = "select * from ProductCategory order by ProductCategoryName"; // > mysql_query(): supplied argument is not a valid MySQL-Link resource... > $mysql_result = mysql_query($query, $mysql_link); // mysql_fetch_row(): > supplied argument is not a valid MySQL result resource in... > > while($row = mysql_fetch_row($mysql_result)) > { > //blar blar blar > } > } > ?> > ******************** > db_connections.php: > ******************** > <? > function db_connect() > { > $mysql_link = mysql_pconnect("localhost", "username", > "password"); > if (!$mysql_link) > return false; > if (!mysql_select_db(("products"), $mysql_link)) > return false; > > return $mysql_link; > > } > ?> > > > > > -- > PHP Language Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- ------------------------------------------------------------------------- Derick Rethans http://derickrethans.nl/ PHP Magazine - PHP Magazine for Professionals http://php-mag.net/ -------------------------------------------------------------------------