use COALESCE(). ORDER BY COALESCE(price,999999) will return the value of the price column if it is set, or 999999 if it is null
SELECT * FROM items ORDER BY COALESCE(price,999999) ASC
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.