Search found 43 matches
- Mon Nov 30, 2015 1:31 pm
- Forum: Website Forum / Forum de Page Web
- Topic: Trying to setup PHP Template Website
- Replies: 24
- Views: 23564
Re: Trying to setup PHP Template Website
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.
- Sat Oct 17, 2015 11:08 pm
- Forum: Announcements / Annonces
- Topic: STHS Version 3!
- Replies: 75
- Views: 52577
Re: STHS Version 3!
English translation? Looks like something about web sites and SQLite?
- Fri Oct 09, 2015 7:27 am
- Forum: Website Forum / Forum de Page Web
- Topic: Calculating GAA from SQLite DB
- Replies: 3
- Views: 3583
Re: Calculating GAA from SQLite DB
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.
- Sat Oct 03, 2015 11:13 am
- Forum: Announcements / Annonces
- Topic: STHS Version 3!
- Replies: 75
- Views: 52577
Re: STHS Version 3!
Alright sounds good. Thanks!
- Sat Oct 03, 2015 8:13 am
- Forum: Announcements / Annonces
- Topic: STHS Version 3!
- Replies: 75
- Views: 52577
Re: STHS Version 3!
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...
- Thu Oct 01, 2015 8:53 am
- Forum: Website Forum / Forum de Page Web
- Topic: Calculating GAA from SQLite DB
- Replies: 3
- Views: 3583
Re: Calculating GAA from SQLite DB
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...
- Thu Oct 01, 2015 8:43 am
- Forum: Website Forum / Forum de Page Web
- Topic: Calculating GAA from SQLite DB
- Replies: 3
- Views: 3583
Calculating GAA from SQLite DB
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...
- Fri Sep 18, 2015 7:26 am
- Forum: Website Forum / Forum de Page Web
- Topic: Transactions & Team/League Leaders?
- Replies: 9
- Views: 6505
Re: Transactions & Team/League Leaders?
That works perfectly! I had no idea you could query multiple tables in one statement by doing TableName.Column. Thanks for the info Simon!
- Thu Sep 17, 2015 8:23 pm
- Forum: Website Forum / Forum de Page Web
- Topic: Transactions & Team/League Leaders?
- Replies: 9
- Views: 6505
Re: Transactions & Team/League Leaders?
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).
- Thu Sep 17, 2015 4:44 pm
- Forum: Website Forum / Forum de Page Web
- Topic: Website built with SQLite
- Replies: 16
- Views: 13020
Re: Website built with SQLite
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?
- Thu Sep 17, 2015 3:21 pm
- Forum: Website Forum / Forum de Page Web
- Topic: Website built with SQLite
- Replies: 16
- Views: 13020
Re: Website built with SQLite
Never mind Simon sorted me out.
- Thu Sep 17, 2015 1:03 pm
- Forum: Website Forum / Forum de Page Web
- Topic: Transactions & Team/League Leaders?
- Replies: 9
- Views: 6505
Re: Transactions & Team/League Leaders?
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...
- Thu Sep 17, 2015 12:23 pm
- Forum: Website Forum / Forum de Page Web
- Topic: Transactions & Team/League Leaders?
- Replies: 9
- Views: 6505
Re: Transactions & Team/League Leaders?
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...
- Thu Sep 17, 2015 9:11 am
- Forum: Website Forum / Forum de Page Web
- Topic: Transactions & Team/League Leaders?
- Replies: 9
- Views: 6505
Re: Transactions & Team/League Leaders?
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...
- Thu Sep 17, 2015 8:42 am
- Forum: Website Forum / Forum de Page Web
- Topic: Transactions & Team/League Leaders?
- Replies: 9
- Views: 6505
Transactions & Team/League Leaders?
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...