Perl / CGI / Mysql

ogri · Feb 16, 2001

Hi

I am new to Perl and CGI programming (OK, week off work and I have been playing). I have a minor problem using Mysql. I am having no problems pulling records from a database, but I cannot see how to pull the results of an SQL function. For example I want to know the latest date that certain records have been updated and have coded a "Select max(fred_date) from db_fred where fred_name = 'Smith'"

Presumably I need to return this into a result set. Up to this point I have used the syntax $ref->{'fred_name'} to retrieve the value of a field. What do I use for the result of a function?

Thanks alot

Keith

goBoating · Feb 20, 2001

presumably, your function returns rows. Also, assuming you are using DBI/DBD..... I am more familiar with DBI/DBD:

g for PostgreSQL, but, I think it will be the same...

$dbh1 = DBI->connect(connect stuff here) or die "Failed connect\n";

$sth = $dbh1->prepare("select max(fred_date) from db_fred where .....&quot

or
die "Failed prepare, $DBI::errstr\n";

while (@row = $sth->fetchrow_array) { print "@row\n"; }
$sth->finish;
$dbh1->disconnect;

'Hope this gives a hint about what you are trying to do.

keep the rudder amid ship and beware the odd typo

tsdragon · Mar 8, 2001

You can also use:

while ($var1,$var2,$var3...) = $sth->fethrow_array)

If you prefer the hash, you could also assigning an alias name to the function results. Check the mysql docs.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Perl / CGI / Mysql

ogri

Programmer

goBoating

Programmer

tsdragon

Programmer

Similar threads

Part and Inventory Search

Sponsor