This question is a design - db question. I am new at this, and self-taught, so I am not always sure what is out there already, and what I need to invent.
I need a way for my client to access mySQL information formatted in a meaningful way - that is, not just as records, but as records with relationships. (For example, a member rec points to multiple payment recs, and that relationship must be kept intact. ) I don't want to set him up as a phpmyAdmin user, since that shows the db in too raw a form. So I am down to creating my own page, customizing it to show information, and allowing queries in a form so that the code actually creates the query (since the client doesn't know how to format a query).
Is there a way that people typically supply this sort of interface to clients? Seems like this sort of administrative page will be the most complex to write - the code to just enter, modify members, etc is pretty straightforward.
Thanks for some insight ...
