# Will "HELP ME!" do? \[php\]

**URL:** <https://forum.kirupa.com/t/will-help-me-do-php/256002>\
**Category:** Uncategorized\
**Created:** [March 29, 2008, 1:01am UTC](https://forum.kirupa.com/t/will-help-me-do-php/256002 "2008-03-29T01:01:19Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![chrisclick](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/chrisclick/32/1991_2.png) [@chrisclick](https://forum.kirupa.com/u/chrisclick)\
**Post date:** [March 29, 2008, 1:01am UTC](https://forum.kirupa.com/t/will-help-me-do-php/256002/1 "2008-03-29T01:01:19Z")

</div>

ok, I have this code:

```php

<?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

<?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?
