Hi all,
I'm trying to run a SELECT query to show information entered on a form in descending order. I have 2 tables:
userfield
userid
field14
user
userid
username
Both userid fields are the same in each one, and field14 is the number I want sorted in descending order.
I have the query
Code:
SELECT userid,field14 FROM `vb_userfield` WHERE 1
ORDER BY field14 desc
which displays as I'd like, but instead of showing userid I'd like to show username on each row.
Can anyone help me; I think I need to create some kind of join?