Paul Boreham

brilliant, thanks Jay, works a treat!

Hi all, is there any htaccess to block 'double extension' files from being served - i.e. 'something.php.jpg' My htaccess at the moment is; Options -Indexes <Files ~ ".*\.php$"> Order deny,allow Deny from all </Files> Thanks for any help!

So, can I call the same table name and give it an alias - i.e. FROM tableAttribute AS t1 , tableAttribute AS t2 ?? Didnt know you could do that if so and may help - thanks! Thanks for all the other replies above too, really helpful!

Thanks, but that would fail. ATTRIBUTE is 1 column - so (in this context) in cannot be red AND large - its not possible. This feature is possible though as it works on Ebay, Amazon, Halfords etc.

Right - gonna try again and close my previous post as it was too confusing! Simple explanation... ==== I need to query a table to get all the records out that have 2 or more matching values in the same field. So in english... "Show me all records that have an ATTRIBUTE of "red" AND an ATTRIBUTE of "large" So for example, if Product A is red and large, it would show. If product B is large and blue, it wouldnt show. ==== Is that possible in any way? Tried JOINS, UNIONS etc though I'm not advanced enough in mysql to fully understand it. Thanks for any help/suggestions.

Hi all, Got a problem thats a real headscratcher. Client has a large ecom site that I am building and they would like the 'attribute searching' that is popular now on sites like eBay (also Halfords, Amazon etc). So the user clicks on 'Books' for example and then a sub list opens at the side that could say "Hardback", "Paperback" etc with a number in brackets of the amount in that attribute. So the user is basically 'drilling down' to a smaller range of products. I've got 1 level working fine - clicking on an attribute of 'Red' for example shows all my 'red' products. But adding a second level in (and obviously further levels) is proving really hard. I've got the links and code working so when a user clicks on another attribute it adds it to the mysql statement, but I'm not sure how to code the search. I've got a few tables involved here:- 1) Products in category (called ProdInCat and holds values of product Ids and Category Ids) 2) The main product table with all the details in of the product 3) Product attributes (called ProductAttributes, which holds product Id and Attribute Id). So the problem is finding a product in CATEGORY X which has the ATTRIBUTE Y AND ATTRIBUTE Z. Soon as I put the AND in, it returns no results. Phew... Has anyone done anythign similar and how did you get around it? Many thanks! ==== Just to kickstart anyone, this is my current statement... SELECT tabProdInCat.catId, tabProdInCat.prodId, tabProdAttributes.apAttId,tabProdAttributes.apProdId FROM tabProdInCat LEFT JOIN tabProdAttributes ON tabProdAttributes.apProdId = tabProdInCat.prodId WHERE tabProdInCat.catId = %s AND (tabProdAttributes.apAttId = 21 AND tabProdAttributes.apAttId = 27)

Thanks for the reply. Yea, I do know that will create the effect, but the effect I am looking for is so the block of colour stops when the words on that line of a paragraph does. So for example, if I put the background colour on the <p> then the whole block will have a background colour in 1 big square. Think I have it now anyway with the code I re-posted above!

Answering my own question! $expcontent = explode(" ", $row_rsContent['pageContent']); foreach ($expcontent as $content) { echo "<span class='textbg'>".$content." </span>"; } Not elegant and the markup is massively increased, but best I've got at the moment... Anyone do it more gracefully?

Hi all! I made a mistake of designing a site which has a block of colour behind the text on the page - looking much like a 'punk style'. For some reason I thought this would be easy to do, but of course its not! Does anyone have any ideas on how to recreate this? At the moment the colour behind the text is shown in a block (the block of colour should only be behind any text, so if one line of text only has 4 words in, the colour will stop after that text, not carry on till the end of the line). Thanks for any ideas! Cheers, paul

Hi All, Got a quickie - have a transparent gif image that I need to sit over the top of a flash movie (well, actually Flash Image Text Replacement). Works ok in Firefox, but in IE, the flash object is higher than the Gif. I've tried z-index, but makes no difference. This is the site I am working on:- http://tinyurl.com/6khvxj If you click on any of the top links in IE you will see the problem. Any ideas please?! Thanks, Paul

When I moved from one of the UKs largest hosting companies, I was looking for a host that could not only offer me the technical specification I needed, but also one who would give the kind of customer support I had become comfortable with. I trialled a few hosting companies whilst I decided and it was Peartree that ticked all the right boxes for me. I took a quad core dedicated server and from day 1, Rob has been amazingly helpful above and beyond what would be considered 'the norm' and has always been on hand to help out with any issues. I've not experienced any problems with the hosting platform and am delighted with the 100% uptime so far! I would strongly recommend Peartree to any Freelancers or Web Studios who are looking for a great hosting platform backed-up with excellent customer care. If anyone needs any more info about them, then please feel free to drop me a PM!

oh my god Spot on, thanks Mike. Cannot believe I missed that, I feel awful. Spent hours staring at it and trying different things over the weekend. How odd then that it works in IE and Safari. Must be less fussy how data is transferred. Anyway, thanks again - I'm very grateful!

Whatever the problem is, I think its this part now:- function handleStateChange3() { if(xmlHttp.readyState == 4) { if(xmlHttp.status == 200) { document.getElementById("showavailableslots").innerHTML = xmlHttp.responseText; } } } In Firefox, it appears the xmlHttp.status never gets to be 200 - as I changed the line underneath to change the 'innerHTML' of the DIV to be "HelloWorld" and again, this works in all browsers except FF3. I dont really know enough about AJAX, but is there any reason the status would not be 200 at any point? Thanks, Paul

Thanks, I'll give that a go Nah... didnt work - still no AJAX in Firefox. As the code works in IE, the only thing I can think of is a DIV problem - i.e. the innerHTML not being updated and displayed in Firefox. I'll keep trying, but thanks for looking.

Anyone ever had AJAX not work in Firefox (3). Works in Safari on my Mac, but nothing in Firefox. Its simple AJAX that operates 'onclick' will change the 'innerHTML' of a DIV. This is the code, but I doubt it will help on its own.... function startRequest3() { createXMLHttpRequest(); xmlHttp.onreadystatechange = handleStateChange3; xmlHttp.open("POST", '/includes/checksponsoredad.php?type=' + document.getElementById('selAdCategory').value + '&postcode=' + document.getElementById('selAdPostcode').value, true); xmlHttp.send(null); } function handleStateChange3() { if(xmlHttp.readyState == 4) { if(xmlHttp.status == 200) { document.getElementById("showavailableslots").innerHTML = xmlHttp.responseText; } } } As I say, in Safari, works fine. I've tried refreshing Firefox etc. Get no Javascript errors in the developer toolbar either Cannot really give a link as the actual code is behind a login area. Any ideas please? Thanks, Paul