Dear Forum,
Not being an 'expert' at PHP coding, I am keen to know if the following is possible. If I want to export data on members of my society, so that I can produce a report of some sort on members (for example a report by location, or a set of address labels, or other data on member numbers and location distributions), but include the value for each member of, say the field '$usr_id' from the table 'adm_users', is it possible. I am assuming that there will be a bit of PHP code in one of the various back end modules that will construct an SQL statement that will incorporate something like:
'Select x,y,z from adm_users where ... ', where the x, y and z will be the fields that are to be exported, and that I would need to add usr_id to that list. Is that possible? If so, which bit of code would I need to amend please.
Incidentally, I know that in my 'test' database I'm currently working out how to do things with, there is a 'number field' that appears, but this does not appear to link in with the $usr_id field in the source User table, but just a sequential number of the lines of data exported.
Thanks in advance for any suggestions, or guidance
Peter Robinson
Webmaster, SSEA Canada.
Inclusion of database table values
-
- Beiträge: 12
- Registriert: 2. Aug 2023, 22:11