Displaying MySQL Records Using PHP in SHTML page

programming
1

Hi,
I’m very new in Unix programming. I use shtml pages since I want my page to use includes. I’ve read a tutorial on kirupa site and tried it on my shtml page. It didn’t work, so what should I do if I want to display records from the db using PHP through SHTML page? Is there any other way to use PHP and have include files? This is the code I used:

<?php
$connection = mysql_connect(“localhost”, “e_novative”, “e_novative”) or die(“Error connecting to database”);
mysql_select_db(“members”, $connection);
$result = mysql_query(“SELECT * FROM members ORDER BY id”, $connection) or die(“error querying database”);
$i = 0;
while($result_ar = mysql_fetch_assoc($result)){
?>
<tr <?php if($i%2 == 1){ echo “class=‘body2’”; }else{echo “class=‘body1’”;}?>>
<td>
<?php echo $result_ar[‘name’]; ?></td>
<td>
<?php echo $result_ar[‘email’]; ?>
</td>
<td>
<?php echo $result_ar[‘website’]; ?>
</td>
</tr>
<?php
$i+=1;
}
?>

Thanks is advance.