I have 2 mysql tables i.e customers1 and customers2 with same column names. How do I search from all but only show results of 1?

Question

Php Mysql

Answer 1

Ah I see, you mean you want to return only one result? I'm more familiar with SQL than php, but you would need to do something like making sure the account number column is unique, then writing an SQL query with a UNION clause that searches both tables.

If that isn't your problem then tutorials on CRUD operations with PHP might help: https://www.tutorialrepublic.com/php-tutorial/php-mysql-crud-application.php

Answer 2

I'm not sure I understand, why would you need to search both tables if you only want the results from one of them?

Answer 3

Rincewind i 1st start by selecting an option for district then search for account number. The results shows and there is an edit button. So when i press edit i want it to bring those same results on an edit form. But its not doing that.

Answer 4

Thanks alot