STHS Forum

Yeah I see how where it is in the database just not coming up with a way to get it to query the top X # of players and then output those into a table.

Awesome! Thanks Simon.

Yeah I see the birthday is in the database but there's nothing in the database that actually has the age of the players? I guess I would need to find some SQLite 3 formula to take today's date and figure out the difference in years?

Awesome looking site. I too am trying to setup a site using the SQLite database. Any pointers you could offer? I've been successful pulling roster info but I'm not struggling to setup team and league leaders like you have on your site. Any info would be greatly appreciated.

I think I'm past the table sizing issue. Now I'm trying to pull in team and league leaders as a side bar. Not having much luck so far. Anyone have any pointers for doing so?

So there's not way to pull age from the SQLite database?

In the PlayerInfo.php file you have an echo from PlayerInfo table column 'Age'. I'm not seeing that column at all in the database that I created from the demo nor the database from the league I'm in. Is there a setting somewhere within STHS to output the Age column to the SQLite database?

Yeah that's what I'm doing. I'm getting all the data back as an array then echoing the data into a table. Problem is the table doesn't seem to be take any html format commands.

Anyone have any ideas with regards to the table that has the roster going outside the body of the website?

So now the new issue...When I pull the data back into the site it goes outside of the page border which I have set to 1000px. I have a div id set and it is inside the border but the tables it pulls it go outside of that. Any ideas? I've tried putting width="819px" (I have a menu on the lef...

Never mind...I was able to do it using LIKE '%$FarmTeamName%' rather than trying to combine the values from 2 separate columns in 2 separate tables.

That worked like a charm...Much appreciated! So now I notice the Farm Team name in PlayerInfo has the pro team abbreviation at the end. Any idea how I can combine the "SELECT Name FROM TeamFarmInfo WHERE Number = '$Team'" and "SELECT Abbre FROM TeamProInfo WHERE Number = '$Team'"...

Alright I've been successful in pulling roster info based on Team # in PlayerInfo, but as you can imagine that is causing the roster page to display all players that meet the team number (pro and farm). I'm trying to separate the pro from the farm based on the team name in the PlayerInfo table but I...

Thanks for the encouragement Foo...I'm stumbling along to figure it out. I work in IT but I'm on the server virtualization side so this programming side is a bit foreign to me.

Understood. Thanks for the assistance so far.