Hi!!
I have a CGI that looks up data from a mysql data base and
does a bunch of calculations. I only want to do calculations
on the columns which contains any data. What I mean is for
some colums there is no data available at all. So I don't want to do
any calculations on them obviously. How
On Tue, 3 Dec 2002 at 09:36, T. Murlidharan Nair opined:
TMN:any calculations on them obviously. How do I check whether
TMN:the column contains data, once I have retrived all the data
TMN:using fetchrow_hashref().
you probably should ask on a dbi list.
You can most likely preclude empty/invalid data with SQL. Let's say your
field/column name is 'name'. Then with your DBI prepare() call, you can
preclude records where name is blank, null, or whatever you'd like.
$sth = $dbh-prepare( 'SELECT * FROM table WHERE name IS NOT NULL' );
$sth-execute;
