UPDATE m_products, mc_photo
SET m_products.photo_var = mc_photo.name
WHERE m_products.photo = mc_photo.id;
$db->query('SELECT * FROM `databaseA`.`table`');
DB::$the->prepare('UPDATE statistic SET request = request + 1 WHERE id = ?')->execute(array(1));
SELECT *
FROM users
WHERE date_format(now(), '%m-%d') = date_format(birthday, '%m-%d')
$result = mysql_query("SELECT `name` FROM `added_users`") or die(mysql_error());
SET @rank=0;
SELECT @rank:=@rank+1 AS rank, s.*
FROM (
SELECT p.user_id, SUM(ch.integer) as sum
FROM profile p
LEFT JOIN chronometry ch ON ch.user_id = p.user_id
GROUP BY p.user_id
ORDER BY sum DESC
) s