CodeWriter

This is driving me crazy... I want to get/merge data from two tables, and display them in order. This is what i mean: I have 2 tables: Articles id_date (date) id (primary, auto increment) title (text) text (text) publisher (text) Videos id_date (date) id (primary, auto increment) title (text) link (text) description (text) I want to retrieve data from both tables, and display in order. So i could have 1 article published on the 18/04/2012, then a video published on 17/04/2012, then an article published on 16/04/2012 (basically putting both tables into one list/stream, ordered by the date they were published/entered). Dont know if ive explained well enough. Any questions please ask...

Hi All, May be forced to move to a new host shortly. Anyone have any experience with Host Clear (http://www.hostclear.com/) or SuperGreen (http://www.supergreenhosting.com/)? If neccessary please inbox any comments! Thanks In Advance

Hi, I currently have got a script from the interweb which retrieves data from a MySQL database using php, but does it via Javascript. See it here. Heres the bit of script that im focussing on: function showUser(str) { xmlhttp=GetXmlHttpObject(); if (xmlhttp==null) { alert ("Browser does not support HTTP Request"); return; } var url="inc/MostPopular.php"; url=url+"?q="+str; url=url+"&sid="+Math.random(); xmlhttp.onreadystatechange=stateChanged; xmlhttp.open("GET",url,true); xmlhttp.send(null); } Currently it will only load data from the mysql database when the state of a drop-down box is changed. How do i get that script to fire when the function is called? Thanks in advance.

I too get fed up off all the posts in the looking to hire section about doing work for free or very cheeply. I recently finished with a client who, halfway through (the site was almost complete), started comparing me to the "website designers" that offer their services for £30 or less a page. What I find that clients dont seem to realise is that, although most people have got a library of code behind them, a website takes X hours to design and complete. And I refer back to the letter to the architect. I recently had a client who, when the site was finished, decided that he wanted to change the entire aesthetics for the site, bearing in mind he had already changed the look about 100 times. His argument was that i only provided a mock-up for the homepage. Regardless, he hadnt specified that he wanted different page designs. What i really wish clients would understand is that theres a world of difference between freelance designers and template companies/eBay "designers"/web design agencies.

Hi Jessica, I dont usually post in this section, but this is what I think: I will agree that you need to change the background to something else. I think the colours for the background arent bad, but just the clarity needs to be refined (there seems to be alot of pixelation type interferace). Have you tested this in different browsers? Im using IE8 and there is a white strip across the bottom of the site. I will also mention about the spacing here too. At the top there seems to be too many px before the content starts and at the bottom there isnt any px before the white strip/bottom of the page. I would also check out the elements underneat the menu. The twitter section seems to be oddly aligned and the "share" link has a minute scrollbar next to it. Did you send a mock-up to your client before HTML to see what they think? If not then I would always recommend this. The way i see it is that if your client is happy with the look of the site, then everythings fine (even if you disagree). I always think that its a web designers/developers job to make things look presentable and professional. I have had a few clients where I was not at all happy with the end product, but they though it looked great.

They sure do. Ive had it a couple of times (and thats for web design services, as well as complete websites).

The footer problems could be to do with your positioning etc. What i meant by posting codes is that maybe you could try them out as an alternative to what your currently using. I have used that particular script for a long time and havent ever encountered amy problems. Would you be able to post the css for your footer?

<script language="JavaScript1.2"> <!-- /* Contractible Headers Script- © Dynamic Drive ([url="http://www.dynamicdrive.com"]www.dynamicdrive.com[/url]) For full source code, installation instructions, 100's more DHTML scripts, and Terms Of Use, visit dynamicdrive.com */ var head="display:''" function doit(header){ var head=header.style if (head.display=="none") head.display="" else head.display="none" } //--> </script> TO be put in the header and put this: <h3 style="cursor:hand;margin: 3px;padding: 0px;font-size: 105%;" onClick="doit(document.all[this.sourceIndex+1])">Header 1</h3> <span style="display:none" style=&{head};> This is content under Header 1. </span> <h3 style="cursor:hand;margin: 3px;padding: 0px;font-size: 105%;" onClick="doit(document.all[this.sourceIndex+1])">Header 2</h3> <span style="display:none" style=&{head};> This is content under Header 2. </span> Where you want the headers to show. Obviously you will need to customize it somewhat. For more info, go to Dynamic Drive. When your using a script like that its probably easier to edit the raw html (go into the code view of dreamweaver and insert/edit).

The scary thing is, I wouldnt be surprised if that was actually designed by a professional though. I was browsing the web recently and came across a few websites, all designed by the same 'professional'. But imo the websites didnt look that great. Disclaimer: Please note that this is not an attack on specific web designers nor am I saying that im a great designer myself, im just says that some 'professionals' work isnt actually that professional.

In regards to the payment then it depends on how much your charging them. If its alot (and i mean over £650) then i would suggest doing the payment in stages, so you receieve x amount when the design is done, x amount when the framework site is done etc. This way your client will probably feel more comfortable paying you. But if its less than £650 then do the 50/50 and get the first 50% before you do the design. I always request the 50% deposit and will not do any work without it, regardless of what the client promises.

I currently have an issue that many designers are facing, someone is using my copyrighted work without my permission. Now i want to put a stop to this. After doing some research all I can find is a 'Cease and Desist' letter template. Is this the right route to take or not? Thanks

Use this: <input type="hidden" name="random" value="<?php echo $activatecode; ?>">

Or possibly Wamp, thats what i use.

Thanks. I thought that was what it meant but I wasnt sure.

Dont have any tips for you regarding the zooming thing. But just wanted to say that it appears fine when I zoom in and out on Opera (latest version).