Hi  

I want to be able to pull off and print the colum names and values from a mysql table.  The program below gets the data out, but I have no way of being able to tell from the output what the colums was called.  The other problem is I have to tell it the number of colums to grab.  

Is there a way of grabing the entire row of values /column names straight into an array?  I did try substituting mysql_fetch_array for mysql_fetch_row, but it made no difference.

Thanks

Chris

Code:

<?php $data=array(); $hot=$_GET[hid]; include ("/usr/home/limited.org.uk/data/standard.inc");      sql_connect();      $q = "Select * from hotel,locations where hotel.location = locations.id      and hid = $_GET[hid]";      $res = mysql_query($q);            while ($row=mysql_fetch_array($res)){                  array_push($data,$row[0],$row[1],$row[2],$row[3]);            } foreach ($data as $current){            print "data is $current<br>"; } ?>

Mysql_fetch_assoc will return you an array of values for a row, with the elements keyed by the name of the field.  You can then use array_keys, array_walk, each, or something similar to step through each element.

---