Recent content by BigBadDave

I just need to speed up the processing as it only has 20,000 records for the test and takes over 20 seconds to process, but for the live implementation there will be over 8 million records. Regards David Byng www.byngdesigns.co.uk davidbyng@hotmail.com

I need help in optimising the following script: use strict; use 5; use CGI qw(:standard); use POSIX qw(strftime mktime); use DBI; my $from = main::param ("from"); my $to = main::param ("to"); my @from = split (/\//, $from); $from = $from[2] . "-" . $from[1] . "-" . $from[0]; my @to = split...

That's what I need to do, I assume I can do it by selecting the time field and seeing the last request by host name within a 20 minute period for example but I'm not sure. Regards David Byng www.byngdesigns.co.uk davidbyng@hotmail.com

It's not that simple unfortunately, this is what I have but I don't think its accurate: CREATE TEMPORARY TABLE `tmp` SELECT `url`, COUNT(DISTINCT `host name`) AS `num` FROM `access_log` WHERE `date` = '0000-00-00' GROUP BY `host name` ORDER BY `num` DESC; SELECT `url`, SUM(`num`) AS `num` FROM...

I am trying to get a handle on selecting the top 10 entry and exit pages of my apache access_log database. I log the url, host name etc. This is what I have for top 10 popular URL's if its any help: SELECT `url`, COUNT(`url`) AS `num` FROM `access_log` WHERE `date` = '0000-00-00' GROUP BY...

Do you mean like this: http://www.byngdesigns.co.uk/new ?? Regards David Byng www.byngdesigns.co.uk davidbyng@hotmail.com

Do you mean like this: http://www.byngdesigns.co.uk/tek-tips/OpenClickMenu.swf http://www.byngdesigns.co.uk/tek-tips/OpenClickMenu.fla ?? Regards David Byng www.byngdesigns.co.uk davidbyng@hotmail.com

Do you mean like this: http://www.byngdesigns.co.uk/tek-tips/menu_chevy.swf http://www.byngdesigns.co.uk/tek-tips/menu_chevy.fla ?? Regards David Byng www.byngdesigns.co.uk davidbyng@hotmail.com

Something like this: faq250-1292 Regards David Byng www.byngdesigns.co.uk davidbyng@hotmail.com

' menu1 ' is the ' instance name ' not the real name of the menu clip Regards David Byng www.byngdesigns.co.uk davidbyng@hotmail.com

2 options: 1.) set it in your conf file (C:/Program Files/Apache Group/Apache/conf/httpd.conf) 2.) set it in an ".htaccess" file within the dir syntax: DirectoryIndex index.php index.shtml index.htm index.html Regards David Byng www.byngdesigns.co.uk davidbyng@hotmail.com

Hi, How can I load a URL instaed of a document root? I assume you can do it with mod-rewrite but i'm not sure of the syntax insted of: subdomain.my-domain.com -> /htdocs/subbdomain/ I need: subdomain.my-domain.com -> /cgi-bin/prog.sh/prog.w?aff=xcsma Regards David Byng...

Flash 5 version: www.elisemarieacademy.co.uk/menu2.swf www.elisemarieacademy.co.uk/menu2.fla Regards David Byng www.byngdesigns.co.uk davidbyng@hotmail.com

Like the menu on my site: www.byngdesigns.co.uk Regards David Byng www.byngdesigns.co.uk davidbyng@hotmail.com

loadVaribles ("script.php", ""); That will execute a script Regards David Byng www.byngdesigns.co.uk davidbyng@hotmail.com