Code: Select all
echo "<b>$field1-name
$field2-name2</b><br> <img src="$field3-name"><br>$field4-name<br>$field5-name<hr><br>";
$i++;
}Moderator: General Moderators
Code: Select all
echo "<b>$field1-name
$field2-name2</b><br> <img src="$field3-name"><br>$field4-name<br>$field5-name<hr><br>";
$i++;
}musson wrote:I only want to make a picture apear for each item I will have in my db. whats wrong in that script ? field3-name is a picture url.
echo "<b>$field1-name
$field2-name2</b><br> <img src="$field3-name"><br>$field4-name<br>$field5-name<hr><br>";
$i++;
}
thanks
Code: Select all
echo "<b>$field1-name
$field2-name2</b><br> <img src='$field3-name'><br>$field4-name<br>$field5-name<hr><br>";
$i++;
}Code: Select all
mysql_select_db("$database", $con);
$result = mysql_query("SELECT * FROM product ORDER BY ID");
$num=mysql_numrows($result);
echo "<b><center>Database Output</center></b><br><br>";
$i=0;
while ($i < $num) {
$field1-name=mysql_result($result,$i,"name");
$field2-name=mysql_result($result,$i,"price");
$field3-name=mysql_result($result,$i,"picture");
$field4-name=mysql_result($result,$i,"field4-name");
$field5-name=mysql_result($result,$i,"field5-name");
echo "<b>$field1-name
$field2-name2</b><br>
<img src='$field3-name'><br>
$field4-name<br>$field5-name<hr><br>";
$i++;
}
mysql_close($con);
?>Code: Select all
<?php
mysql_select_db("$database", $con);
$result = mysql_query("SELECT * FROM product ORDER BY ID");
$num = mysql_numrows($result);
echo "<h1><div align='center'>Database Output</div></h1>";
if ($num != 0){
foreach($result->result() as $field)
{
echo("<b>".$field->field1." ".$field->field2."</b><br/><img src='".$field->field3."'><br/>".$field->field4."<br/>".$field->field5."<hr/><br/>");
}
} else {
echo("No Results Found");
}
mysql_close($con);
?>
Code: Select all
# <?php
# mysql_select_db("$database", $con);
# $result = mysql_query("SELECT * FROM product ORDER BY ID");
# $num = mysql_numrows($result);
# echo "<h1><div align='center'>Database Output</div></h1>";
#
# if ($num != 0){
# foreach($result->result() as $field)
# {
# echo("<b>".$field->field1." ".$field->field2."</b><br/><img src='".$field->field3."'><br/>".$field->field4."<br/>".$field->field5."<hr/><br/>");
# }
# } else {
# echo("No Results Found");
# }
# mysql_close($con);
#
# ?>
# Code: Select all
<?php
mysql_select_db($database, $con);
$result = mysql_query("SELECT * FROM product ORDER BY ID");
$num = mysql_num_rows($result);
echo "<h1><div align='center'>Database Output</div></h1>";
if ($num != 0){
while($row = mysql_fetch_assoc($result))
{
echo("<b>".$row['field1']." ".$row['field2']."</b><br/><img src='".$row['field3']."'><br/>".$row['field4']."<br/>".$row['field5']."<hr/><br/>");
}
} else {
echo("No Results Found");
}
mysql_close($con);
?>