Moving Down Rows

jpeg

I created a HTML table in PHP with 3 columns that are within a while loop using mysql_fetch_array(). I want the program to ascend down a row each time it reaches another (TD) column, but the loop only changes to the next row only after each TR, so the 3 columns all show the field from the same row until it completely loops again.

Can someone tell me how can I manually 'push' the cursor down to see the next row for each TD?

Thanks
- Jpeg

tomhath

Post the code you have. I have no idea what it means to "push the cursor down".

drewbie

yea thats a pretty bad description of ur problem, post ur code and we'll have a lookie

stick_figure

In PostgreSQL you can do a pg_fetch_array($result, $row + 1); and skip the cursor altogether. However, then you'd need to use a for() loop instead of a while(), because you'd need to have the row number.

jpeg

Ok, here's the code. It may look involved, but all I want it to do is enter the value it gets from the database and echo it within a HTML table column <td>, then I want SQL to move down to the next row and get the next value in that row, echoing that value within the next HTML table column, but what is happenning is that the same value is echoed in all 3 columns, meaning that SQL is still reading from the same row and not descending to the next row. It seems to only move to the next row in the database when the while loop is complete <tr> - </tr>. The code within each <td> is repeative, so once you read one, the other code is the same. I hope all this makes more sense and thanks for you help.

<html>

<body>
<?

$ResultsQuery=mysql_query("SELECT * FROM PhotoTbl WHERE MainCategory='$Category' OR SubCategory1='$Category' ")
or die("DP table not functioning");
?>
<table align="center" bgcolor="#FFFFFF border="2">
<?
while ($ResultsArr=mysql_fetch_array($ResultsQuery))
{
?>
<tr>
<td>
<? // Extract out the desired fields from the database.

$ThumbFileName = $ResultsArr[Path].$ResultsArr[FileName].'.'.$ResultsArr[Type];
$EnlargeFileName = $ResultsArr[EnlargePath].$ResultsArr[FileName].'.'.$ResultsArr[Type];

<a class="black" href="DP_Enlarge.php?EnlargeFileName=
<?echo $EnlargeFileName?>">
<img src="<?echo $ThumbFileName?>" border="0"><br>
<?echo $ResultsArr[WebPhotoFileName];
"</a>"

?>
</td>

<td>
			<? 
			$ThumbFileName = $ResultsArr[Path]. $ResultsArr[FileName].'.'.$ResultsArr[Type];
			$EnlargeFileName = $ResultsArr[EnlargePath].$ResultsArr[FileName].'.'.$ResultsArr[Type];

?>
<a href="DP_Enlarge.php?EnlargeFileName=
<?echo $EnlargeFileName?>">
<img src="<?echo $ThumbFileName?>" border="0"><br>
<span class="blue">
<?echo $ResultsArr[WebPhotoFileName];
"</a>"

?> </span>
</td>

		<td>

<?
$ThumbFileName = $ResultsArr[Path]. $ResultsArr[FileName].'.'.$ResultsArr[Type];
$EnlargeFileName = $ResultsArr[EnlargePath].$ResultsArr[FileName].'.'.$ResultsArr[Type];
?>
<a href="DP_Enlarge.php?EnlargeFileName=
<?echo $EnlargeFileName?>">
<img src="<?echo $ThumbFileName?>" border="0"><br>
<?echo $ResultsArr[WebPhotoFileName];
"</a>";
?>

		</td>
	</tr>

<?
}
?>
</table>
<?
mysql_close($link);
?>

</body>
</html>

amcgrath

OK, after trying to understand what you meant, I know get it:

you want image 1 image 2 image 3

but you get image1 image 1 image1
image2 image 2 image 2

What you need to do is this:

the while loop should only loop one instance and check the record count, if you're on your third one, put in the closing/operning tr . That's it. Look up the mod function to figure out if you are ona third image.

amc