Search results for query: *

Hi guys, For some reason I'm having a sod of a time with the following rule: RewriteRule search/(.*)_P([0-9]+).html http://www.site.com/search/$1_p$2.html [R=301,L] With the example URL: http://www.site.com/search/lions_P4.html ... I would have expected it to match, and sends us to the new...

Hi, For some reason the following SQL query doesn't want to work any more (its part of an existing program, and has worked on a million other sites); SELECT * FROM Category WHERE Full_Name LIKE "Comercios/_pticas" The Full_Name it should be matching has: Comercios/Ópticas Any ideas why this...

Hi, I've got a REALLY annoying issue here. Basically, I have 2 sites (very similar setups, but different domains and different content). Here is my setup (this is using a WHMS, with cPanel... so I have to edit the pre_virtualhost_global.conf file, so my changes dont get overwritten)...

Hi, I'm a bit baffled by this error I get: Operand should contain 1 column(s) ..with the following query: SELECT *, ( 6371 * acos( cos( radians('43,7335') ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians('2,3985') ) + sin( radians('43,7335') ) * sin( radians( latitude ) )...

Hi, I've got a bit of a weird issue here. I'm running a script (which takes a while to run), but it always gives me the wrong runtime for the process. See this: chambr22 28223 52.8 0.5 53372 45744 pts/0 R+ 10:34 28:44 perl nph-build-custom.cgi ..yet the time at the moment, is: Sat...

Hi, I'm trying to get a URL such as: http://www.site.com/cgi-bin/search.cgi?query=;sb=Sponsored_c;so=DESC;mh=25;Type=x;Options=foo-bar;nh=11 ...to goto: http://www.site.com/collections/foo-bar/ I'm using this line as a test: RewriteCond %{QUERY_STRING}...

Hi, I'm trying to do some optimizing of the tables, and I found this query which is taking 0.15 seconds to run: SELECT * FROM glinks_Links WHERE ( Options LIKE '%30 minute meals%' AND Type = 'Recipe' AND isValidated = 'Yes' ) ORDER BY Sponsored_c DESC LIMIT 0 , 25 The table is reasonbly large...

Hi, This is driving me up the wall. I bet its something stupidly simple - but I'm not seeing it :( SELECT * , MATCH (Keywords) AGAINST ('mascot') AS score FROM glinks_Links WHERE MATCH (Keywords) AGAINST ('mascot') ORDER BY score LIMIT 25 ...yet it gives no results. Here is an example of...

Hi, First of all - I am full aware of jQuery for this kinda stuff, but I need to do it in pure javascript (due to the fact we only use jQuery on a small handful of pages, and can't afford to put a large file on the whole site - as its already quite busy). I wrote the following code: var...

Hi, A always, these damn browsers don't play ball :( I have the following code that will change the background color of a link (flashing); window.onload = function () { the_array = getElementsByClassName(document,'flashingtext'); for (i = 0; i < the_array.length; i++) {...

Hi, I'm a bit baffled about a "bug" I've found with my map code. The following query is being run: SELECT ID,Title, ( 6371 * acos( cos( radians('41.7282358') ) * cos( radians( Latitude ) ) * cos( radians( Longitude ) - radians('9.212059299999964') ) + sin( radians('41.7282358') ) * sin(...

Hi, I'm a bit baffled about a "bug" I've found with my map code. The following query is being run: SELECT ID,Title, ( 6371 * acos( cos( radians('41.7282358') ) * cos( radians( Latitude ) ) * cos( radians( Longitude ) - radians('9.212059299999964') ) + sin( radians('41.7282358') ) * sin(...

Hi, I'm trying to setup a perl script that will grab results that are older (or newer) than the current time. SELECT * FROM Links WHERE expiredate2 < '2012-01-10 02:04:39' This gives a syntax error, but weirdly - using > doesn't seem to: SELECT * FROM glinks_Links WHERE expiredate2 >...

Hi, Man, this is screwed up :( I've been tearing my hair out over it for the last few hours. If you go here: http://www.chambresdhotes.org/cgi-bin/links/page.cgi?g=Google_Maps&t=espanol&q=Paris&radiusSelect=30 You will see a google map, with markers and a sidebar. Everything works here...

Hi guys, I'm trying to clean up this query a bit, to make it quicker: SELECT ID, Ville, Title, Image1, Telephone, ExpiryDate, Address, Postal_Code, Latitude, Longitude, ( 6371 * acos( cos( radians('42.93481749134106') ) * cos( radians( Latitude ) ) * cos( radians( Longitude ) -...

Hi, I'm trying to work out a better way to extract a URL from a { } hash value dumped in a mySQL table. The value held looks like so: { 'Image1' => 'http://www.chambresdhotes.org/links/images/4/384654-accueil.jpg', 'Image1_large' =>...

Hi, I'm trying to copy over a 2GB MySQL .sql dump from a UNIX server, so I can process it manually on my PC. The problem I have though is that my C: drive isn't very big. When I installed mySQL (from mysql.com) onto my PC it asked me where I wanted to install it, and I said D: drive (which...

Hi guys, I'm trying to make a rewrite rile for: http://www.cancunandrivieramaya.com/archives/cancun.cgi?md=index;page=1 ..so it sends to: http://archives.cancunandrivieramaya.com/archives/cancun.cgi?md=index;page=1 The rule I have at the moment is: RewriteRule ^archives/cancun.cgi...

Hi, I'm trying to get a rewrite rule where it has p=analytics, to goto the homepage of my site (I've set it to google.com, just to make it more obvious when its working); http://www.site.com/cgi-bin/page.cgi?p=analytics ..the rule I have is: RewriteCond %{QUERY_STRING} analytics RewriteRule...

Hi, I'm trying to do a bit of a weird thing here ;) Originally when the site was setup - it was set as "english" for the homepage, and then /french/index.html was a sub-page. However, we now want to "reverse" that (but we need to keep the other URL's the same!) Now, these 2 works fine when...