JonasLAX

Hi everybody, I am fighting with the statelessness of the web once again. I roughly have the following situation: I have a search-engine like website which has a list with results in the left column and then in the right column information on one specific item from that list. If I enter element1 as a search term I will get a certain resultlist based on element1 in the left column and the content for element1 in the right column with the url of the page being url/element1. If I select the next element from the resultlist, the URL changes to url/element2 with the resultlist being loaded from the cache and the right column being filled with the element2 content. Now, I would like to deeplink to url/element1 directly and in that case open the resultlist of a query of only element1 in the left column and the actual element1 in the right column (instead of using the cache for the resultlist in the left column which can be different as when we go through the resultlist instead of deeplinks). Therefore, if I have a query which outputs: url/element1 url/element2 and select the second link I would like the right column to be filled with the content of element2 without changing the left column. If I directly enter url/element2 into the address bar of the browser however, I would like the system to create a new page with the element2-content in the right column AND a new resultlist of the simple query 'element2' in the left column. Unfortunately, my resultlist to the left is not a form so I can not simply set a $POST parameter and for SEO-reasons I would hate having to use a $GET parameter in the url. To summarize, I believe I need a clean way to differentiate between an internal link request and an external link request without using a $POST paramter. Any ideas on a clean solution to this dilemma? Thanks!

Hi everybody, I have a table with data like this: Dublin Dublin Gallery Dublin Gallery10004941 Berlin Berlin Shop Berlin Shop10002938 I would like to select "Dublin Gallery10004941" and "Berlin Shop10002938" because for both there are entries with exactly the same name but without the 8-digit number at the end (it always is 8 digits). Can anybody help me with this query? Thanks, Jonas

But I can't be the first one ever to bump into this problem?! There must be a nice solution for non-Googles or not?

Hi dbo, Thanks for your reply. Definitely there is a data quality issue here. The problem is that the data is aggregated other a wide range of sources which lie beyond our control. Therefore, we are in the unfortunate position of having to find a way to cope with the current input and try and clean it up. Any special suggestions/best practices on how to structure the LIKE clauses?

Dear all, I have the following problem. I have a lot of data from different sources in the same table. In a lot of cases there are duplicate entries but with slightly different names. For example "Lord of the Rings" and "The Lord of the Rings". Now I assume that it will probably be almost impossible to automatically select these records as exact matches. But what I would like to do is to create a list with suspected duplicates and then manually go through this list and decide which entries are duplicates and which aren't. The table currently has about 35.000 records so the algorithm also has to be sort of smart and use a technique more sophisticated than simple brute force. Can anybody show me the direction I should be looking at? Thanks, Jonas

Thanks - worked like a charm

Currently not, just a simple file_get_contents() - should I try and change to CURL? Thanks!

Hi everybody, As an entrepreneur who started his own web business a couple of months ago I find myself having to write some basic PHP stuff which is giving me a bit of a tough time as I come from desktop programming. Therefore, I believe that most of my questions will be very easy for you to answer. I've created a script now which I have successfully set up as a scheduled task on my own machine to be executed every couple of hours. However, I would like to execute this script through a proxy server. I know how to browse using a proxy server but I assume that setting up Firefox to use a proxy will not make the automated script execution of php go through the same proxy. Therefore, my question is how do I change the script to connect to an external proxy server and then execute through that. Or do I have to configure my local apache server to connect to some proxy and that is it? Do you know of any good free proxies by any chance? Thank you very much in advance! All the best, Jonas