Перенос описания альбома в таблицу "phpfox_photo_album"

ALTER TABLE `phpfox_photo_album` ADD COLUMN `description` text AFTER `name`;

<?php
ini_set('display_errors', 'On');
error_reporting(E_ALL);

define('PHPFOX', true);

include('include/setting/server.sett.php');

$db = new mysqli($_CONF['db']['host'], $_CONF['db']['user'], $_CONF['db']['pass'], $_CONF['db']['name']);
if ($db->connect_errno)
{
	exit('Error MYSQLI: ' . $db->connect_error);
}
$db->set_charset('utf8');

$q = 'SELECT album_id, description
	FROM phpfox_photo_album_info';
$r = $db->query($q) or exit($db->error);

while ($row = $r->fetch_assoc())
{
	$q = 'UPDATE phpfox_photo_album
		SET
			description = \'' . $row['description'] . '\'
		WHERE album_id = ' . (int) $row['album_id'];
	$db->query($q) or exit($db->error);

	echo $row['album_id'] . ' Ok<br />';
}