Announcements | Last Post | |
---|---|---|
SoC Curricula | 09/30/2017 01:08PM | |
Demarcation or scoping of examinations and assessment | 02/13/2017 07:59AM | |
School of Computing Short Learning Programmes | 11/24/2014 08:37AM | |
Unisa contact information | 07/28/2011 01:28PM |
The Portfolio list.php October 06, 2013 02:37PM |
Registered: 10 years ago Posts: 57 Rating: 0 |
Re: The Portfolio list.php October 06, 2013 02:42PM |
Admin Registered: 11 years ago Posts: 6,606 Rating: 396 |
Re: The Portfolio list.php October 06, 2013 02:54PM |
Registered: 10 years ago Posts: 57 Rating: 0 |
Re: The Portfolio list.php October 06, 2013 03:14PM |
Admin Registered: 11 years ago Posts: 6,606 Rating: 396 |
Re: The Portfolio list.php October 07, 2013 12:32AM |
Registered: 10 years ago Posts: 37 Rating: 0 |
Re: The Portfolio list.php October 07, 2013 11:59AM |
Registered: 11 years ago Posts: 123 Rating: 0 |
Re: The Portfolio list.php October 07, 2013 12:09PM |
Registered: 11 years ago Posts: 167 Rating: 0 |
Re: The Portfolio list.php October 07, 2013 12:36PM |
Registered: 10 years ago Posts: 37 Rating: 0 |
Re: The Portfolio list.php October 07, 2013 01:11PM |
Registered: 11 years ago Posts: 123 Rating: 0 |
Re: The Portfolio list.php October 07, 2013 01:23PM |
Registered: 11 years ago Posts: 123 Rating: 0 |
Re: The Portfolio list.php October 21, 2013 09:01AM |
Registered: 10 years ago Posts: 11 Rating: 0 |
Language: PHPfunction getSelectionPositionPlayerFullNames(){ $query = "SELECT * FROM `selections` , playerreg WHERE selection_id = ".$selection_id; $result = mysql_query($query,$connection); confirmQuery($result); return $result; } function listSelections(){ $set = getSelectionPositionPlayerFullNames(); $output = "<table><tr> <th> Loose Head Prop </th> <th> Hooker </th> <th> Tight Head Prop </th> <th> Lock 4 </th> <th> Lock 5 </th> <th> Blindside Flanker </th> <th> Openside Flanker </th> <th> Number Eight </th> <th> Scrum Half </th> <th> Fly Half </th> <th> Left Wing </th> <th> Inside Center </th> <th> Outside Center </th> <th> Right Wing </th> <th> Full Back </th> </tr><tr>"; while ($row = mysql_fetch_array($set)){ $output .= "<td>".$row[';name';]." ".$row[';surname';]."</td> <td>".$row[';hooker';]."</td> <td>".$row[';tightHeadProp';]."</td> <td>".$row[';lock4';]."</td> <td>".$row[';lock5';]."</td> <td>".$row[';blindsideFlanker';]."</td> <td>".$row[';opensideFlanker';]."</td> <td>".$row[';numberEight';]."</td> <td>".$row[';scrumHalf';]."</td> <td>".$row[';flyHalf';]."</td> <td>".$row[';leftWing';]."</td> <td>".$row[';insideCenter';]."</td> <td>".$row[';outsideCenter';]."</td> <td>".$row[';rightWing';]."</td> <td>".$row[';fullBack';]."</td>"; } $output .= "</tr></table>"; echo $output;
Re: The Portfolio list.php October 21, 2013 09:38AM |
Admin Registered: 11 years ago Posts: 6,606 Rating: 396 |
Re: The Portfolio list.php October 21, 2013 01:53PM |
Registered: 10 years ago Posts: 11 Rating: 0 |
Language: PHPfunction getSelectionPositionPlayerFullNames(){ global $connection; $query = "SELECT CONCAT(f1.name,'; ';,f1.surname) as f1looseHeadProp, CONCAT(f2.name,'; ';,f2.surname) as f2hooker, CONCAT(f3.name,'; ';,f3.surname) as f3tightHeadProp, CONCAT(f4.name,'; ';,f4.surname) as f4lock4, CONCAT(f5.name,'; ';,f5.surname) as f5lock5, CONCAT(f6.name,'; ';,f6.surname) as f6blindsideFlanker, CONCAT(f7.name,'; ';,f7.surname) as f7opensideFlanker, CONCAT(f8.name,'; ';,f8.surname) as f8numberEight, CONCAT(f9.name,'; ';,f9.surname) as f9scrumHalf, CONCAT(f10.name,'; ';,f10.surname) as f10flyHalf, CONCAT(f11.name,'; ';,f11.surname) as f11leftWing, CONCAT(f12.name,'; ';,f12.surname) as f12insideCenter, CONCAT(f13.name,'; ';,f13.surname) as f13outsideCenter, CONCAT(f14.name,'; ';,f14.surname) as f14rightWing, CONCAT(f15.name,'; ';,f15.surname) as f15fullBack FROM selections INNER JOIN playerreg as f1 ON looseHeadProp = f1.player_id INNER JOIN playerreg as f2 ON hooker = f2.player_id INNER JOIN playerreg as f3 ON tightHeadProp = f3.player_id INNER JOIN playerreg as f4 ON lock4 = f4.player_id INNER JOIN playerreg as f5 ON lock5 = f5.player_id INNER JOIN playerreg as f6 ON blindsideFlanker = f6.player_id INNER JOIN playerreg as f7 ON opensideFlanker = f7.player_id INNER JOIN playerreg as f8 ON numberEight = f8.player_id INNER JOIN playerreg as f9 ON scrumHalf = f9.player_id INNER JOIN playerreg as f10 ON flyHalf = f10.player_id INNER JOIN playerreg as f11 ON leftWing = f11.player_id INNER JOIN playerreg as f12 ON insideCenter = f12.player_id INNER JOIN playerreg as f13 ON outsideCenter = f13.player_id INNER JOIN playerreg as f14 ON rightWing = f14.player_id INNER JOIN playerreg as f15 ON fullBack = f15.player_id "; $result = mysql_query($query,$connection); confirmQuery($result); return $result; } function listSelections(){ $set = getSelectionPositionPlayerFullNames(); $output = "<table><tr> <th> Loose Head Prop </th> <th> Hooker </th> <th> Tight Head Prop </th> <th> Lock 4 </th> <th> Lock 5 </th> <th> Blindside Flanker </th> <th> Openside Flanker </th> <th> Number Eight </th> <th> Scrum Half </th> <th> Fly Half </th> <th> Left Wing </th> <th> Inside Center </th> <th> Outside Center </th> <th> Right Wing </th> <th> Full Back </th> </tr><tr>"; while ($row = mysql_fetch_array($set)){ $output .= "<td>".$row[';f1looseHeadProp';]."</td> <td>".$row[';f2hooker';]."</td> <td>".$row[';f3tightHeadProp';]."</td> <td>".$row[';f4lock4';]."</td> <td>".$row[';f5lock5';]."</td> <td>".$row[';f6blindsideFlanker';]."</td> <td>".$row[';f7opensideFlanker';]."</td> <td>".$row[';f8numberEight';]."</td> <td>".$row[';f9scrumHalf';]."</td> <td>".$row[';f10flyHalf';]."</td> <td>".$row[';f11leftWing';]."</td> <td>".$row[';f12insideCenter';]."</td> <td>".$row[';f13outsideCenter';]."</td> <td>".$row[';f14rightWing';]."</td> <td>".$row[';f15fullBack';]."</td> "; } $output .= "</tr></table>"; echo $output; }
Re: The Portfolio list.php October 21, 2013 03:12PM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Re: The Portfolio list.php October 22, 2013 09:15AM |
Registered: 10 years ago Posts: 11 Rating: 0 |
Re: The Portfolio list.php November 02, 2013 06:43PM |
Registered: 10 years ago Posts: 57 Rating: 0 |
Re: The Portfolio list.php November 04, 2013 07:38AM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Re: The Portfolio list.php November 04, 2013 06:42PM |
Registered: 10 years ago Posts: 57 Rating: 0 |
Re: The Portfolio list.php November 04, 2013 08:41PM |
Registered: 11 years ago Posts: 123 Rating: 0 |
Re: The Portfolio list.php November 04, 2013 10:11PM |
Registered: 10 years ago Posts: 57 Rating: 0 |
Re: The Portfolio list.php November 05, 2013 07:56AM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Language: PHP//e.g. where fmark is column 2 INSERT INTO table_name (column1, column3) //specify which columns VALUES (';$value1';, ';$value3';); //only insert those values INSERT INTO table_name //columns not specified VALUES (value1, value2, value3) //VALUES (';$value1';, '; ';, ';$value3';); //insert all values, fmark being empty
Re: The Portfolio list.php November 05, 2013 08:24AM |
Registered: 11 years ago Posts: 123 Rating: 0 |
Re: The Portfolio list.php November 05, 2013 08:42AM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |