mysql_Fet

[Anon]

I am getting results from a query..lets say its select * from figures. I want to print out each row in opposite tables..if that makes any sense. I was thinking of using mod to find out if it is odd or even, then print out the html that way....but i'm thinking my code logic must be wrong, because it will get the 1st row just fine, but i can never get the 2nd row.....what am i doing wrong?

for ($j = 1; $aRow = mysql_fetch_row($figureresult); ++$j)
{

$mod = $j % 2;
if ($mod == 1)
{
?>
<tr>
<td width="50%">
<a href="<? echo $aRow["large"]; ?>"><img border="0" src="<? echo $aRow["small"]; ?>" width="204" height="189" ></a></td>
<td width="50%">
<b>Figure <? echo $j; ?>.</b><br>
</p>
</td>
</tr>
<? }
elseif ($mod == 0)
{ ?>
<tr>
<td width="50%">
<p align="center"><strong>Figure <? echo $j; ?>.</strong><br>
</p>
</td>
<td width="50%">
<a href="<? echo $aRow["large"]; ?>"><img border="0" src="<? echo $aRow["small"]; ?>" width="204" height="189"></a></td>
</tr> <? } else { echo "no results found"; } } ?>

[Anon]

What you want to do is execute the query, and put 'even' records into one array, then 'odd' records into the other array. Finish the mysql stuph.

Then do the HTML output with the 'odd' array then again with the 'even' array, or vice versa, trip on this:

$oddArr=array();
$eveArr=array();
$flag=1;
while($row=mysql_fetch_array(your_query)){
if ($flag==1) {
$oddArr[]=$row['fieldhere'];
$flag=1;
} else {
$eveArr[]=$row['fieldhere'];
$flag=0;
} /end-if-else/
} /endWhile*/

NOW THE HTML
--table---
foreach($oddArr as $shazam) {
print("<td>each $shazam in the odd array</td>");
}
--/table--

--table---
foreach($eveArr as $waboo) {
print("<td>each $waboo in the even array</td>");
}
--/table--

arrays, d00d, good luck

[Anon]

ME THINKS SHOULD BE

$oddArr=array();
$eveArr=array();
$flag=0;
while($row=mysql_fetch_array(your_query)){
if ($flag==1) {
$oddArr[]=$row['fieldhere'];
$flag=0;
} else {
$eveArr[]=$row['fieldhere'];
$flag=1;
} /end-if-else/
} /endWhile*/

[Anon]

actually, this doesnt do what i want...

i mean it sort of does, but it doesnt print out the way i want. i want to alternate the table for example like this

text1 image1
image2 text2
text3 image3
image4 text4

with the code above, it just prints out

text1 image1
text3 image3
image2 text2
image4 text4

[Anon]

nevermind, i just replaced the array stuff with html code and it works fine! dunno whatwas going on before...thanks