CSS and SQL populated lists

Question

I'm planning on doing this, but I can't get my head around to if this is completely possible or not.

I'm trying to follow this design:

The list on the left is populated by SQL. When clicking on one of these links on the left, the page will change (i.e. something like designers.php?designerID=whatever).

All this I can do easily, but I'm looking more at the CSS coding. You see when I click on a link, it covers in a purple box to show you've selected it (You can see in the image that Helen Mary is selected). I can do this in an non SQL list, but how would I do this WITH an SQL populated list?

What does SQL have to do with things? The source of the data is irrelevant. — El Yobo
– El Yobo, Commented Aug 9, 2010 at 12:17

bobince · Accepted Answer · 2010-08-09 12:28:31Z

2

When you display your list you know your parameters and the current parameter too. All you need is to mark the current li with a custom class like current then set it's background color in CSS.

<?php

foreach($nav as $key => $label)
{
    $class = $key == $_GET['designerID'] ? 'current' : 'normal';
    print '<li class="' . $class . '">' . $label . </li>';
}

edited Aug 9, 2010 at 12:28

bobince

538k111 gold badges675 silver badges846 bronze badges

answered Aug 9, 2010 at 11:58

fabrik

14.4k8 gold badges58 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

CSS and SQL populated lists

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related