At 09:06 20. 06. 01 +0100, you wrote:
>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


Hi !

try this

<?
echo "<table border=1>";
echo "<tr><td>DVD Title</td></tr>";
$connection = mysql_connect("$server","$username","$pass") or die ("Unable 
to connecto to MySQL Server");
$db = mysql_select_db("$database", $connection) or die ("Unable to get 
requested database");

$sql = "SELECT * FROM dvd_main";

>$sql_result = mysql_query($sql,$connection)or die ("Couldn't execute SQL 
>query");
>while($row = mysql_fetch_array($sql_result)){
>
>$title = $row["main_title"];
>echo "<tr><td>$title</td></tr>";
>};
>
>echo "</table>";

?>

hope this helps....

Dino Krstulovic
SDnet software
www.sdnet.hr







-- 
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