I'm trying to use mySQL directive DECRIBE to lsit the column names in a query result, then use that data to output the results to a page, without explicitly specifying the column names. I've gotten this far, without success: <?php //... get initial city data $city = "NYC"; $query1 = "SELECT * FROM mastercities WHERE CityCode ='" .$city ."'"; $result1 = mysql_query($query1) or Die("query 1 failed"); $query2 = "DESCRIBE mastercities"; $result2 = mysql_query($query2) or Die("query 2 failed"); while($row1 = mysql_fetch_array($result1)) { while ($row2 = mysql_fetch_array($result2)) { $currentRow = "'".$row2['Field']."'"; echo "<break>".$row1[$currentRow].", "; } echo "<para>"; } ?> I know these queries work independently, but as a novice php person, I'm stuck - any guidance would be appreciated... Thanks, Elwoody