Mark Hensler — Wed, 04 Jun 2003 02:29:33 +0000

You're creating an object within a function? You should probably make the variable static, or pass the object as an argument to the function (or just destry the object before returning from the function).

mairving — Tue, 03 Jun 2003 17:15:59 +0000

The advantage is usually that there is less code to write which, of course, reduces debugging time, etc. Speed is better usually as long as it is not a complex query.

Suzanne — Tue, 03 Jun 2003 16:54:41 +0000

What's the advantage to using MySQL (or any other db) over using scripting?

mairving — Tue, 03 Jun 2003 16:43:31 +0000

I usually prefer to do in SQL, depending on the query times. I wrote it as a function in a class like so:

<?php
function count($fieldname) {
$db_sql = new db_sql;
$count = $fieldname.\"_count\";
$q = \"SELECT sum($fieldname) as $count \";
$q .= \"FROM tablename \";
$q .= \"WHERE $fieldname >= '1' \";
$db_sql->query($q);
$db_sql->next_record();
return $count;
}
?>

So that I just have to call it via:

<?php
$class->count(\"fieldname\");
?>

Mark Hensler — Tue, 03 Jun 2003 16:27:46 +0000

I like to do as much work in mySQL as possible.

SELECT sum(countfield) AS fieldname_subtotal FROM tablename GROUP BY typefield

This would give subtotals for various `typefield`, then suming those (in PHP) would give a grand total.

Suzanne — Tue, 03 Jun 2003 16:18:52 +0000

Interesting. I haven't done anything that requires tabulating with a database, so I'm not much help opinion-wise (aren't you relieved!) but I'm curious about whether it'd be better to have the database do the work or the application (perl/php/asp)?