Any ideas?????
Moderator: General Moderators
- aceconcepts
- DevNet Resident
- Posts: 1424
- Joined: Mon Feb 06, 2006 11:26 am
- Location: London
Re: Any ideas?????
hI Dave,
How's going?
Have you created those tables?
How's going?
Have you created those tables?
Re: Any ideas?????
hey,
yeah created the tables how i think they should be andput a little info in them,
what shall i do next???
yeah created the tables how i think they should be andput a little info in them,
what shall i do next???
- aceconcepts
- DevNet Resident
- Posts: 1424
- Joined: Mon Feb 06, 2006 11:26 am
- Location: London
Re: Any ideas?????
have you done any coding yet?
Re: Any ideas?????
The only thing I know what to do is open the connection to the database like I did before for displaying the fixtures table????
Where shall I go from here????
Where shall I go from here????
Re: Any ideas?????
What have you tried?
We are here to help you learn.
Next you should look into using forms to manage your database tables. INSERT queries, UPDATE queries, SELECT queries, and DELETE queries.
Next you should look into using forms to manage your database tables. INSERT queries, UPDATE queries, SELECT queries, and DELETE queries.
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
Re: Any ideas?????
Ive never used forms before but i do understand how they work, whats the quickest way i can learn them?????
Really need this work getting done.
Really need this work getting done.
- aceconcepts
- DevNet Resident
- Posts: 1424
- Joined: Mon Feb 06, 2006 11:26 am
- Location: London
Re: Any ideas?????
Ok,
So the main thing you're gonna want to do is display the fixtures so that the players can select which games they don't want to play.
Create a file called "fixtures_list.php"
This file will list all the fixtures.
So the main thing you're gonna want to do is display the fixtures so that the players can select which games they don't want to play.
Create a file called "fixtures_list.php"
This file will list all the fixtures.
- aceconcepts
- DevNet Resident
- Posts: 1424
- Joined: Mon Feb 06, 2006 11:26 am
- Location: London
Re: Any ideas?????
Code: Select all
//QUERY FOR THE FIXTURE DATA
$fixtQry=musql_query("SELECT * FROM tblFixtures INNER JOIN tblTeam ON tblFixtures.intTeamId=tblTeam.intTeamId ORDER BY fixtureDate");
//the above query will query the database for all of the fixtures, however, i don't know the names of your fields so replace where necessary.
//the INNER JOIN will join the fixtures table with the team table - this means that all teams that have games will be displayed.
//in order for this to work you will have to have a unique id field for both tables.
Re: Any ideas?????
Ok this is what i have put together so far. are you saying i need to add team id to the tblfixtures aswell?
<?php
$database = "localhost"; //login to the server
$username = "Dave"; //username login
$password = "*****"; //password login
//connection to the database
$dbhandle = mysql_connect($hostname, $username, $password)
or die("<br><br>Unable to connect to Lincoln Database");
echo "<br><br>Connected to Lincoln Database<br><br>";
//select a database to work with
$selected = mysql_select_db("lincolnrugby",$dbhandle)
or die("Could not select lincoln rugby");
$fixtQry=musql_query("SELECT * FROM tblFixtures INNER JOIN tblTeam ON tblFixtures.intTeamId=tblTeam.intTeamId ORDER BY fixtureDate");
//close the connection
mysql_close($dbhandle);
?>
<?php
$database = "localhost"; //login to the server
$username = "Dave"; //username login
$password = "*****"; //password login
//connection to the database
$dbhandle = mysql_connect($hostname, $username, $password)
or die("<br><br>Unable to connect to Lincoln Database");
echo "<br><br>Connected to Lincoln Database<br><br>";
//select a database to work with
$selected = mysql_select_db("lincolnrugby",$dbhandle)
or die("Could not select lincoln rugby");
$fixtQry=musql_query("SELECT * FROM tblFixtures INNER JOIN tblTeam ON tblFixtures.intTeamId=tblTeam.intTeamId ORDER BY fixtureDate");
//close the connection
mysql_close($dbhandle);
?>
- aceconcepts
- DevNet Resident
- Posts: 1424
- Joined: Mon Feb 06, 2006 11:26 am
- Location: London
Re: Any ideas?????
i'll post back tomorrow