php sql

[dj89]

<?php
                   include('../conn.php');
                 $parola=$_REQUEST['parola'];            
                    
                           mysql_query("SET CHARACTER SET utf8");
                            mysql_query("SET NAMES utf8");
                            $rowsPerPage = 30;
                            $pageNum = 1;
                            if(isset($_GET['page']))
                            {$pageNum = $_GET['page'];}
                            $offset = ($pageNum - 1) * $rowsPerPage;
                
                
                if($parola != NULL){
                $qr1=mysql_query("select * from albo3 where cognome = '$parola' OR nome = '$parola' order by cognome asc LIMIT $offset, $rowsPerPage",$connessione)or die(mysql_error());
                $query="SELECT COUNT(id_albo) AS numrows FROM albo3 where cognome = '$parola' OR nome = '$parola'";
                }else{
                
                $qr1=mysql_query("select * from albo3 where cognome != '' order by cognome asc  LIMIT $offset, $rowsPerPage",$connessione)or die(mysql_error());
                $query="SELECT COUNT(id_albo) AS numrows FROM albo3";
                }
                while($r1=mysql_fetch_array($qr1,MYSQL_ASSOC)){
                    
                    
                    
                
                    ?>

grazie e scusa se nn m so spiegare bene
la union ho provato ma non so come fare il count su piu tabelle
io vorrei fare la select su due tabelle