Relate two tables (user id and username)

[matthewamzn]

I have two tables. The first has usernames and id's. The second has messages and user id's. How can I get the username beside each message?

(user_id and id have the same values)

<?php
$user_query = "SELECT id, username FROM v_users";
$user_result = mysql_query($user_query);
}

$message_query = "SELECT user_id, message, time FROM v_messages ORDER BY time ASC LIMIT 20";
$message_result = mysql_query($message_query);
}

while ($message = mysql_fetch_array($message_result)) {
echo $message[1] . "<br/>";
}
?>

[cameraman]

Nuke the first query (unless you need it for something else). Change the second query to:
SELECT user_id, message, time,username FROM v_messages, v_users WHERE (id=user_id) ORDER BY time ASC LIMIT 20

[matthewamzn]

Thanks, works great!