Sql Query Cross Table
We have a database with two tables. We need someone to create a php page with 4 links. Each link will launch a SQL query that will export a CSV file of the records in new_players that match the criteria for each link. The links will be:
Version fr RcvOffers 1
Version fr RcvOffers NOT 1
Version en RcvOffers 1
Version en RcvOffers NOT 1
That way we split up the english and french. We also split up the french who want to receive offers and those who don’t AND we split up the English into those who want to receive offers of not. Each link should generate a CSV export of the information in the “new_players” table. Here’s what the tables and fields look like:
TABLE: new_gameplays
FIELDS:
version varchar (set to either “fr” or “en”)
player_id
TABLE: new_players
FIELDS:
player_id
firstname
lastname
dayphone
email
address
city
province
postalcode
age
rcvoffers varchar (is set to “1″ if yes)
confirm_rules
Hope that makes sense! Your PHP should also have a config section where I can set DB name, localhost, username, pass. Thanks so much!
