Hey Alex > select captain from stats where captain > 0 and number = '23' group by > number; > > this returns a 1 for any player with the number that matches being a > captain, however it display a 1 is it possible to make that 1 displayed as a > C on my page?
MySQL allows an IF() within the SELECT clause. =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