Query - Value - Werner Otto - com.mysql.lists.perl

4 messages in com.mysql.lists.perlQuery - Value

From	Sent On	Attachments
Werner Otto	15 Jun 2004 07:48
Christopher Pryce	15 Jun 2004 09:35
Werner Otto	16 Jun 2004 03:23
Christopher Pryce	16 Jun 2004 05:41

Subject:	Query - Value
From:	Werner Otto (wo...@dcs.kcl.ac.uk)
Date:	06/15/2004 07:48:49 AM
List:	com.mysql.lists.perl

Hi,

I have a query:

$query = "SELECT (UNIX_TIMESTAMP('$stat_tud_dte $stat_tud_tme')-UNIX_TIMESTAMP('$stat_stu_dte $stat_stu_tme))"; my $sth = $dbh->prepare($query); $sth->execute();

How do I get the results into a variable?