SQL problems and CSS problems

[Kezzer]

Just two things. First off, i've got the correct formatting for my date which is pulled from the database but i deleted the database and have forgotten which data type i had set that entry in the news table to. Which one is it? Datetime? Date? etc. 'cause none of them are working :X

Also, http://www.kezzer.co.uk/new/ Check that out, the background in main should expand all the way with the text. Not sure why this isn't working, any ideas?

Muchos gracius

[malfunction]

Depends what database you're using... If we're talking mysql then date is just a date (YYYY-MM-DD) and datetime is the date and the time - it's also known as a timestamp in other databases (YYYY-MM-DD HH:MM:SS)... Though IIRC some databases that use timestamp also include milliseconds...

Not sure what you're on about with the 2nd bit. Got a photochop of what you want it to look like?

[javalord]

I thought SQL date statements are DD-MM-YY , in use with TO_DATE and other functions? Is so in Oracle. The website could be screwing up as you may not be using %.

[Spunkey]

it all depends on system date format on the server as to how the date in SQL comes out.

In the server it may be stored one way, but when displayed via scripting it can change.

If you're using ASP, heres the function i use to normalise dates...

function FormatDate(szDate)
  FormatDate = right("00" & day(szDate), 2) & " " & monthname(month(szDate), false) & " " & year(szDate)
end function

This gives you back something along the lines of '05 August 2004'.
The advantage of using the month as a string value means that it'll never revert to an American date format (08 May 2004), even if the server is set that way.

HTH!

[Iain]

you probably want datetime

You've set the height of the container object to 100% but then the content is nested in a floating div so it sets the object to 100% of the height of the container which in this case is the window size. You need to get rid of the float to make the background continue for all the content

[Kezzer]

Cheers guys, time is working now, had to re-create the table anyway 'cause of some other problems.

The background is expanding to the left column only now but it works fine (just need to fix all the problems in IE now :S )

Anyway, check it out, http://www.kezzer.co.uk/new/ If it's not there then go to the root website since i'll be moving it soon. Any feedback would be nice

[Jonny M]

The copyright info on the right hand side drops off onto the background in Firefox.

[Kezzer]

The copyright info on the right hand side drops off onto the background in Firefox.

Yeh i know, that's the only problem, when there's enough content in the left column it will fill out so that's not a problem really. But other than that?