SQL statement works in a query but not in a PHP script

The below code runs just fine in the SQl console. Non "pagetype" itmes are not updated as designed.

UPDATE expire as A 
LEFT JOIN content_type_pagetype as C ON A.nid = C.nid 
LEFT JOIN node as N ON A.nid = N.nid 

SET A.expire = C.field_endtime_value 
WHERE N.type = 'pagetype' 

Code (markup):

When I run it through a PHP script like below, it changes the expire field on ALL items that are not 'pagetype' to '0'.

<?php
    $conn = mysql_connect('localhost','password','username');                             // make an sql connection

    $db = mysql_select_db('dbname',$conn);                                     // navigate to db
    $query = "UPDATE expire AS A ";                                                    // update autoexpire

    $query .= "LEFT JOIN content_type_pagetype AS C ON A.nid=C.nid "; 

    $query .= "LEFT JOIN node AS N ON A.nid=N.nid ";                            
    $query .= "SET A.expire = C.field_endtime_value ";                            // set expire to end time

    $query .= "WHERE N.type='pagetype' "; 

    $updatedb = mysql_query($query); 

?>

Code (markup):

I have tried this line 3 ways:

    $query .= "WHERE N.type='pagetype' "; 
    $query .= "WHERE N.type="pagetype" "; 
    $query .= "WHERE N.type=\"pagetype\" "; 

Code (markup):

What am I doing wrong?

 

Thanks for the help, but it would help if you run the correct file. I can't believe I was doing this all morning??? It's working just fine.