splashz

I have 3 tables, league, game, and line. For the sake of this post, lets say the tables are structured as follows. league idleague, leaguename, misc league info game idgame, idleague, misc game info line timestamp, idgame, misc line info I have a script that inserts data into the database every minute or so and uses the timestamp field. I want a select statement that will get the rows from the most recent timestamp, and trace back to the league table and return the leaguename of the leagues that were updated. Does that make sense? It sounds confusing even as I write it.

Hello, I am very new to both PHP and MYSQL but I am eager to learn. What I want to do is write a PHP script that will parse an XML file and insert the results into a MYSQL database. I've read a bunch of guides online and I think I have the parser structure down. I created a parser using xml_parser_create(). As I understand it, I need to create functions to handle each of the three events, startTag, endTag, and contents. This is where I am not sure what to do. What do I need to tell these functions to do when these events are triggered? I know I need to connect to the MYSQL database at some point but I do not know when. If anyone could point me in the right direction, I'd appreciate it.