Hi, (I am new to PHP my pages were in ASP before)
I am getting the error message :
Fatal error: Call to undefined function: msql_select_db() in ..... on line 16
Line 16 is :
msql_select_db("fixtures",$db_handle);
Thanks in advance for any help / advice.
Whole Code
<TABLE width="100%" border="0" cellpadding="10" cellspacing="0">
<table border="0" cellpadding="1" cellspacing="1" width="100%">
<tr>
<td class="EventTitle" valign="top" align="center" bgcolor="#D0F0D0">Pos</td>
<td class="EventTitle" valign="top" align="left" bgcolor="#D0F0D0">Team Name</td>
<td class="EventTitle" valign="top" align="center" bgcolor="#D0F0D0">Played</td>
<td class="EventTitle" valign="top" align="center" bgcolor="#D0F0D0">Won</td>
<td class="EventTitle" valign="top" align="center" bgcolor="#D0F0D0">Drawn</td>
<td class="EventTitle" valign="top" align="center" bgcolor="#D0F0D0">Lost</td>
<td class="EventTitle" valign="top" align="center" bgcolor="#D0F0D0">+ / -</td>
<td class="EventTitle" valign="top" align="center" bgcolor="#D1D1E9">Points</td>
<td class="EventTitle" valign="top" align="right" bgcolor="white">Last 6</td>
</tr>
<?
$db_handle = mysql_connect("default","root","");
msql_select_db("fixtures",$db_handle);
$myquery = msql_query("SELECT TableDate, Position, TeamID, TeamName, Played, Won, Drawn, Lost, GoalDifference, Points, TeamForm FROM LeagueTable",$db_handle);
while($rs = msql_fetch_array($myquery)){
if($BGColor == "#F7F7E7"){
$BGColor="#E7E7D6" ;
} else {
$BGColor="#F7F7E7";
}
?>
<div ALIGN="center">
<tr BGCOLOR="<?echo ($BGColor);?>">
<td class="description" valign="top" align="center"><?php echo $rs["Position"]; ?> </td>
<td class="description" valign="top" align="left"><?php echo $rs["TeamName"]; ?></td>
<td class="description" valign="top" align="center"><?php echo $rs["Played"]; ?></td>
<td class="description" valign="top" align="center"><?=$rs["Won"]?></td>
<td class="description" valign="top" align="center"><?=$rs["Drawn"]?></td>
<td class="description" valign="top" align="center"><?=$rs["Lost"]?></td>
<td class="description" valign="top" align="center"><?=$rs["GoalDifference"]?></td>
<td class="description" valign="top" align="center" bgcolor="#D1D1E9"><?=$rs("Points")?></td>
<td class="description1" valign="top" bgcolor="white" align="right"><?=$rs["TeamForm"]?></td>
</tr>
<? } ?>
</table>
</div>
