Hey up again!

How can i make a dropdown box / list containing the names of all fields in a table and the values of each name to be the same?

Thanks

?

anyone?

dude (and anyone else without the patience of a priest) you gotta wait for a reply, we don't just sit here waiting for the next person that needs help! Where on this page does it say instant reply, instant chat or instant messenger?

As for how to get the names of all the fields, do this

PHP Code:

$result = msql_query("SELECT * FROM table WHERE id=1", $link);
if (!$result) {
   die("query failed: " . msql_error());
}

$x = 1; // Result set starts from 1

echo "Field names:<BR>";

while ($x < msql_num_fields($result)) {

  echo msql_field_name($result, $x);
  echo "<BR>";

  $x++;

} 


In theory this should work, but im not totally sure! Cause i've not tested it, i just used the PHP Manual.

Thanks!