[RESOLVED] Automatic key-value list from db table

mrgrammar

I have table with about 85 fields of info. I want to quickly display the fieldnames and values in each corresponding field.

while($results = mysql_fetch_array($query)){
	echo $results['fieldname']."-".$results['fieldvalue']."<br>";
}

With 85 fields, I don't want to have to list all 85 fieldnames. I just want it to loop through automatically, show me the name of the field and the value in the field.

How do I do that?

bradgrafelman

Are you saying that the table has 85 columns? If so, this probably points to a grossly unnormalized DB schema.

What on earth does your table structure look like?

mrgrammar

Yes, it is not a normal setup. The person directing the project did not provide information for the creation of the whole project; rather, he gave just a little at a time. As a result, I inherited a project that I have been fixing as I go. I've already broken out a lot of the information into other tables (see below). However, I have to balance that against keeping it usable for the project director. Therefore, I have to do workarounds for some parts until I can get them in proper order. This is one of those times.

There are a total of 30 tables in the database. Most have relatively few fields (less than 3-7) and are related to the very large table about which I made this post. It has 85 columns of unique information for each record (name, address1, address2, city, state, zip, hours available, various dates, etc.).

Res

85 columns does seem a little excessive, but that's a different conversation all together 🙂. Here is one way to loop over results dynamically.

while($results = mysql_fetch_assoc($query)){
    foreach($results as $field_name => $field_value){
      echo $field_name. " = ". $field_value."<br/>";
   }
}

mrgrammar

Thanks! I agree that 85 is excessive and I will be updating it.