Devon --
...and then Devon said...
%
% David T-G wrote:
%
% >Note that I don't recommend this as the best approach, and I don't think
...
% >doing it in two steps of loading your $everyone and then spitting out I'd
% >probably do something like
% >
% > $sql = "select id,name from a_table order by department" ;
% > $result = mysql_query($sql) ;
% > while ( $row = mysql_fetch_array($result) )
% > { print "ID: {$row['id']}\tName: {$row['name']}<br>\n" ; }
% >
% >to just run through the data. I'm sure others here know of even better
% >ways to print a roster :-)
...
%
% Indeed, I was trying to simply display a list of the data. I had coded
% the formatting and displaying first, based on the array I described,
% then tackled the MySQL part last. I see now that it prevented me from Been there; oops-ed that. You can even let the DB format your output for you so that it spits out HTML and then you're *really* on your way to just dumping the output to the page! :-) % seeing the better idea of removing the array from the equation % completely. Your information was invaluble. Happy to help! % % I did however go with mysql_fetch_assoc instead of mysql_fetch_array for % efficiency. :) I hear more and more that that's the way to go :-) HAND :-D -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health" http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg!
pgp00000.pgp
Description: PGP signature
