NickyDee Posted September 6, 2008 Share Posted September 6, 2008 I run a website thats about medical school admissions. To help my users I'm making a database of statistics about the different medical schools like how many people they take, what grades they expect and so on. I've made a database with some test entries in it and I've sucessfully made a php page to display it. But theres lots more I'd like to do and I cant figure out where to start. Heres what I have so far: http://www.study-medicine.co.uk/viewdatabase2.php Want I want to do next is to allow users to sort the table by different things, at the moment it just sorts by name (the primary key field), it would be cool if it could be sorted by other things like how many people applied or how many places there are. I cant find or figure out how to go about doing this, can anyone offer me some advice? The secound thing is I want to have some drop down form boxes on the top of the page to exclude certain entries, for example all the courses that will not take students who have had to resit exams (So if resit=no the entry is ommited, or from the other end of the same argument only those =yes are included, whatevers easier). Again I'm not sure where to start on that. I'm really grateful for anyones help, its much appreciated. Nicky Link to comment https://forums.phpfreaks.com/topic/123052-querying-a-statistics-database/ Share on other sites More sharing options...
Infinitive Posted September 6, 2008 Share Posted September 6, 2008 I'm going to give you the pieces you need and a pretty straightforward way to do it. Then you just need to assemble them. 1) How to sort or filter a list. The basis of your page is a query against the database that goes something like this (all in PHP) $query = "SELECT Applied, Interview, Offers, Places FROM Schools_Table"; Or you may have just used "SELECT *" which is ok for a simple application like this listing but poor form for a multi-page tool. to filter it, you use the WHERE statement which goes right after FROM. Example: WHERE RESIT = 'yes' to sort it, you use the ORDER BY statement which goes right after WHERE. Example: ORDER BY Applied DESC and DESC means descending order (biggest first). You can also use ASC for ascending. WHERE can be made into compound statements using AND. ORDER BY can be given second and third tier sorts using commas. Just so you see how it goes, here is a more complex statement: $query = "SELECT Applied, Interview, Offers, Places FROM Schools_Table WHERE RESIT = 'No' AND Clearing = 'No" and Female >= (Male * .9) ORDER BY Applied DESC, Places DESC, Name ASC"; And that would get those 4 columns of data only for schools where you can't resit, where clearing is no, and where the males don't outnumber the females by more than 10%. Then it would sort first by the largest number of applicants, then by the largest number of places (for ties), then A-Z (for further ties). 2) Letting the user submit their preference. This is going to come in 2 parts. The first part is the user submitting information, and it will be done with HTML, not PHP. <form name="AppSortForm" method="GET" action="viewdatabase2.php"> <input type="submit" name="SortButton" value="Applicants"> </form> That is a longer format than you need, but I wanted to start with something that is the most broken out. This will make a common button just like the search button you see at the top of this page, or the Post & Preview buttons you see when replying. When the user clicks it it will submit your form. That form will load the page again (in this case viewdatabase2.php) only this time the user's browser will be passing information about what they did. There are two methods for passing information. GET will put the information in the URL. You see this all the time - in fact if you look up to the URL right now, everything aftter index.php is passed that way. It's good in that it can get saved in the bookmark, linked easily, etc. But it's not so good for sensitive information, because it's all out in the open. The other method would be POST. The information still comes in but the browser doesn't show it anywhere. It's perfectly good too. But as I said, you might have people who want to save a bookmark for a certain sort for example, so GET works well enough. What that form will do is have them reload the page, this time with the URL being http://www.study-medicine.co.uk/viewdatabase2.php?SortButton=Applicants Now as I said, that form I showed you will work, but it's a little more typing than you need. (Since you would need a separate form for each sort.) It's also a little clumsy in application. But you can see all the parts of it. Here is another way that would do the same thing. <a href="viewdatabase2.php?SortOrder=1">Click me to sort by Applicants</a> Clearly that is shorter. We're kind of shortcutting to the URL by pretending we submitted a form but not really. There are other ways you could do it, using javascript, etc. But I recommend doing a search and reading up on submitting forms for a full explanation. 3) Figuring out their preference I'm going to assume we used method 2 here. So the URL will look like this: http://www.study-medicine.co.uk/viewdatabase2.php?SortOrder=1 This next step uses PHP again, and it happens before the database query. The relevant code looks like this: if (isset($_GET['SortOrder'])) { $SortOrder = intval($_GET['SortOrder']); } else { $SortOrder = 0; } That's a lot of pieces in a small space, so let me break it down. $_GET['SortOrder'] is the variable that contains whatever SortOrder equals in the URL. In this case it would be 1. (Presumably you would have other links be 2, 3, etc for different sorts.) I put intval() around it as force of habit, because I know we want an integer. Shouldn't be too important here but it can catch people messing around with your URL sometimes. (Note that this wouldn't work for the previous version, because there we were looking for the word "Applicants".) And because when they first arrive it won't have a value, I had to put in an if...else catch. So if a GET value called SortOrder exists in the URL, this will store it as the variable $SortOrder. Otherwise, it will just make $SortOrder = 0 (meaning no sort, or alphabet sort, whatever you like). 4) Using what they want to change the query You already know the tools. Now (in php) you just use an if ... else statement to change your query. Here is one way to do it: $query = "SELECT Applied, Interview, Offers, Places FROM Schools_Table"; if ($SortOrder == 1) { // Order by Applicants $query .= " ORDER BY Applicants DESC"; } elseif ($SortOrder == 2) { // Order by Places $query .= " ORDER BY Places DESC"; } else { // Default, alphabetical $query .= " ORDER BY Name ASC"; } Just to point out the pieces: PHP uses == for testing if something is equal. It uses = to assign something equal. Don't mix them up! (Everybody does, at times.) The operator .= is append. It means "take $query and stick this on the end"; That's why I put a space in the string before it starts too, take that into consideration. between "if" and "else" you can use "elseif" for other conditions. This way we put an option for a second search. And that's all the basics. Now to filter you're going to have to use a form to pass several variables at once - assuming users may want to mix and match their preferences. So like I said, read up a little bit on forms - there are great pages all over the internet about it. But basically you have all the pieces you need. Hope that helps. Link to comment https://forums.phpfreaks.com/topic/123052-querying-a-statistics-database/#findComment-635489 Share on other sites More sharing options...
NickyDee Posted September 6, 2008 Author Share Posted September 6, 2008 You.... are my god. I'll get on this and post back how it goes. Thanks sooo much. Link to comment https://forums.phpfreaks.com/topic/123052-querying-a-statistics-database/#findComment-635491 Share on other sites More sharing options...
NickyDee Posted September 7, 2008 Author Share Posted September 7, 2008 So far I've gotten the ascending and descending parts working, now I'm moving on to the more complex queries like if resit=no ommit. Thanks for your help, its absoutely amazing. I'd never have figured it out on my own. This has given me just enough to go away and find out the missing gaps. You can see my progress at the original link. Link to comment https://forums.phpfreaks.com/topic/123052-querying-a-statistics-database/#findComment-635531 Share on other sites More sharing options...
NickyDee Posted September 7, 2008 Author Share Posted September 7, 2008 Right, I've sort of got it working in principle but I've run into a final problem. When a user clicks on a checkbox it returns a single letter value (there are 5 checkboxes named ch1-5 and each return one letter, a-e, repsetively). So if ch1=a I know its checked. This then checks the box (so the user knows its selected) and when the query runs it knows if ch1=checked then it should only find results where resits=yes. This part works. The problem occurs when a user selects two boxes, say resits and clearing. It should only return results where BOTH clearing and resits = yes but instead it returns results where EITHER clearing or resits=yes. ch1=resits ch2=clearing ch3=biology ch4=chemistry ch5=UKCAT Heres the code I'm using for the PHP side of things: if (isset($_GET['SortOrder'])) { $SortOrder = intval($_GET['SortOrder']); } else { $SortOrder = 0; } $ch1 = 'unchecked'; $ch2 = 'unchecked'; $ch3 = 'unchecked'; $ch4 = 'unchecked'; $ch5 = 'unchecked'; if (isset($_GET['Submit1'])) { if (isset($_GET['ch1'])) { $ch1 = $_GET['ch1']; if ($ch1 == 'a') { $ch1 = 'checked'; } } if (isset($_GET['ch2'])) { $ch2 = $_GET['ch2']; if ($ch2 == 'b') { $ch2 = 'checked'; } } if (isset($_GET['ch3'])) { $ch3 = $_GET['ch3']; if ($ch3 == 'c') { $ch3 = 'checked'; } } if (isset($_GET['ch4'])) { $ch4 = $_GET['ch4']; if ($ch4 == 'd') { $ch4 = 'checked'; } } if (isset($_GET['ch5'])) { $ch5 = $_GET['ch5']; if ($ch5 == 'e') { $ch5 = 'checked'; } } } //select the table $query="SELECT Name, Applied, Interviewed, Offered, Accepted, Male, Female, Biology, Chemistry, UKCAT, Tests, Resits, Clearing FROM medical_school"; if ($SortOrder == 1) { // Order by Applied $query .= " ORDER BY Applied DESC"; } elseif ($SortOrder == 2) { // Order by Interviewed $query .= " ORDER BY Interviewed DESC"; } elseif ($SortOrder == 3) { // Order by Offered $query .= " ORDER BY Offered DESC"; } elseif ($SortOrder == 4) { // Order by Accepted $query .= " ORDER BY Accepted DESC"; } elseif ($SortOrder == 5) { // Order by Interviewed $query .= " ORDER BY Applied ASC"; } elseif ($SortOrder == 6) { // Order by Interviewed $query .= " ORDER BY Interviewed ASC"; } elseif ($SortOrder == 7) { // Order by Interviewed $query .= " ORDER BY Offered ASC"; } elseif ($SortOrder == { // Order by Interviewed $query .= " ORDER BY Accepted ASC"; } elseif ($SortOrder == 9) { // Order by Interviewed $query .= " ORDER BY Name ASC"; } else { // Default, alphabetical $query .= " ORDER BY Name DESC"; } $query="SELECT Name, Applied, Interviewed, Offered, Accepted, Male, Female, Biology, Chemistry, UKCAT, Tests, Resits, Clearing FROM medical_school"; if ($ch1 == checked) { // Order by resits only $query .= " WHERE Resits = 'Yes'"; } elseif ($ch2 == checked) { // Order by clearing only $query .= " WHERE Clearing = 'Yes'"; } elseif ($ch3 == checked) { // Order by biology only $query .= " WHERE Biology = '-'"; } elseif ($ch4 == checked) { // Order by chemistry only $query .= " WHERE Chemistry = '-'"; } elseif ($ch5 == checked) { // Order by ukcat only $query .= " WHERE UKCAT = 'No'"; } else { // Default, alphabetical $query .= " ORDER BY Name DESC"; } $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); ?> <table width="930" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td height="20" align="left" valign="top"><p><strong><font size="3" face="Arial, Helvetica, sans-serif">Advanced Search Options:</font></strong></p> </td> </tr> </table> <form name="form1" method="GET" action="viewdatabase2.php"> <table width="930" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td width="310" align="left" valign="top"> <input type = "Checkbox" Name ="ch1" value ="a" <?PHP print $ch1; ?>>Resits <br /> <input type = "Checkbox" Name ="ch2" value ="b" <?PHP print $ch2; ?>>Clearing </td> <td width="310" align="left" valign="top"> <input type = "Checkbox" Name ="ch3" value ="c" <?PHP print $ch3; ?>>Biology <br /> <input type = "Checkbox" Name ="ch4" value ="d" <?PHP print $ch4; ?>>Chemistry </td> <td width="310" align="left" valign="top"> <input type = "Checkbox" Name ="ch5" value ="e" <?PHP print $ch5; ?>>UKCAT <br /> <br /> <input type = "Submit" name = "Submit1" value = "Submit"> </td> </tr> </table> </form> <br /> <table border="0" cellspacing="1" cellpadding="4" align="center" bgcolor="#475763"> <tr> <td width="150" rowspan="2" align="center" valign="middle" bgcolor="698193"><font face="Arial, Helvetica, sans-serif" size="2" color="white"><strong>Name </strong></font> <a href="/viewdatabase2.php"><img src="/images2/desc.gif" width="7" height="7" border="0" /></a><a href="/viewdatabase2.php?SortOrder=9"><img src="/images2/ASC.gif" width="7" height="7" border="0" /></a></td> <td colspan="4" align="center" bgcolor="698193"><font face="Arial, Helvetica, sans-serif" size="2" color="white"><strong>Admissions</strong></font></td> <td colspan="2" align="center" bgcolor="698193"><font face="Arial, Helvetica, sans-serif" size="2" color="white"><strong>Genders</strong></font></td> <td colspan="3" align="center" bgcolor="698193"><font face="Arial, Helvetica, sans-serif" size="2" color="white"><strong>A-Level Subjects</strong></font></td> <td colspan="2" align="center" bgcolor="698193"><font face="Arial, Helvetica, sans-serif" size="2" color="white"><strong>Tests</strong></font></td> <td colspan="2" align="center" bgcolor="698193"><font color="white" size="2" face="Arial, Helvetica, sans-serif"><strong>Entry Types</strong></font></td> </tr> <tr> <td width="65" align="center" bgcolor="7e94a4"><font face="Arial, Helvetica, sans-serif" size="2" color="white">Applied </font><a href="/viewdatabase2.php?SortOrder=1"><img src="/images2/desc.gif" width="7" height="7" border="0" /></a><a href="/viewdatabase2.php?SortOrder=5"><img src="/images2/ASC.gif" width="7" height="7" border="0" /></a></td> <td width="65" align="center" bgcolor="7e94a4"><font face="Arial, Helvetica, sans-serif" size="2" color="white">Invited </font><a href="/viewdatabase2.php?SortOrder=2"><img src="/images2/desc.gif" width="7" height="7" border="0" /></a><a href="/viewdatabase2.php?SortOrder=6"><img src="/images2/ASC.gif" width="7" height="7" border="0" /></a></td> <td width="65" align="center" bgcolor="7e94a4"><font face="Arial, Helvetica, sans-serif" size="2" color="white">Offers </font><a href="/viewdatabase2.php?SortOrder=3"><img src="/images2/desc.gif" width="7" height="7" border="0" /></a><a href="/viewdatabase2.php?SortOrder=7"><img src="/images2/ASC.gif" width="7" height="7" border="0" /></a></td> <td width="65" align="center" bgcolor="7e94a4"><font face="Arial, Helvetica, sans-serif" size="2" color="white">Places </font><a href="/viewdatabase2.php?SortOrder=4"><img src="/images2/desc.gif" width="7" height="7" border="0" /></a><a href="/viewdatabase2.php?SortOrder=8"><img src="/images2/ASC.gif" width="7" height="7" border="0" /></a></td> <td width="35" align="center" bgcolor="7e94a4"><font face="Arial, Helvetica, sans-serif" size="2" color="white">Male</font></td> <td width="35" align="center" bgcolor="7e94a4"><font face="Arial, Helvetica, sans-serif" size="2" color="white">Female</font></td> <td width="35" align="center" bgcolor="7e94a4"><font face="Arial, Helvetica, sans-serif" size="2" color="white">Bio</font></td> <td width="35" align="center" bgcolor="7e94a4"><font face="Arial, Helvetica, sans-serif" size="2" color="white">Chem</font></td> <td width="35" align="center" bgcolor="7e94a4"><font face="Arial, Helvetica, sans-serif" size="2" color="white">Other</font></td> <td width="50" align="center" bgcolor="7e94a4"><font face="Arial, Helvetica, sans-serif" size="2" color="white">UKCAT</font></td> <td width="50" align="center" bgcolor="7e94a4"><font face="Arial, Helvetica, sans-serif" size="2" color="white">Tests</font></td> <td width="40" align="center" bgcolor="7e94a4"><font face="Arial, Helvetica, sans-serif" size="2" color="white">Resits</font></td> <td width="40" align="center" bgcolor="7e94a4"><font face="Arial, Helvetica, sans-serif" size="2" color="white">Clearing</font></td> </tr> <? $i=0; while ($i < $num) { $Name=mysql_result($result,$i,"Name"); $Applied=mysql_result($result,$i,"Applied"); $Interviewed=mysql_result($result,$i,"Interviewed"); $Offered=mysql_result($result,$i,"Offered"); $Accepted=mysql_result($result,$i,"Accepted"); $Male=mysql_result($result,$i,"Male"); $Female=mysql_result($result,$i,"Female"); $Biology=mysql_result($result,$i,"Biology"); $Chemistry=mysql_result($result,$i,"Chemistry"); $Other=mysql_result($result,$i,"Other"); $UKCAT=mysql_result($result,$i,"UKCAT"); $Test=mysql_result($result,$i,"Tests"); $Resits=mysql_result($result,$i,"Resits"); $Clearing=mysql_result($result,$i,"Clearing"); ?> <tr> <td bgcolor="#FFFFFF" align="left"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $Name; ?></font></td> <td bgcolor="#FFFFFF" align="center"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $Applied; ?></font></td> <td bgcolor="#FFFFFF" align="center"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $Interviewed; ?></font></td> <td bgcolor="#FFFFFF" align="center"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $Offered; ?></font></td> <td bgcolor="#FFFFFF" align="center"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $Accepted; ?></font></td> <td bgcolor="#FFFFFF" align="center"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $Male; ?></font></td> <td bgcolor="#FFFFFF" align="center"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $Female; ?></font></td> <td bgcolor="#FFFFFF" align="center"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $Biology; ?></font></td> <td bgcolor="#FFFFFF" align="center"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $Chemistry; ?></font></td> <td bgcolor="#FFFFFF" align="center"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $Other; ?></font></td> <td bgcolor="#FFFFFF" align="center"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $UKCAT; ?></font></td> <td bgcolor="#FFFFFF" align="center"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $Test; ?></font></td> <td bgcolor="#FFFFFF" align="center"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $Resits; ?></font></td> <td bgcolor="#FFFFFF" align="center"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $Clearing; ?></font></td> </tr> <? $i++; } echo "</table>"; ?> as always I much appreciate anyones help on this, i can't believe its actually gotten off the ground as far as it has. I could never have managed it alone. Nicky Link to comment https://forums.phpfreaks.com/topic/123052-querying-a-statistics-database/#findComment-636087 Share on other sites More sharing options...
NickyDee Posted September 7, 2008 Author Share Posted September 7, 2008 Sorry actually my code is: if (isset($_GET['SortOrder'])) { $SortOrder = intval($_GET['SortOrder']); } else { $SortOrder = 0; } $ch1 = 'unchecked'; $ch2 = 'unchecked'; $ch3 = 'unchecked'; $ch4 = 'unchecked'; $ch5 = 'unchecked'; if (isset($_GET['Submit1'])) { if (isset($_GET['ch1'])) { $ch1 = $_GET['ch1']; if ($ch1 == 'a') { $ch1 = 'checked'; } } if (isset($_GET['ch2'])) { $ch2 = $_GET['ch2']; if ($ch2 == 'b') { $ch2 = 'checked'; } } if (isset($_GET['ch3'])) { $ch3 = $_GET['ch3']; if ($ch3 == 'c') { $ch3 = 'checked'; } } if (isset($_GET['ch4'])) { $ch4 = $_GET['ch4']; if ($ch4 == 'd') { $ch4 = 'checked'; } } if (isset($_GET['ch5'])) { $ch5 = $_GET['ch5']; if ($ch5 == 'e') { $ch5 = 'checked'; } } } //select the table $query="SELECT Name, Applied, Interviewed, Offered, Accepted, Male, Female, Biology, Chemistry, UKCAT, Tests, Resits, Clearing FROM medical_school"; if ($SortOrder == 1) { // Order by Applied $query .= " ORDER BY Applied DESC"; } elseif ($SortOrder == 2) { // Order by Interviewed $query .= " ORDER BY Interviewed DESC"; } elseif ($SortOrder == 3) { // Order by Offered $query .= " ORDER BY Offered DESC"; } elseif ($SortOrder == 4) { // Order by Accepted $query .= " ORDER BY Accepted DESC"; } elseif ($SortOrder == 5) { // Order by Interviewed $query .= " ORDER BY Applied ASC"; } elseif ($SortOrder == 6) { // Order by Interviewed $query .= " ORDER BY Interviewed ASC"; } elseif ($SortOrder == 7) { // Order by Interviewed $query .= " ORDER BY Offered ASC"; } elseif ($SortOrder == { // Order by Interviewed $query .= " ORDER BY Accepted ASC"; } elseif ($SortOrder == 9) { // Order by Interviewed $query .= " ORDER BY Name ASC"; } elseif ($ch1 == checked) { // Order by resits only $query .= " WHERE Resits = 'Yes'"; } elseif ($ch2 == checked) { // Order by clearing only $query .= " WHERE Clearing = 'Yes'"; } elseif ($ch3 == checked) { // Order by biology only $query .= " WHERE Biology = '-'"; } elseif ($ch4 == checked) { // Order by chemistry only $query .= " WHERE Chemistry = '-'"; } elseif ($ch5 == checked) { // Order by ukcat only $query .= " WHERE UKCAT = 'No'"; } else { // Default, alphabetical $query .= " ORDER BY Name DESC"; } $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); ?> <table width="930" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td height="20" align="left" valign="top"><p><strong><font size="3" face="Arial, Helvetica, sans-serif">Advanced Search Options:</font></strong></p> </td> </tr> </table> <form name="form1" method="GET" action="viewdatabase2.php"> <table width="750" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td width="250" align="left" valign="top"> <input type = "Checkbox" Name ="ch1" value ="a" <?PHP print $ch1; ?>> <font size="2" face="Arial, Helvetica, sans-serif">Resits</font> <br /> <input type = "Checkbox" Name ="ch2" value ="b" <?PHP print $ch2; ?>> <font size="2" face="Arial, Helvetica, sans-serif">Clearing</font> </td> <td width="250" align="left" valign="top"> <input type = "Checkbox" Name ="ch3" value ="c" <?PHP print $ch3; ?>> <font size="2" face="Arial, Helvetica, sans-serif">Biology</font> <br /> <input type = "Checkbox" Name ="ch4" value ="d" <?PHP print $ch4; ?>> <font size="2" face="Arial, Helvetica, sans-serif">Chemistry</font> </td> <td width="250" align="left" valign="top"> <input type = "Checkbox" Name ="ch5" value ="e" <?PHP print $ch5; ?>> <font size="2" face="Arial, Helvetica, sans-serif">UKCAT</font> <br /> <br /> <input type = "Submit" name = "Submit1" value = "Submit"> </td> </tr> </table> </form> <br /> <table border="0" cellspacing="1" cellpadding="4" align="center" bgcolor="#475763"> <tr> <td width="150" rowspan="2" align="center" valign="middle" bgcolor="698193"><font face="Arial, Helvetica, sans-serif" size="2" color="white"><strong>Name </strong></font> <a href="/viewdatabase2.php"><img src="/images2/desc.gif" width="7" height="7" border="0" /></a><a href="/viewdatabase2.php?SortOrder=9"><img src="/images2/ASC.gif" width="7" height="7" border="0" /></a></td> <td colspan="4" align="center" bgcolor="698193"><font face="Arial, Helvetica, sans-serif" size="2" color="white"><strong>Admissions</strong></font></td> <td colspan="2" align="center" bgcolor="698193"><font face="Arial, Helvetica, sans-serif" size="2" color="white"><strong>Genders</strong></font></td> <td colspan="3" align="center" bgcolor="698193"><font face="Arial, Helvetica, sans-serif" size="2" color="white"><strong>A-Level Subjects</strong></font></td> <td colspan="2" align="center" bgcolor="698193"><font face="Arial, Helvetica, sans-serif" size="2" color="white"><strong>Tests</strong></font></td> <td colspan="2" align="center" bgcolor="698193"><font color="white" size="2" face="Arial, Helvetica, sans-serif"><strong>Entry Types</strong></font></td> </tr> <tr> <td width="65" align="center" bgcolor="7e94a4"><font face="Arial, Helvetica, sans-serif" size="2" color="white">Applied </font><a href="/viewdatabase2.php?SortOrder=1"><img src="/images2/desc.gif" width="7" height="7" border="0" /></a><a href="/viewdatabase2.php?SortOrder=5"><img src="/images2/ASC.gif" width="7" height="7" border="0" /></a></td> <td width="65" align="center" bgcolor="7e94a4"><font face="Arial, Helvetica, sans-serif" size="2" color="white">Invited </font><a href="/viewdatabase2.php?SortOrder=2"><img src="/images2/desc.gif" width="7" height="7" border="0" /></a><a href="/viewdatabase2.php?SortOrder=6"><img src="/images2/ASC.gif" width="7" height="7" border="0" /></a></td> <td width="65" align="center" bgcolor="7e94a4"><font face="Arial, Helvetica, sans-serif" size="2" color="white">Offers </font><a href="/viewdatabase2.php?SortOrder=3"><img src="/images2/desc.gif" width="7" height="7" border="0" /></a><a href="/viewdatabase2.php?SortOrder=7"><img src="/images2/ASC.gif" width="7" height="7" border="0" /></a></td> <td width="65" align="center" bgcolor="7e94a4"><font face="Arial, Helvetica, sans-serif" size="2" color="white">Places </font><a href="/viewdatabase2.php?SortOrder=4"><img src="/images2/desc.gif" width="7" height="7" border="0" /></a><a href="/viewdatabase2.php?SortOrder=8"><img src="/images2/ASC.gif" width="7" height="7" border="0" /></a></td> <td width="35" align="center" bgcolor="7e94a4"><font face="Arial, Helvetica, sans-serif" size="2" color="white">Male</font></td> <td width="35" align="center" bgcolor="7e94a4"><font face="Arial, Helvetica, sans-serif" size="2" color="white">Female</font></td> <td width="35" align="center" bgcolor="7e94a4"><font face="Arial, Helvetica, sans-serif" size="2" color="white">Bio</font></td> <td width="35" align="center" bgcolor="7e94a4"><font face="Arial, Helvetica, sans-serif" size="2" color="white">Chem</font></td> <td width="35" align="center" bgcolor="7e94a4"><font face="Arial, Helvetica, sans-serif" size="2" color="white">Other</font></td> <td width="50" align="center" bgcolor="7e94a4"><font face="Arial, Helvetica, sans-serif" size="2" color="white">UKCAT</font></td> <td width="50" align="center" bgcolor="7e94a4"><font face="Arial, Helvetica, sans-serif" size="2" color="white">Tests</font></td> <td width="40" align="center" bgcolor="7e94a4"><font face="Arial, Helvetica, sans-serif" size="2" color="white">Resits</font></td> <td width="40" align="center" bgcolor="7e94a4"><font face="Arial, Helvetica, sans-serif" size="2" color="white">Clearing</font></td> </tr> <? $i=0; while ($i < $num) { $Name=mysql_result($result,$i,"Name"); $Applied=mysql_result($result,$i,"Applied"); $Interviewed=mysql_result($result,$i,"Interviewed"); $Offered=mysql_result($result,$i,"Offered"); $Accepted=mysql_result($result,$i,"Accepted"); $Male=mysql_result($result,$i,"Male"); $Female=mysql_result($result,$i,"Female"); $Biology=mysql_result($result,$i,"Biology"); $Chemistry=mysql_result($result,$i,"Chemistry"); $Other=mysql_result($result,$i,"Other"); $UKCAT=mysql_result($result,$i,"UKCAT"); $Test=mysql_result($result,$i,"Tests"); $Resits=mysql_result($result,$i,"Resits"); $Clearing=mysql_result($result,$i,"Clearing"); ?> <tr> <td bgcolor="#FFFFFF" align="left"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $Name; ?></font></td> <td bgcolor="#FFFFFF" align="center"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $Applied; ?></font></td> <td bgcolor="#FFFFFF" align="center"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $Interviewed; ?></font></td> <td bgcolor="#FFFFFF" align="center"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $Offered; ?></font></td> <td bgcolor="#FFFFFF" align="center"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $Accepted; ?></font></td> <td bgcolor="#FFFFFF" align="center"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $Male; ?></font></td> <td bgcolor="#FFFFFF" align="center"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $Female; ?></font></td> <td bgcolor="#FFFFFF" align="center"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $Biology; ?></font></td> <td bgcolor="#FFFFFF" align="center"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $Chemistry; ?></font></td> <td bgcolor="#FFFFFF" align="center"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $Other; ?></font></td> <td bgcolor="#FFFFFF" align="center"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $UKCAT; ?></font></td> <td bgcolor="#FFFFFF" align="center"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $Test; ?></font></td> <td bgcolor="#FFFFFF" align="center"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $Resits; ?></font></td> <td bgcolor="#FFFFFF" align="center"><font face="Arial, Helvetica, sans-serif" size="2"><? echo $Clearing; ?></font></td> </tr> <? $i++; } echo "</table>"; ?> Link to comment https://forums.phpfreaks.com/topic/123052-querying-a-statistics-database/#findComment-636096 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.