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]

Reply via email to