Jump to content


  • Posts

  • Joined

  • Last visited

Everything posted by sue

  1. Hi, I have a query that goes like this SELECT s.studentid, firstname,lastname,dp,startyear,sum(credits) FROM students s, results r, courses c WHERE s.studentid=r.studentid AND r.courseid=c.courseid GROUP BY s.studentid HAVING (dp, startyear) = (SELECT dp, startyear FROM students WHERE studentid=18); I need to filter it so that it only returns those that have credits less than student 18. I am stuck now as to how to do that. Any ideas? Also this one above misses out one record as they have no credits. How could I get it still to display the name etc but the sum to read as 0? Thanks in advance
  2. Hi, I am using w3css top navigation bar using a drop down menu. I would like to have a multilevel drop down menu for some of the items. I would like that each season opens up to another submenu where I can display eg, the years pictures or blogs etc. At the moment the code for the html and css is eg, HTML <div class="dropdown"> <button class="dropbtn"><strong>History</strong></button> <div class="dropdown-content"> <a href="#">Season2016</a> <a href="#">Season 2017</a> </div> </div> CSS .dropdown { font-family: "Comic Sans MS", cursive, sans-serif; float: left; overflow: hidden; } .dropdown .dropbtn { font-family: "Comic Sans MS", cursive, sans-serif; font-size: 16px; border: none; outline: none; color: black; padding: 14px 16px; background-color: inherit; } .dropdown-content { display: none; position: absolute; background-color: #f9f9f9; min-width: 160px; box-shadow: 0px 8px 16px 0px rgba(0,0,0,0.2); z-index: 1; } .dropdown-content a { float: none; color: black; padding: 12px 16px; text-decoration: none; display: block; text-align: left; } .dropdown-content a:hover { background-color: #ddd; } .dropdown:hover .dropdown-content { display: block; }
  3. sue

    W3.css Tabs

    Hi, I am using the w3.css tabs and have a customised cursor. However the cursor will not work over the tabs. What do I need to set to get it to work over the tabs also?
  • Create New...