parse error

[Marc]

Getting parse errors with this line !!:-(
Can someone please rewrite this ??
I know there is something wrong, but hey i'm newbie :-)
Thanks,

	   	{
		$query = "select id from ".$db_table_prefix."rooms where last_activity < ".time()." - $room_expiration_time";	
	    $query = "select id from ".$db_table_prefix."members where creator_id and user_rights = ".$user_permissions["users"]. or .private_partner_id > 0";
		mysql_query($query) or die("Error: ".mysql_error()." in query: ".$query);
	} 

[cahva]

{
        $query = "select id from ".$db_table_prefix."rooms where last_activity < ".time()." - $room_expiration_time";    

        $query = "select id from ".$db_table_prefix."members where creator_id and user_rights = ".$user_permissions["users"]." or private_partner_id > 0";
        mysql_query($query) or die("Error: ".mysql_error()." in query: ".$query);
    }

[Marc]

many thanks !!
This one works 😃