Jump to content

sue

Members
  • Posts

    3
  • Joined

  • Last visited

Posts 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. 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...