PDA

View Full Version : SQL Query (All Stats from a known player)



Caulk
08-29-2010, 08:42 AM
Hallo everybody!

I want to create a report and for this I need the right sql-statement. In this report I want to display all stats from a known player in a specific timerange for a specific FLSH cash game limit.
How do I do that?

Player = "testplayer"
Timerange = Between Jul 28, 2010 05:30:00,Aug 28, 2010 00:30:00
Game = "Fixed Limit 2 to 6 Player"
Limit = "0,02/0,04"


Greetz
Caulk

Caulk
08-30-2010, 02:53 PM
Hi there!

After a very long night, I managed it.

Thanks anyway.

Greetz
Caulk

sdf000
09-08-2010, 06:51 AM
<div style="margin:20px; margin-top:5px; ">
<div class="smallfont" style="margin-bottom:2px">Quote:</div>
<table cellpadding="6" cellspacing="0" border="0" width="100%">
<tr>
<td class="alt2" style="border:1px inset">

<div>
Originally Posted by <strong>Caulk</strong>
<a href="showthread.php?p=172374#post172374" rel="nofollow"><img class="inlineimg" src="images/buttons/viewpost.gif" border="0" alt="View Post" /></a>
</div>
<div style="font-style:italic">Hi there!<br />
<br />
After a very long night, I managed it.<br />
<br />
Thanks anyway.<br />
<br />
Greetz<br />
Caulk</div>

</td>
</tr>
</table>
</div>hey Caulk, can you share your query? I'm trying to do very similar thing, but no success so far