Untitled

<html>
<head>
</head>
<body>
<?php
include ('mysql_connect.php');
$query = "SELECT id, strainname, author, review, source, type, looks, smell, taste, effect, potency, imagelink, DATE_FORMAT(date, '%M %d, %Y') as sd FROM strain_review";
$result = @mysql_query($query);

if ($result) {
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo '<p><b>'.$row['strainname'].'</b><br />
'.$row['sd'].'<br />
<img src="'.$row['imagelink'].'"></img>
Reviewed by : <b>'.$row['author'].'</b><br />
'.$row['review'].'<br />
Source : <b>'.$row['source'].'</b><br />
Sativa/Indica : <b>'.$row['type'].'</b><br />
Growpattern : <b>'.$row['looks'].'</b><br />
Smell : <b>'.$row['smell'].'</b><br />
Taste : <b>'.$row['taste'].'</b><br />
Effect : <b>'.$row['effect'].'</b><br />
Potency : <b>'.$row['potency'].'</b><br />
</p>';
}
} else {
echo 'There are no reviews to display';
}
?>
</body>
</html>