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:[EMAIL PROTECTED]]
> Sent: Wednesday, June 20, 2001 10:07 AM
> To: [EMAIL PROTECTED]
> 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
>
--
PHP Database 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]