ok I'm having an absolute colossal of a problem trying to code this and basically what I'm I'm wanting it to do is print the data in the table like this..
INFO1 INFO5
INFO2 INFO6
INFO3 INFO7
INFO4
In a sort of table..
$query="SELECT * FROM pictures";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $num) {
$name=mysql_result($result,$i,"name");
$file=mysql_result($result,$i,"file");
$caption=mysql_result($result,$i,"caption");
$creation=mysql_result($result,$i,"creation");
$description=mysql_result($result,$i,"description");
echo'<td>';
if ($i == "1") { print "<tr>"; };
print "$name";
$i = $i + 1;
if ($i == "2") { print "</tr>"; $i = 0; };
echo'</td>';
}
?>
It's continually looping and obviously I can't get any readout.
Any sugguestions would be greatly appreciated!!
😃
