get users name from id in another table

[queerfm]

Hi I have two table one called user and the other call msg.

In msg i have from_id, to_id and read

I am waiting to get the username of the from_id and it on the users page so the user knows who sent the message. at the moment it is only showing the users ID.

I tryed the following but it did not work.



<?php
$sql = 'SELECT * FROM `msg`';
$query = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_assoc($query))
{
$from = $row[from_id];
$to_id = $row[to_id];
$msgid = $row[msgid];

$user = 'SELECT * FROM `users` WHERE `id` ='.$from;
$userquery = mysql_query($user);
while($usermsg = mysql_fetch_array($userquery))
{
$msg_from_image = $usermsg[username];

?>
From | reply? | Delete
<form>
<?php echo $msg_from_image;?>
<input id="delete" value="0" name="to" size="10" Type="hidden"> <input class="button" onClick="ajaxFunction();" value="Enter" type="button" >
</form>

<?php
}
}
?>


If any one can help that would be great.

[ganu]

i think there is no matching between id in users table and from_id in msg table,
means in user table the id values are 1,2,3,45.
and in msg table the from_id values are 0,6.7,8
ex:
SELECT * FROM `users` WHERE `id` ='6';
id 6 is not in users table

[amutha]

try this on query of user table


$user ="SELECT * FROM `users` WHERE `id` ='$from'";

i mention the error. if you correct it. i think, it may working... :)