PHP将两列的顺序加在一起

Question

I have put so much research into this but most posts don't understand what i mean. How can you do multiple database columns in a query?

I have a table called users and two columns called wallet_cash and bank_cash and i then have a table in my admin cp with most cash. I want to do it ORDER BY wallet_cash + bank_cash

Order by them two variables added together but how can i do this?

My attempt so far

$result = mysql_query("SELECT * FROM users ORDER BY wallet_cash + bank_cash desc LIMIT 4");

But this just puts the same result as and doesn't add the bank_cash so like your just putting ORDER BY wallet_cash

Answer 1

Add the two fields together in your select and designate it to another value using AS. Then, you can order by the newly created column.

$result = mysql_query(SELECT *, (wallet_cash + bank_cash) AS total_cash FROM users ORDER BY total_cash desc LIMIT 4");