display fetch array result help

RickyD77

ok i have to do something like that i know i have to read through mysql_fetch_array

	while ($r2 = mysql_fetch_array($result2))

i need to display the result like this
<tr>
<td>result1</td>
<td>result2</td>
</tr>
<tr>
<td>result3</td>
<td>result4</td>
</tr>
}

thx Eric
and scuse my english

aaron_karp

Here's an example of how to display the results:

while ($r2 = mysql_fetch_array($result2)) {

$currentThing = $r2['thing']; // Where 'thing' is the column name
$currentType = $r2['type']; // Where 'type' is the column name

// This stores the values of those columns as $currentThing and $currentType, respectively. You can now use those values in your PHP code, so long as you're still within the loop.

echo "

Thing: $currentThing<br>
Type: $currentType<p>

} // A common mistake is to leave out the last brace of the while loop

The way this works is that each time through the loop, it assigns the value of the column to the variable. Then it runs the echo() "function" to output to the browser the results.

If I didn't explain this well enough, let me know and I'll try to resolve any confusion.

Arc

or you can just say
Print $r2[0];
Print $r2[1];
Print $r2[2];

etc...

0 being the first item in the returned array, 2 being the third..

RickyD77

im sory
heres the full code and what im trying to do

$q2="SELECT * FROM video ORDER BY date DESC LIMIT 0,4";
$result2 =mysql_query($q2) or die(sqlerrmessage($q));

while ($r2 = mysql_fetch_array($result2)){
in need to display the result like this

<tr>
<td>$r2['image']</td>
<td>$r2['image']</td>
</tr>
<tr>
<td>$r2['image']</td>
<td>$r2['image']</td>
</tr>

}
im sure you understand the $r2['image'] was not the same lol

thx Eric

aaron_karp

Your code looks good to me - just make sure you have some sort of function that outputs the HTML to the page, such as echo() or print()

echo "

<html tag> Text, $variable </tag>

RickyD77

the problem i have is to display the result like this

while...
i have 4 row to display

<tr>
<td>$r2['image'](first result)</td>
<td>$r2['image'](second result)</td>
</tr>
<tr>
<td>$r2['image'](third result)</td>
<td>$r2['image'](fourth result)</td>
</tr>
if i put the while outside that would display 4 time the <tr>...</tr>time the

thx Eric

aaron_karp

Every time through the while loop it will spit out those 4 rows. If you only want it to spit out one row each time it goes through the loop, you should only have one <tr>...</tr> inside the loop. You can also do it like this:

while ($r2 = mysql_fetch_array($result2)) {

if (c==1) { echo "
<tr>$r2['result2']"</tr>
$c = 2
} else if (c==2) { echo "
<tr>$r2['result3']"</tr>
$c = 3
} else if (c==3) { echo "
<tr>$r2['result4']"</tr>
$c = 4
} else if (c==4) { echo "
<tr>$r2['result5']"</tr>
}

}

I could be completely wrong - it's 10 AM, I just woke up, and have to go to class. I'll check back in a little bit.