₦airaland Forum

Please I need help.
This image will explain everything. Thanks

SELECT referenceID,email,transaction_type,payment_method,Amt FROM tbltransaction UNION SELECT referenceID,email,transaction_type,payment_method,Amt FROM tbltransactionbank



By the way, you can use the same table and add make the teller column optional

walterjnr:
Please I need help.
This image will explain everything. Thanks

First learn PHP inner Join it will help you join tables so that you can echo out the data's easily.


Then write a function for the table... Something like

SELECT * referenceid,email, transaction_type, payment_method, amt from tbltransaction INNER JOIN tbltransactionbank WHERE id="";


Google this .... Just feel like to give you a clue.. you can try Stackoverflow

hollyfat:
SELECT referenceID,email,transaction_type,payment_method,Amt FROM tbltransaction UNION SELECT referenceID,email,transaction_type,payment_method,Amt FROM tbltransactionbank



By the way, you can use the same table and add make the teller column optional

The design of the system did not allow me to use one table.

hollyfat:
SELECT referenceID,email,transaction_type,payment_method,Amt FROM tbltransaction UNION SELECT referenceID,email,transaction_type,payment_method,Amt FROM tbltransactionbank



By the way, you can use the same table and add make the teller column optional

Thanks Man

walterjnr:
Please I need help.
This image will explain everything. Thanks

First off, this isn't PHP - it is SQL, most likely MYSQL. Secondly, what are you doing? Thirdly, the second table is exactly the same as the first table, save for one column. Finally, aren't the columns in the proposed third table the same as those in the first table?
If you want my candid opinion, that database schema needs to be redesigned ASAP. It would be more efficient to have only a "tbltransaction" table and drop the "tbltransactionbank" table. Better still, you can keep the "tbltransaction" table while changing the transaction_type to type_id (or transaction_type_id) which will link to a transaction_type table. As a developer, always remember you have finite resources; don't waste computing resources on inefficient tasks.

hollyfat:
SELECT referenceID,email,transaction_type,payment_method,Amt FROM tbltransaction UNION SELECT referenceID,email,transaction_type,payment_method,Amt FROM tbltransactionbank



By the way, you can use the same table and add make the teller column optional

Your method worked .