Please help! (gonna jump!)

[Anon]

How would I go about counting the total records in my db based upon a value (multiple times) and then spitting that number to the browser?

I have been able to do this with ONE count using:
$Query = \"SELECT COUNT(*) FROM mytable WHERE (country LIKE \'%canada%\')\";

I do the SQL query:
$result = odbc_do($connectionstring,$Query);

and I spit it out using:
odbc_result_all($result);

-BUT this only counts up ONE variable, AND spits it out in a rather nasty table format. I would like to count once, store variables, then place them wherever I want in my document.

please help

[reagent]

look at the manual, you'll notice that odbc_result_all just dumps out your recordset in a tablular format. look into odbc_fetch_row()

p.