[RESOLVED] Tabular Display Of MySQL Results

[macmonkey]

I've successfully created a very simple survey system wheras people can take surveys etc..

I'm needing to make a page where "admin" can check these results without having to visit the dbase via php myadmin and such...

My table: survey_results

Fields Being Printed:

id ( Not Unique )
your_name
club_name
city
state
danceability
dance_participation
crowd_participation
rating
comments

I'd like to get these printed in a nice "tabular" layout with each individual entry horizontally listed.

EXAMPLE
/////////////////////////////////////////////////////////////////////////////////////////////////
/// ID /// your_name /// club_name /// city /// state /// danceability ---- etc.///
/////////////////////////////////////////////////////////////////////////////////////////////////
/// blah blah // jon doe /// doe club /// doeville /// TN /// 8 /// ------/////////////////
/// blah blah // jon doe /// doe club /// doeville /// TN /// 8 /// ------/////////////////
/// blah blah // jon doe /// doe club /// doeville /// TN /// 8 /// ------/////////////////
/// blah blah // jon doe /// doe club /// doeville /// TN /// 8 /// ------/////////////////
/// blah blah // jon doe /// doe club /// doeville /// TN /// 8 /// ------/////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////

I would really appreciate any help you guys can give me on this one - even tutorial links would be excellent.

Thanks

[LoganK]

Use a table and a loop for your mysql query.

[macmonkey]

Thanks for the loop tip. I found an excellent example : http://www.tizag.com/mysqlTutorial/mysqlselect.php

[LoganK]

You're welcome! Don't you feel better that you figured it out for yourself instead of using a 1-shot answer? At least you learned something...😃

[macmonkey]

Well actually your answer was what I was looking for. I'm very new w/ php and didn't know what a loop did or WAS for that matter.

I'll be the last to simply come to the board and post something I could figure out myself but not knowing what to search for can provide a daunting task.

[LoganK]

Allright then. Glad I could help 🙂