16 DRAWS
{sqlquery pre.ifox.com "tennis" "te-te_bi-se_rw" tennis} SELECT * FROM tscores WHERE 1=1 {if [drawseed]}AND drawseed ="[drawseed sql]"{fi} {if [player1]}AND player1 LIKE "%[player1 sql]%"{fi} {if [player2]}AND player2 LIKE "%[player2 sql]%"{fi} {if [matchnotes]}AND matchnotes LIKE "%[matchnotes sql]%"{fi} {if [tourname]}AND tourname LIKE "%[tourname sql]%"{fi} {if [matchcity]}AND matchcity LIKE "%[matchcity sql]%"{fi} {if [pointswon]}AND pointswon LIKE "%[pointswon sql]%"{fi} {if [round]}AND round="[round sql]"{fi} {if [matchstate]}AND matchstate LIKE "%[matchstate sql]%"{fi} {if [circuit]}AND circuit LIKE "%[circuit sql]%"{fi} {if [matchdate]}AND matchdate LIKE "%[matchdate sql]%"{fi} {if [partner1]}AND partner1 LIKE "%[partner1 sql]%"{fi} order by matchdate DESC {/sqlquery} {sqlerror}
| Date |
Seed |
Winner |
points |
Loser |
set 1 |
|
set 2 |
|
set 3 |
|
won |
loss |
Tournament |
Round |
{sqldata}
| [matchdate html] |
[drawseed html]
| [player1 html] |
[pointswon html] |
[player2 html] |
[s1 html] |
[sc1 html] |
[s2 html] |
[sc2 html] |
[s3 html] |
[sc3 html] |
[sw html] |
[sl html] |
[tourname html] |
[round html] |
{/sqldata}
|
| 16 Singles |
Second
Round - Section 1 2 |
{sqlquery pre.ifox.com "tennis" "te-te_bi-se_rw" tennis}
|
|
|
| (1) |
0 |
6 |
3 |
| vs. |
|
|
Xavier Malisse |
| (16) |
6 |
3 |
6 |
 |
 |
| (8) |
3 |
4 |
6 |
| vs. |
Match Statistics |
|
Tim Henman |
| (14) |
6 |
6 |
3 |
|
|
|
|
| (4) |
0 |
6 |
3 |
| vs. |
|
|
Xavier Malisse |
| (12) |
6 |
3 |
6 |
|
|
| (6) |
3 |
4 |
6 |
| vs. |
Match Statistics |
|
Tim Henman |
| (10) |
6 |
6 |
3 |
|
|
|
|
| (9) |
0 |
6 |
3 |
| vs. |
|
|
Xavier Malisse |
| (5) |
6 |
3 |
6 |
|
|
| (11) |
3 |
4 |
6 |
| vs. |
Match Statistics |
|
Tim Henman |
| (3) |
6 |
6 |
3 |
|
|
|
|
| (13) |
0 |
6 |
3 |
| vs. |
|
|
Xavier Malisse |
| (7) |
6 |
3 |
6 |
|
|
| (15) |
3 |
4 |
6 |
| vs. |
Match Statistics |
|
Tim Henman |
| (2) |
6 |
6 |
3 |
|
|
