Getting Output for 'do' Query.

2007-06-30 Thread sara.samsara
my $query = qq|SELECT SUM(MINS) FROM files WHERE USER='$user'|; my $do = $dbh->do($query); print "$do"; Where MINS is integar, Now when I print $do it obviously prints only '1', marking return of the query. Running query in phpMyAdmin prints the '2864' sum of all mins. How I am supposed to p

Looping Dates.

2008-01-18 Thread sara.samsara
I am stuck here, I want to get list of dates in a certain range. Like: Start Date: 2007-01-03 to End Date: 2007-05-30 I am pointless here as what should I do in order to get all dates between start and end? Is there any for, foreach loop or other method? that will generate a list of dates: 200

Extracting TD's from a Text File (Regex Help).

2008-04-08 Thread sara.samsara
TEXT FILE ## http://mysite.com/link/here_goes?id=239";>LINK   http://mysite.com/link/here_goes?id=239";>LINK 06/11/2007 12:29AM The text file contains hundreds of tds structure lik