get from database

[Qben]

How should i do this?:

<table>
<?php
while($row = mysql_fetch_row(mysql_query("SELECT * FROM posts WHERE board='$board'"))) {

// here i wanna get info from another table every loop..
while($rad = mysql_fetch_array(mysql_query("SELECT * FROM members WHERE username='$row[2]'"))) {
$posts = $rad['posts'];
$rank = $rad['rank'];
}
echo("
<tr>
<td>Name: " . $row[2] . "</td>
<td>Posts: " . $posts . "</td>
<td>Rank: " . $rank . "</td>
</tr>
");
}
?>
</table>

[SantaGhost]

what this code does (i think) is:

table 1 has 3 rows
table 2 has 4 rows

read table 1 row 1
	read table 2 row 1
	read table 2 row 2
	read table 2 row 3
	read table 2 row 4
read table 1 row 2
	read table 2 row 1
	read table 2 row 2
	read table 2 row 3
	read table 2 row 4
read table 1 row 3
	read table 2 row 1
	read table 2 row 2
	read table 2 row 3
	read table 2 row 4 

i dont know if this works but try putting on the 2nd loop "if" instead of "while"

[stolzyboy]

what exactly do you wanna do, maybe there is a better way to do what you want

[Qben]

i want to get info from a different member every loop

[stolzyboy]

which fields are in which tables, i think you will be able to get this done with joins

[Qben]

table 'post' has:
id | topic | post | author | time

table 'members' has:
id | username | password | posts | rank

and i want to print all posts where the topic is 'Blabla' etc.
so i need to get user 'posts' and 'rank' for each post too..