Naive Amoeba

So is bgcolor, align, valign, width, height, border, cellpadding, cellspacing etc :)Everything can be done with CSS. I mean, everything.

The whole point of the head tags is that it's information that is processed but not directly shown on the page body itself. Why do you even want to?

Jlhaslip is right: tables are horrible and should only be used when showing.. well, a table.Plus, you seem to have missed off several semicolons in your css code, and "valign" is invalid XHTMl, and the class "width40" is a very non-semantic name :)Just remember, design for firefox, botch for IE.

You can use php, asp, asp.net, flash, perl, anything. Just go on hotscripts.comThey usually have some nice pre-made scripts, and if you understand the language they're written in, it's quite easy to strip it all and edit it to your liking.And as for ryusuke, with PHP, ASPjpeg/ASPimage and asp.net, you can get your script to automatically generate thumbnails. Asp.net is best for that, actually.Plus, why's the photo a gif?

Tables and spacer gifs? Hmmm... how about, you don't?I've noticed some problems. First, it's not valid XHTML. In your image tags, you've put align, width and height, along with emitting the title property.Plus, on the wall tank one, you've written hieght not height.I didn't see the page before you added that extra BR, but i've noticed that you've labeled both your div and anchor tags with the class "tab". Two elements inside each other don't need the same tag. Plus, you've set "tab" to being display:inline. That may explain why it's messing up.You've used width="" and height="" a lot in that page, when really you should use css to do all the sizing. Including with the images.Hope this helps!

I'm currently trying to validate this page:http://www.sweeneyauction.net/index.htmUnfortunatly I have some javascript on all of those lines i'm getting errors in. How do I validate javascript that's in my XHTML?

For me it says "No Referer header found!"Because that would suggest that your website is not configered properly. The XHTML validator doesn't really check your javascript as such..

If you learn CSS, you can utilize it in your current HTML pages and also XHTML as you learn it at some future point in time. XHTML isn't difficult once you have an understanding of HTML.

Yeah, true. XHTML is hardly a new language, it's just remembering to put alt="" title="" etc

Hi, I dont see if you are using the [DATE] in the SELECT statement anywhere in the code, so if you can write the SELECT without [DATE] field it could be much easier.One more thing should the WHERE come ahead of the GROUP BY (i am not pretty sure abt that in MS Access, but i guess that how it works in sql server) Try this....SELECT artist, count(artist) AS artist_countFROM song WHERE [date] > " & DateAdd("ww", -1, Date) & " GROUP BY artistORDER BY artist_count DESCHTH

<{POST_SNAPBACK}>

Ah well, thanks anyway (to aspnetguy). Oh, and how could you use a where statement when you haven't selected it.. ?ThanksMatt

hmmm...is this an access db? If so could you post a link to it so I can download it and test some queries...it would be much easier than me trying to recreate your db from scratch.Thanks,

<{POST_SNAPBACK}>

Hi,I've PMed it to you as I don't particularly want to post my database URI to the public :)Many thanks,Matt

try the query like this

SELECT artist, count(artist) AS artist_count, [date] FROM song GROUP BY artist,[date] WHERE [date] > " & DateAdd("ww", -1, Date) & " ORDER BY count(artist) DESC

When you are getting 'aggregate' errors it is usually because you need to place the problem field in the group by.Most likely you are getting multiple values (duplicate?) that need to be grouped.Let us know if that works.

<{POST_SNAPBACK}>

Hey, thanks for the help but no- It doesn't correctly group them now..Compare: http://www.naiveamoeba.co.uk/song/stats.asp to http://www.naiveamoeba.co.uk/song/stats.asp?timespan=dayThe second is with the new SQL stringCheers, Matt

Hi,I have this SQL (it's going with ASP and an access database):sql = "SELECT artist, count(artist) AS artist_count, [date] FROM song GROUP BY artist WHERE [date] > " & DateAdd("ww", -1, Date) & " ORDER BY count(artist) DESC"And my DB schema is song(id,artist,song,date,time).I want it to group all rows with a certain artist and count how many occurances there are, but only if the date is logged in the past week. Without the [date] selection and WHERE clause, it works perfectly fine, but selecting [date] along with the other two returns: "You tried to execute a query that does not include the specified expression 'date' as part of an aggregate function."Any ideas?I appreciate any help,Thanks,Matt

Zeehond, thankyou very much. It works nicely now :)Thanks to everyone else too, i appreciate it.

Just tried that, comes out with the same thing.. so i'm guessing * and _ are the same.Thanks anyway.

Hello everyone I was wondering what I should learn next XHTML or CSS? I know quite a bit about HTML and will continue to study it as I go. Thanks for the suggestions.

<{POST_SNAPBACK}>

They kinda go hand in hand, so i'd learn both at the same time.Or if you really can't do that, CSS first.

basicly what i'm tring to do is change the color of the background at the location of a mouse over... does anyone know of a way that this can be done?

<{POST_SNAPBACK}>

<head><style type="text/css">a {background: white;}a:hover {background: red;}<style></head><body><a href="#">Some example text</a></body>

Actually, that only changes the background of the text. If you want to change the body's background then sorry, I don't know; you'd probably need to use javascript which would be hideous to your standards.

Honestly, do not use frames.www.w3schools.com/cssLearn CSS and your pages will be so much quicker, more accessiable, more semantic etc etc.

whats the differance from html and xhtml....any huge changes ect.

<{POST_SNAPBACK}>

Well tags have become much more strict. So <img src="thing.jpg"> should be <img src="thing.jpg" alt="" title="" height="200" width="300" /> for example.Also, XHTML is much more friendly with CSS, esp CSS2. So no more table-based designs (<table width="100%" height="100%" align="center" valign="middle"> is evil).Just that kinda thing. It's great when you learn how to use XHTML web standards, and after that you'll get this nice arrogant glow when you find horrible non-semantic, slow and inaccessiable code on a corporate website.

Hi,I have a website that will have a min-height of 100%, and stretch if the text is more than that. In IE, however, it doesn't allow min-height (as many CSS developers know). I tried using this hack:

min-height: 100%;height: auto;_height: 100%;

But it doesn't work in IE, although using _height: ***px does. I don't want an absolute value though, as I'd like it to stretch like it does in good ol' firefox.Any ideas?Thanks a lot,Matt

Hi, I'm new to these forums so.. hello :)I'm using an UPDATE statement to make a value in an access database increment by one. I've tried this code:

SQL = "UPDATE tbl SET my_db_value = my_db_value + 1 WHERE sql_variable = '" & variable & "'"

But it comes up with an "Object required" error. So I could use an SQL select statement, put that in a variable, and then use that in an SQL INSERT statement, but that's really messy.Any ideas?Thanks a lot,Matt