Hello,
For the third search on this query, I would like to add the INNER JOIN
$total_row = ceil(
intval(
current(
$this->db_connection->query("SELECT COUNT(*) FROM zamanlanmisgorev WHERE dosya_adi LIKE '%".$search."%' OR gorev_adi LIKE '%".$search."%'")->fetch_row()
)
)
);
Column name for third search "**secilidb_id**"
The first table: zamanlanmisgorev
| ID | dosya_adi | gorev_adi | secilidb_id |
| 1 | test_test | test2_test | 5 |
Second table name: databaseregister
| ID | name1 | name2 | secilidb_name |
| 1 | test6 | test8 | name1 |
| ---------------------------------------------|
| 5 | test | test | ademgenc |
I want to search adem_genc
dosya_adi LIKE ‘%".$search."%’ OR gorev_adi LIKE ‘%".$search."%’ OR secilidb_id LIKE ‘%".$search."%’
I’m sorry I do not know english
Thank you in advance