HELP!! - COUNT(*) = I'm having probs?

blunt

I'm wondering if anyone has the patience of an old wise samuri master (who isn't bothered about poor spelling) -

Here is the problem:

$query = ("SELECT COUNT(*) FROM t_apps WHERE a_insp = 0");

This is my query string - I want to output the results into a normal HTML table.

Please can someone complete the parts needed to be able to do this. I have searched all over the place to find a solution but can't get it to work.

Thank You

Phill

matto

this query returns only one record containing one field ...

why put it out in a table?

in my example I assume you select one field from many records which produces a table with 1 column and n rows.

(db query execution depending on your db)
[...]
$result = ??_exec($query, $connection);

echo "<table border=1>\n";

while($record = ??_fetch_array($result))
{
echo "<tr><td>".$record[0]."</td></tr>\n";
}

echo "</table>\n";

note that it's depending on the database you use ("??") (see database reference in the php doc for this; read the postings, too).

blunt

Thanks Matto,

I have got it working now, just out of pure curiousity, is there a way to make more than 1 row. Like a dual query. Instead of writing a new query line for each count process. or will it only ever produce one row?

P.s Thanks again, very gratefull.

Blunt (philly)