INNER JOIN about

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

Sponsor our Newsletter | Privacy Policy | Terms of Service