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?
