will "HELP ME!" do? [php]

[chrisclick]

ok, I have this code:



<?php
$result = mysql_query("SELECT * FROM pms, users WHERE pms.from_id = users.user_id AND to_id = '$id'")
or die(mysql_error());
while($row = mysql_fetch_array( $result )) {
echo $row['pm_subject'];
}
?>


but its only showing ONE record out of two... But when i use :



<?php
$result = mysql_query("SELECT * FROM pms WHERE to_id = '$id'")
or die(mysql_error());
while($row = mysql_fetch_array( $result )) {
echo $row['pm_subject'];
}
?>


it gets all the records...

Can anyone explain what im doing wrong?

[CharlestheFish]

pms.from_id = users.user_id

[evildrummer]

try pms.to_id instead of just to_id