The column names are the key values of the returned array.
I think you are trying to do something like:
<?php
if (sizeof($Recordset1->Results)>0) {
?>
<table>
<tr>
<?php
foreach ($Recordset1->Results[0] as $key=>$val) {
?>
<th><?php echo($key); ?></th>
<?php
}
?>
</tr>
<?php
for ($x=0; $x<sizeof($Recordset1->Results); $x++) {
?>
<tr>
<?php
foreach ($Recordset1->Results[$x] as $key=>$val) {
?>
<td><?php echo($val); ?></td>
<?php
}
?>
</tr>
<?php
}
?>
</table>
<?php
} else {
?>
no results found
<?php
}
?>