Re: newbie: Trying to select a database in php

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