Good Afternoon Skunks,
Below is my PHP code that is meant to run an SQL Select query however it doesn't seem to be working. All I'm getting when I open it in the browser (";
}
mysql_close($con);
?>
")
Please assist.
Kind regards.
<html>
<head>
<title>PHP Test</title>
</head>
<body>
<?php
//SQL Part
$host="localhost";
$username="root";
$password="*****";
$conn= mysql_connect($host,$username,$password) or exit("Connection Error".mysql_error());
mysql_select.db('sample') or exit("Database not found");
//Data from the query is stored in $result
$result = mysql_query($conn,"SELECT * FROM Customers");
while($row = mysql_fetch_array($result))
{
echo $row['CustomerName'] . " " . $row['ContactName'];
echo "<br>";
}
mysql_close($conn);
?>
</body>
</html>