All pastes #470019 Raw Edit

Unnamed

public text v1 · immutable
·published 2007-05-04 00:47 UTC
rendered paste body
        #perform the query
	$result = odbc_exec($conn, $query);
	$rslt = $result;

	# get the column names
	$keys = array_keys(odbc_fetch_array($rslt));
	
        #START TABLE.  FIRST ROW IS THE COMUMN NAMES 
	echo "<table border=1>";
	echo "<tr>";
	for ($i = 0; $i < count($keys) + 1; $i++)
	{
		echo "<td>$keys[$i]</td>";
	}
	echo "</tr>";

        #IF I DONT REISSUE THIS QUERY THE SUBSEQUENT WHILE
        #LOOP WILL START AT THE SECOND ROM!  WHY?
	$result = odbc_exec($conn, $query);
	
	while ($res = odbc_fetch_array($result))