Mega Code Archive
Get data from database query
<![CDATA[
<html>
<body>
<ul>
<?php
$cnx = mysql_connect('mysql153.secureserver.net','rntsoft','password');
mysql_select_db('rntsoft');
$employees = @mysql_query('SELECT ID, FirstName FROM Employee');
if (!$employees) {
die('<p>Error retrieving employees from database!<br />'.
'Error: ' . mysql_error() . '</p>');
}
while ($employee = mysql_fetch_array($employees)) {
$id = $employee['ID'];
$name = htmlspecialchars($author['Name']);
echo("$name <br>");
echo("$id <br>");
}
?>
</ul>
</p>
</body>
</html>
]]>