While loop only using first row

[TacMaf]

Hi,

I'm trying to update my DB with all the data from another table. The problem is the loop only uses the first row in temp, but does its job too many time.

Table temp has 1000 rows.

Table products ends up with 5008 identical rows (apart from primary key). All data is from row 1 of temp.

public function insertBloodyProducts(){
    $q = "SELECT * FROM ".DB_PREFIX."temp";
    
    while($result = $this->query($q)){
        $row = $this->fetch_assoc($result);
        $cleanURL = preg_replace('/[^a-zA-Z0-9]/i','-',$row['tempName']);
        $cleanURL = preg_replace('/ /i','-',$cleanURL);
        $categories = array("161"); //Array for future additions
        
    
    
    $data = array(...);
        
    $q1 = $this->insertProductQuery($data);

    $result1 = $this->query($q1);

}

} 

This has been driving me crazy. Can anyone see where I'm going wrong?

Cheers,
Rhys