JustLikeIcarus

I'm making myself mad now. Bad day select t1.authors, count(1) as total FROM ( select author as authors FROM library WHERE author <> 'Unknown' UNION ALL select coauthor as authors FROM library WHERE coauthor <> 'Unknown' ) t1 GROUP BY t1.authors

Multiple numbered columns like you mention violates NF1's rules Here i took the original list of columns you gave and seperated them into groups. deptcode, type, dayno, start, finish, weeks module, title group lecturer room Each of those groups should primarily make up a table. I beleive that meets all of the NF3 requirements. Ill have to check.

Well I dont know exactly what your data is but... You need to identify the minimal columns needed to identify a unique record then remove any thing that is related to columns that make up the primary key but is not part of the key itself. Unless you will be using an auto increment id field then the normalization starts occurring a bit differently.

Ok sounds like your getting whats known as a Cartesian product in phpmyadmin change it to this. If it has an issue with count(1) change it to count(*) select t1.authors, count(1) as total FROM ( select authors FROM library WHERE author <> 'Unknown' UNION ALL select coauthor as authors FROM library WHERE coauthor <> 'Unknown' ) t1 GROUP BY t1.authors

Ok I have to ask. Why third normal form specifically? Why not Second, Fourth or even Fifth?

Man I just suck today. Ill cross my fingers this time select t1.author, count(t1.author) as total FROM ( select author FROM library WHERE author <> 'Unknown' UNION ALL select coauthor as author FROM library WHERE coauthor <> 'Unknown' ) t1 GROUP BY t1.author

Nice, did not know you could do that That is probably better then my way. Good work! Haha thanks. Yeah it should work fine, once a table is given an alias its essentially its own table and can be treated as such. Just one of the 100 or so ways this query can be done. Gotta love SQL.

Whoops try this select t1.author, count(t1.*) as total FROM ( select author FROM library WHERE author <> 'Unknown' UNION ALL select coauthor as author FROM library WHERE coauthor <> 'Unknown' ) t1 GROUP BY t1.author

Heres one way to do by bringing in the people table twice. SELECT movie_name, actors.people_fullname, directors.people_fullname FROM movie, people actors, people directors WHERE actors.people_id = movie_leadactor AND directors.people_id = movie_director

Heres one way it could be done. select author, count(*) as total FROM ( select author FROM library WHERE author <> 'Unknown' UNION ALL select coauthor as author FROM library WHERE coauthor <> 'Unknown' ) GROUP BY author

Another more simpler solution to this would be to open the music player in a new window with its chrome elements stripped away so it looks as close to a music player as possible. While not the optimal way to go it would fix your issue. With that said, do you think that this is absolutely necessary? Most sites that I visit for artists have a dedicated page for their media. Not all visitors will want to play the music so another thing you may want to consider is not having music which starts automatically as it tends to annoy visitors. You may in the end simply prefer having a designating page for discovering the artists music.

What is the full url for the location of your css?

Sounds like your going the correct route. Hope you get the job man.

CSS Frameworks are really nice since they take care of most of the common issues you run into, especially in regards to columns. If you dont mind me asking, why are you using an iframe for the contact popup? The same functionality can be achieved with a little ajax if your just trying to prevent the whole page from submitting.

If their are properties in the h1{} css statement that you dont want to take affect on a specific h1 tag you have to override them all in the .box h1{} css Or else they will "Cascade" down to it. So if you have a background color set for h1 but dont want it for .box h1 then you have to state that in the css.

In regards to your borders. IE handles borders differently than FF and basically everyone else for that matter. IE is legendary for their flawed box model. Im betting if you removed the border the problem would disappear. To learn more about this google ie box model.

Take a look here http://css.maxdesign.com.au/listamatic/horizontal03.htm You notice that they dont float the list items themselves they use display:inline. When you float an element even if its already inline sets it to a block level element. Their CSS may fix your issues.

I think the mail thing you need to fix the issues your having is to set the columns parent container bg color to the left sidebar's, remove the left sides left margin and the right side;s right margin and change the width of their container to what you want. However to get the best possible version of this, in my opinion would be to go here http://960.gs/ grab the css and use its classes to format the layout.

Good deal. Happy I was able to help.

The bottom padding on the a elements are what is causing it.

Indeed that is what min-height is for however ie doesnt use it. In ie min-height is specified with height since ie will make the element taller as more content is added. (Which is wrong) So you have to use some ie hacks. Like One of many different hacks is selector { min-height:500px; height:auto !important; height:500px; }

If the joins arent doing it for you try swapping the order of equality condition. Could change the result set since it would now select categories based of the forums. SELECT c.*, f.* FROM forum f, cat c WHERE c.id = f.catid ORDER BY c.name, f.forumname"

In the interest of having more than one ways to skin a cat ..... (see whay i did there?) This would work as well. SELECT c.name, f.forumname FROM forum f, cat c WHERE f.catid = c.id ORDER BY c.name, f.forumname I dont know why but I hardly ever use the "JOIN" keywords. I think they tend to confuse me, lol.

Indeed it works as well. I knew the parens werent required around the "if" section but they make it look pretty lol. Cool my quote for new things learned each day has been met.

Well your left column's min-height is set shorter that the actual height of the right column. Also something to note is ie6 doesnt use min-height