-
Help Me Format Date SQL
Thanks Jock you are the man... I was putting it at the end Thanks again you are a great help
-
Help Me Format Date SQL
Could someone please help me format the date in this SQL statement to European format I have tried DATE_FORMAT(mp3.date, '%e %M %Y') AS date_formatted but it keeps giving me a syntax error Here is my SQL query: SELECT mp3_labels.label_name, mp3_albums.album_id, mp3_albums.album_cat, mp3_genres.genre_name, mp3_artists.artist_name, mp3.title, mp3.mp3_id, mp3.clippath, mp3.date, mp3.single_cat, mp3_albums.album_image, mp3.price, mp3_albums.album_price FROM (((mp3 Left Join mp3_labels On mp3_labels.label_id = mp3.label) Left Join mp3_genres On mp3_genres.genre_id = mp3.genre) Left Join mp3_artists On mp3_artists.artist_id = mp3.artist) Left Join mp3_albums On mp3_albums.album_id = mp3.album ORDER BY mp3.mp3_id Desc Would love some help on this.
-
Big Changed to website! Will this mess up the Google rankings?
Design Web replied to CQ Website Design's topic in SEO (Search Engine Optimisation) & Search EnginesYes it would.
-
Background Image on HTML & Body not working
I do know that technique, but I really wanted to know why the way I am doing it is not working. As I said before I have had this problem before on a complex CSS design and I fixed it, but I can't for the life of me remember how I did it. Dohh! Thanks for your help anyway
-
Background Image on HTML & Body not working
I don't have a link as I am working on my local server but here are the screenshots. Pic 1 is all other browsers and pic 2 is IE 7
-
Background Image on HTML & Body not working
Yes full html design of clean semantic html. ie container div, content div, left column, right column, footer, links, text, images and more. As I said it works in IE 7 but not any other browsers Uuuuuum? very strange
-
Background Image on HTML & Body not working
I am having a problem getting to background images to work together. It works fine on IE 7 which is funny. Anyway I have a background gradient image 20px X 768px applied to the html tag with repeat-x and a 1024px X 768px image applied to the body tag. I am not seeing the body tag image only the html one. Here is the code html { background-image:url(../images/trustco-bg-repeat.jpg); background-repeat:repeat-x; margin:0; padding:0; background-color:#A8A9AD; } body { background-image:url(../images/trustco-productions-bg.jpg); background-position:center top; background-repeat:no-repeat; margin:0; padding:0; }
-
Background Image on HTML & Body not working
I am having a problem getting two background images on different tags to work together. It works fine on IE 7 which is funny. Anyway I have a background gradient image 20px X 768px applied to the html tag with repeat-x and a 1024px X 768px image applied to the body tag. I am not seeing the body tag image only the html one. I had this problem before on another website and figured it out. But I can't for the life of me remember what I did. I thought it was something to do with background colour on the body? Here is the code: html { background-image:url(../images/trustco-bg-repeat.jpg); background-repeat:repeat-x; margin:0; padding:0; background-color:#A8A9AD; } body { background-image:url(../images/trustco-productions-bg.jpg); background-position:center top; background-repeat:no-repeat; margin:0; padding:0; }
-
Problem border in Spry and Safari/Opera
Does anyone have any ideas on this problem?
-
Problem border in Spry and Safari/Opera
I am having a problem with Adobe Dreamweavers Spry Panel. In Safari and Opera a border appears onclick or focus that I can't seem to pin down in the CSS or Javascript. I wonder if this is something Safari/Opera adds itself? Here is a screenshot of what I mean. I would love to be able to get rid of the blue border. Any ideas, I would really appreciate the help.