STHS Forum

Thanks, it's been a while since I've worked on this since Dreamweaver decided to overwrite my almost complete style.css file. But I appreciated your input.

English translation? Looks like something about web sites and SQLite?

If I make your changes then I only get whole numbers. For instance I had 1.8, 2.2, 2.7, 2.8 and I now have 1, 2, 2, 3.

Alright sounds good. Thanks!

Hey Simon. Any ideas what changes in the SQLite DB? Any chance Age as an integer will be there? What about more info for transactions? Like Team 1 with either the team name or team number then the players/picks/money then the same for Team 2? I'm finding it quite hard to get a nice personalized tran...

Of course I've been looking at this for a few days and once I post this I figure it out. Here's what worked for me: SELECT GoalerInfo.Name, GoalerInfo.Number, GoalerInfo.Team, GoalerProStat.SA, GoalerProStat.GA, GoalerProStat.GP, ROUND((CAST(GoalerProStat.GA AS REAL) / (GoalerProStat.SecondPlay / 60...

Hey guys, Still trying to put a web site together based off the SQLite DB. I'm making progress but I'm having an issue calculating GAA. I know what the calculation should be (GoalerProStat.GA / (GoalerProStat.SecondPlay / 60))*60 but I can't seem to put that into PHP code. Anyone have any ideas? Tha...

That works perfectly! I had no idea you could query multiple tables in one statement by doing TableName.Column. Thanks for the info Simon!

The problem is querying PlayerInfo for TeamNumber/Name then using that array against PlayerProStat. I'm just not sure how to do that and limit the array to say 5 results (players).

Also, any idea how I could pull the team name or team abbreviation from TeamProInfo table to go along with the player name and stats for the league leaders?

Never mind Simon sorted me out.

It's too bad the PlayerProStat table doesn't have TeamNumber or TeamName as a column that would have made this much easier. Trying to get the roster from PlayerInfo based on TeamName or TeamNumber then taking that to PlayerProStat is a pain. I was able to pull back data now but I can't figure out ho...

I'm also trying to figure out how I would take this array ($PlayerNameQuery = $db->query("SELECT Name FROM PlayerInfo WHERE TeamName = '$TeamName'"); while ($row3 = $PlayerNameQuery ->fetchArray())) which gets the player name based on the team name and compare it to the PlayerProStat table...

Not sure if it matters or not, but I'm actually trying to do this all without having to setup a SQL database rather just using the SQLite database. The LIMIT function seems to work. I'll start incorporating this and see what I get. I've tried Googling SQL commands but most of them don't seem to work...

How's everyone outputting team transactions and team/league leaders? I'm trying to build a PHP site using the SQLite database and I haven't found a good way to query the database to pull team transactions. I've gotten it to the point where it will out put TRADE : From $TeamName to Team2 : Player (OV...