Unlink multiple files from database

Question

I have database that stores the name of the file in a column "name" and the extension in "ext" column

I need to know how to get the data and merge the filename(.)ext into array and then using,

$files = array('some-file.php', 'some-file2.php');

foreach ($files as $file) {
  unlink($file);
}

To delete the files

My code is :

<?php

  include('../dbConfig.php');
   $data = mysql_query("SELECT * FROM snaps") or die(mysql_error());
   $row = mysql_fetch_array($data);

   $files[] = $row['name'].'.'.$row['ext'];
   foreach ($files as $file) {
       unlink($file);
   }

 ?>

Answer 1

Like this?

$Q = "SELECT CONCAT(name, '.', ext) as file_name FROM table;