netyshka

CREATE TABLE test (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
name VARCHAR(20) NOT NULL,
PRIMARY KEY(id),
UNIQUE KEY(name)
) ENGINE=InnoDB;

insert into test (name) values ('John') ON DUPLICATE KEY UPDATE name = 'John';

ROUND(price*1.03, 0);
Тип данных должен быть decimal

SELECT city_name, city_country FROM country WHERE city_name like ........

.........');"><?php echo $country["city_country"]; ?><?php echo $country["city_name"]; ?>