XJrbH8et

1DROP TABLE IF EXISTS `address`;CREATE TABLE `address` (  `Id`
2int(11) NOT NULL auto_increment,   `EntityId` int(11) NOT NULL,  
3`sStreet1` varchar(50),   `sStreet2` varchar(50),   `sCity`
4varchar(50),   `sLoc` varchar(50),   `sPv` char(2),   `sState`
5varchar(50),   `sZip` varchar(10),   `sType` varchar(50),  
6`FiscalAddress` tinyint(1) NOT NULL,   PRIMARY KEY  (`Id`) );
7	
8$result = mysql_query($query);
9if (!$result) {
10    $message  = 'Invalid import content: ' . mysql_error() . "nn";
11    $message .= 'Whole query: ' . $query;
12    die($message);
13}
14	
15$dt = mysql_query("DROP TABLE IF EXISTS `address`");
16if ($dt) {
17  // Execute CREATE TABLE separately...
18  $ct = mysql_query("CREATE TABLE...........");
19  if (!$ct) {
20     // Proceed with the rest of your code.
21    $message  = 'Invalid import content: ' . mysql_error() . "nn";
22    $message .= 'Whole query: ' . $query;
23    die($message);
24  }
25}
26else {} // DROP TABLE call failed. Handle appropriately.
27	
28$mysqli = new mysqli($this->DATABASE_HOST,$this->DATABASE_USER,$this->DATABASE_PASS,$this->DATABASE_DB );
29
30    if ($mysqli->connect_errno) {
31            $message = "Connect failed: ". $mysqli->connect_error;
32    }else{
33
34        $result = $mysqli->multi_query($query);
35            // Check result
36            // This shows the actual query sent to MySQL, and the error. Useful for debugging.
37            if (!$result) {
38                $message  = "Failed to run query: (" . $mysqli->errno . ") " . $mysqli->error ."nnr";
39                $message .= 'Whole query: ' . $query."nnr";
40                return $message;
41            }else{
42                $message  = "Import successfully completed!";
43
44            }
45
46    }
47    mysqli_close($link);
48    return $message;
49
50}