query saved as variable for email??

Anon

Please please help me on this one. Is there any way to place the whole result of a db query, in the form of a table, into a single variable. This is the query code in my script. Basicaly I would like to email this with mail() as html but when I do it now I can only get the last result to appear.
I'm using Apache/PHP3 on NT.

Thank you in advance.

while( odbc_fetch_row( $cur ) )
{
$nbrow++;
$adclass= odbc_result( $cur, 1 );
$description= odbc_result( $cur, 2 );
$listings= odbc_result( $cur, 3 );

	echo "<tr><td>$adclass</td><td>$description</td><td>$listings</td></tr>\n";



}

sahammondsr

Rather then echo'ing the result, why not save it to a variable and then send that variable into the e-mail, i.e.

$table .= "<tr><td>$adclass</td><td>$description</td></td>$listings</td></tr>\n";

Then just add $table to the remainder of the html output between the <table> and </table> tags.

Scott A. Hammond, Sr., CEO
Prima Internet, Inc.

Anon

nice one mate. Cheers, works a treat - and so bloody simple!