· 8 years ago · Jun 16, 2018, 07:14 AM
1CREATE TABLE IF NOT EXISTS `data` (
2`id` BIGINT NOT NULL AUTO_INCREMENT UNIQUE,
3PRIMARY KEY (`id`)
4)
5SELECT `field1`, `field2`
6WHERE `active` = 1
7
8if (mysql_query($query1)) {
9 return mysql_query($query2);
10}
11return false;
12
13$query = 'SELECT `field1`, `field2` WHERE `active` = 1
14 UNION
15 SELECT DO_ONE(`field1`), DO_TWO(`field2`) WHERE `active` = 1
16 ORDER BY `field1`';
17return mysql_query('CREATE TABLE IF NOT EXISTS `data` (
18`id` BIGINT NOT NULL AUTO_INCREMENT UNIQUE,
19PRIMARY KEY (`id`)
20) ' . $query)