Need Php code to display the probability for the given number

[rishibala143]

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

[rajivgonsalves]

what connection does 2 have with H and L ? please elaborate

[rishibala143]

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

[blueman378]

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.