First things first. This site is a great resource. Glad I found it.
Now some background. Like most of the people posting questions, I'm very new to both php and mySQL. I'm only stumbling thru all this stuff because of one database I wanted online. After just a few days screwing around with online tutorials I've got two 'experimental' weboutput pages.
http://www.pstvalumni.com/directory/display.php (straight forward)
http://www.pstvalumni.com/directory/display2.php (trying some sorting)
Now I've got a few general quetions that will hopefully lead me in the right direction of where to look for more indepth details...
1. If you click the 2nd link above (the sortable one), you'll notice that whenever you chose a column to sort, it always puts the "blank" one's on top. Under the blank entries everything else ends up in the correct order. How can I sort my data but prevent the blanks from being on the top?
2a. I have 174 rows of data, each one is a person with info about them. I have all this info in one table. I look at how other scripts do similar displays and they often have limited info on the main listing page, but if you click on a link you go to another page that displays all of the full data associated with that one person. In general concept terms (not getting into specific coding just yet) how is this done? Is this simply linking to a second php page designed to display that one person's data? Or is it all in one big complicated php page.
2b. Also when looking at how other scripts do this, I see that these other scripts span their data over many different tables. Why? Is this necessary or can I just have all my data in one table?
3. If you look at either link above, both are "display all" with "sort by lastname". It looks okay at first but if you go down to the "Z's" you'll see there are 11 extra results below Z (somehow in alphabetical order from that point on). What's going on here? One clue is that those 11 rows are the same ones that I needed to edit due to complications when creating my table, but I don't know why they're sorting differently.