Ok Jon,
I am setting up a small bidding system. I have a table with one column for
BID and the other for MAX_BID with each row having a unique id number.
Anyone have a simple query example where I can select ID, BID, MAX_BID and
sort in descending order the BID and MAX_BID as if it were one column?
Example_tbl
id bid max_bid
1 .2 .4
2 .1 .2
3 .4 .0
4 .4 .7
5 .7 .7
Selecting the id and creating X_BID in the query result which is the
combined bid columns, ordering by the BID and MAX_BID
Result_Set
ID X_BID
5 .7
4 .7
3 .4
1 .4
2 .2
Make any sense ? Any thoughts on the AS and ORDER BY for this ?
=Yes it makes sense, except that you haven't defined the term combined for the bid
columns. May I take it to
mean 'max_bid if it exists, or bid otherwise'?
=1 Code the SQL as if you were wanting to list Result_Set using only max_bid, and
label (AS) the max_bid column
CombinedBid.
=2 Now get the resultset into the desired sequence using CombinedBid.
=3 Finally deal with the selection of either max_bid or bid in the CombinedBid column
- if max_bid 0, use
max_bid, else use bid.
- check out the manual for IF()
=Let us know how you get on,
=dn
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php