RE: [PHP-DB] newbie: Trying to select a database in php

Should be obvious here that you have a typo :) replace msql_select_db() with mysql_select_db() ;Mats Remman > -----Original Message----- > From: Paul Lockyer [mailto:paul_lockyer23@yahoo.co.uk] > Sent: Wednesday, June 20, 2001 10:07 AM > To: php-db@lists.php.net > Subject: [PHP-DB] newbie: Trying to select a database in php > > > Im using win2k and php to retrieve and dipslay database records, > however whenever the page is loaded in a browser I get the > following error (the line in question is in bold) > > Fatal error: Call to undefined function: msql_select_db() in > D:\ASP\test\php\default.php on line 18 > > The code I am using is below > > <?php > > $connect = mysql_connect(); > > if(!$connect){ > echo "Could not etsablish connection to mySQL!"; > exit; > } > > $database = "dvd_listings"; > > $dbb = msql_select_db($database,$connect) or die("Unable to > select Database!"); > > $sql = "SELECT * FROM dvd_main"; > > $sql_result = mysql_query($sql,$connect); > > echo "<table border=1>"; > echo "<tr><td>DVD Title</td></tr>"; > > while($row = mysql_fetch_array($sql_result)){ > > $title = $row["main_title"]; > echo "<tr><td>$title</td></tr>"; > > } > > echo "</table>"; > > mysql_free_result($sql_result); > mysql_close($connection); > ?> > > Any help would be appreciated >