Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am successfully able to fetch data from mysql using tmysqlrow and have it emailed after doing some data manipulation using tjavarow.
Now I wish select all the categories and subcategories from the first table.
Then generate an email category wise. This is what I would want the three emails to look like.
i can think of two approaches
Approach 1: I run a select query on each on the first table and fetch all the categories and subcategories and then for each of the subcategories, i go to the second table, select all the columns i need and then send out the email for each category.
Approach 2: I use a join select statement, fetch everything and then email everything category wise, is this possible?
help please.