rishibala143 Posted December 4, 2009 Share Posted December 4, 2009 Hi I need to display the probability for the given number. Suppose if the given number is 2. It should display H-H H-L L-H L-L It should generate the probability dynamically for the given number.I dont know how to do this using php.. Please help...Its Urgent... Thanks & Regards P.Balakrishnan Quote Link to comment https://forums.phpfreaks.com/topic/183942-need-php-code-to-display-the-probability-for-the-given-number/ Share on other sites More sharing options...
rajivgonsalves Posted December 4, 2009 Share Posted December 4, 2009 what connection does 2 have with H and L ? please elaborate Quote Link to comment https://forums.phpfreaks.com/topic/183942-need-php-code-to-display-the-probability-for-the-given-number/#findComment-971020 Share on other sites More sharing options...
rishibala143 Posted December 4, 2009 Author Share Posted December 4, 2009 Hi SELECT team_id, GROUP_CONCAT( play_result, round_no ORDER BY round_no SEPARATOR '-' ) AS team_res, SUM( play_total ) AS total FROM tbl_play GROUP BY team_id HAVING team_res = 'W1-W2' || team_res = 'W1-L2' || team_res = 'L1-W2' || team_res = 'L1-L2' ORDER BY total DESC In this above query the win and loss is hardcoded for two rounds...If there is 3 round i have to write like this SELECT team_id, GROUP_CONCAT( play_result, round_no ORDER BY round_no SEPARATOR '-' ) AS team_res, SUM( play_total ) AS total FROM tbl_play GROUP BY team_id HAVING team_res = 'W1-W2-W3' || team_res = 'W1-W2-L3' || team_res = 'W1-L2-W3' etc... So only i need to generate the probability of given number(i.e round number.) Please help Quote Link to comment https://forums.phpfreaks.com/topic/183942-need-php-code-to-display-the-probability-for-the-given-number/#findComment-971025 Share on other sites More sharing options...
blueman378 Posted December 4, 2009 Share Posted December 4, 2009 well where is your attempt at this? also do not post multiple topics for the same question [http://www.phpfreaks.com/forums/index.php/topic,279422.0.html] show us your attempt and we will help, this is not a freelance board. Quote Link to comment https://forums.phpfreaks.com/topic/183942-need-php-code-to-display-the-probability-for-the-given-number/#findComment-971056 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.