Re: Help with mysql and php
Posted: Fri Aug 15, 2008 6:17 am
So if I wan't it to be outputted like this:Should the php file look like this?
Code: Select all
<div>
<img src="<pic>" style="float:left;" />
<p>Title: <title></p>
<p>Director: <director></p>
<p>Genre: <genre></p>
<p>Rating: <rating></p>
<p>Added: <added></p>
<p>Review: <review></p> <!-- Only post this if review_yesno == 1 -->
<p>IMDb-link: <imdb></p>
</div>Code: Select all
while($row = mysql_fetch_row($result)) {
echo "<div>\n";
foreach($row as $key=>$value) {
if($key=='pic') {
echo '<img src="'.$row['pic'].'" style="float:left;" />\n';
}
elseif($key=='title') {
echo '<p>Title: '.$row['title'].'</p>\n';
}
elseif($key=='director') {
echo '<p>Director: '.$row['director'].'</p>\n';
}
elseif($key=='genre') {
echo '<p>Genre: '.$row['genre'].'</p>\n';
}
elseif($key=='rating') {
echo '<p>Rating: '.$row['rating'].'</p>\n';
}
elseif($key=='Added') {
echo '<p>Added: '.$row['added'].'</p>\n';
}
elseif($key=='imdb') {
echo '<p>IMDb-link: <a href="http://imdb.com/'.$row['imdb'].'" target="_blank">IMDb</a></p>\n';
}
elseif($key=='review_yesno') {
if($value=='1') {
echo '<p>Review: '.$row['review'].'</p>\n';
}
elseif($value=='0') {
echo '<!-- No review -->\n';
}
}
}
echo "</div>\n";
}