why is this getting only one thing from the database?!

[d00dle]

It's supposed to display all the posts made by that user, but it only shows the first one. I've tried ORDER BY but that doesn't seem to work... 🙁

$psd=mysql_fetch_assoc(mysql_query("SELECT * FROM `messages` WHERE `messby` = '".$u['username']."'")); 
$tpd=mysql_fetch_assoc(mysql_query("SELECT `topicname`,`topicid`,`boardnum` FROM `topics` WHERE `topicid` = '".$psd['topic']."'"));
$bpd=mysql_fetch_assoc(mysql_query("SELECT `boardname`,`boardid` FROM `boards` WHERE `boardid` = '".$tpd['boardnum']."'"));

[stolzyboy]

cuz you're only telling it to get one result

you need to loop thru the array with a while and something like mysql_fetch_array