ryan1987

table: hometeam awayteam homepoints awaypoints leeds man u 3 0 leeds man u 3 0 man u leeds 0 3 i want to calculate how many points each team has. with the above data leeds should have 9 and man u 0. i have come up wth the following sql …

after my form has been submitted I want it to remember the option that has been chosen from the drop down list. I now you use SELECTED but not sure how to get it into my code. this is how my dropdown list is built: [code] while ($row=mysql_fetch_array($result)) { $name=$row["name"]; …

Hi iam having a problem with combining a few union statement together. The statements run separately without any problem. The below union outputs the following results: team points leeds 3 [code] select team ,points from ( select hometeam team, sum(homepoints) points from fixtures where competitionname = 'prem' group by hometeam …

hi i am creating a webpage with a menu down the left hand side. depending on which link in the menu you click a table on the right of will show the relavent information. the table will show the relavent information from a mysql table based on the link clicked. …

hi i am creating a webpage with a menu down the left hand side. depending on which link in the menu you click a table on the right of will show the relavent information. the table will show the relavent information from a mysql table based on the link clicked. …

hi i have a html page with a form. you enter information into the form then have a choice of 2 buttons. depending on the button you press you get taken to a different page. the php page commits the data you put into he form to the database then …

hi i want to do validation on two textboxes on my website i am creating. i want to make sure something is entered in each box before the user can proceed. the two textboxes are called teammanager and teamname and are in the form called addteam. the code i have …