MySQL total row and total row of search


#1

Hello,

Total row(s) without search and Total row(s) of search


  $total_rows = ceil(
                   intval(
                     current(
                       $this->db_connection->query("
                                      SELECT COUNT(*) FROM zamanlanmisgorev.id,
                                      zamanlanmisgorev.dosya_adi,
                                      zamanlanmisgorev.gorev_adi,
                                      zamanlanmisgorev.secilidb, 
                                      databaseregister.database_name,
                                      databaseregister.database_id  
                                      FROM zamanlanmisgorev 
                  INNER JOIN databaseregister ON zamanlanmisgorev.secilidb = databaseregister.database_id 
                  WHERE zamanlanmisgorev.dosya_adi LIKE '%".$search_post."%' OR zamanlanmisgorev.gorev_adi LIKE '%".$search_post."%' OR zamanlanmisgorev.secilidb LIKE '%".$search_post."%'")->fetch_row()
                     )
                   )
                 );

1st. Table Name: zamanlanmisgorev 
+--------------+--------------+----------+
|-dosya_adi- |-gorev_adi | secilidb |
+--------------+--------------+----------+
|aaaaaaaaa | bbbbbbbb |----5------|
+--------------+-------------+-----------+


2nd. Table Name: databaseregister
+---------------+--------------------+
|database_id |database_name |
+--------------+---------------------+
|-------5------ |------adem--------- |
+--------------+---------------------+

Can you help me?
Thank you in advance