PHP - Update Statement, How Would I Select And Change 100 Random From Selection

In the same $-POST , i wanted  to perform update and delete. With the updated and deleted database, I need to select the updated data from the database. However, it tells me:  Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in... .I am new to sql in php, is it true that i cannot perform sql in this way? Or is there any suggestion to perform select straight after deleting and updating?

CANCEL BOOK RESERVATION
if(isset($_POST['cancelres']))
{


        $query = "DELETE FROM reserved_books WHERE id='$resid';"; //delete reservation
        $query .="UPDATE reserved_books SET queue = queue - 1 WHERE bookid = '$bookid' AND queue > '$bookqueue';";//update queue number where reservation that queue behind/after/ the current reservation
        $query_run = mysqli_multi_query($connection, $query);

        if($query_run)
        {
          $_SESSION['success'] = "Reservation Cancelled";
        }
        else
        {
          $_SESSION['status'] = " Reservation Not Cancelled";    
        }

        $query= "SELECT title FROM books WHERE id = '$bookid';"; //get book title from db
        $query_run = mysqli_query($connection,$query);
        if(mysqli_num_rows($query_run)>0)
        {
            foreach ($query_run as $row) {
            $title = $row['title'];
            }
        }
        $bookres = "SELECT * FROM reserved_books WHERE bookid = '$bookid' AND queue = 1";
        $bookres_run = mysqli_query($connection,$bookres);
        foreach($bookres_run as $row)
        {
            $res_username = $row['username'];
            $res_id = $row['id'];
        }

        $query= "SELECT option_value FROM settings WHERE option_name = 'email_temp_rescollect'"; //get email template from db
        $query_run = mysqli_query($connection,$query);
        if(mysqli_num_rows($query_run)>0)
        {
            $row = mysqli_fetch_array($query_run);
            $rescollect_template = $row[0];
        }}

I need to convert the following select statement to a pdo->query but have no idea how to get it working:

SELECT t.id FROM 
  ( SELECT g.* 
    FROM location AS g
    WHERE g.start <=  16785408
    ORDER BY g.start DESC, g.end DESC
    LIMIT 1
  ) AS t
WHERE t.end >= 16785408;

Here's the code I'm trying:

<?php

$php_scripts = '../../php/';
require $php_scripts . 'PDO_Connection_Select.php';
require $php_scripts . 'GetUserIpAddr.php';
function mydloader($l_filename=NULL)

{
$ip = GetUserIpAddr();
if (!$pdo = PDOConnect("foxclone_data"))
{    
    exit;
}
    if( isset( $l_filename ) ) {  
        $ext = pathinfo($l_filename, PATHINFO_EXTENSION);
        $stmt = $pdo->prepare("INSERT INTO download (address, filename,ip_address) VALUES (?, ?, inet_aton('$ip'))");
        $stmt->execute([$ip, $ext]) ; 

        $test = $pdo->prepare("SELECT t.id FROM ( SELECT g.id FROM lookup AS g WHERE g.start <= inet_aton($ip) ORDER BY g.start DESC, g.end DESC ) AS  t  WHERE t.end >=inet_aton($ip)");
        $test ->execute() ; 
        $ref = $test->fetchColumn();
        $ref = intval($ref);

        $stmt = $pdo->prepare("UPDATE download SET ref = '$ref' WHERE address = '$ip'");
        $stmt->execute() ;         

        header('Content-Type: octet-stream');
        header("Content-Disposition: attachment; filename={$l_filename}");
        header('Pragma: no-cache');
        header('Expires: 0');        
        readfile($l_filename);
       }
        
    else {
        echo "isset failed";
        }  
}
mydloader($_GET["f"]);
exit;

 It gives the following error:

Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.144.181) ORDER BY g.start DESC, g.end DESC ) AS  t  WHERE t.end >=inet_aton(7' at line 1 in /home/foxclone/test.foxclone.com/download/mydloader.php:19 Stack trace: #0 /home/foxclone/test.foxclone.com/download/mydloader.php(19): PDO->prepare('SELECT t.id FRO...') #1 /home/foxclone/test.foxclone.com/download/mydloader.php(38): mydloader('foxclone40a_amd...') #2 {main} thrown in /home/foxclone/test.foxclone.com/download/mydloader.php on line 19

How do I fix this?

RewriteOptions inherit
RewriteEngine on
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d

RewriteRule ^([a-z0-9-]+)$ /storeNumber.php?storeNumberID=$1 [NC,L]