*************

SQL code: Upload Copy Format Clear

CREATE TABLE Faction ( factionID int , population int , name varchar(25) , PRIMARY KEY (factionID) ); CREATE TABLE Skill ( skillName varchar(25) , ability varchar(25) , PRIMARY KEY (skillName) ); CREATE TABLE CharacterN ( characterID int , characterName varchar(25) , factionID int , PRIMARY KEY ( characterID ) , FOREIGN KEY (factionID) REFERENCES Faction(factionID) ); INSERT INTO Faction ( factionID , population , name) VALUES (1, 5000, "Faction 1"), (2, 6000, "Faction 2"), (3, 4000, "Faction 3"); INSERT INTO CharacterN ( characterID , characterName , factionID ) VALUES (1, "CHARACTER-1", 1), (2, "CHARACTER-2", 1), (3, "CHARACTER-3", 2); CREATE TABLE Settlement ( population int , settlementName varchar(25) , factionID int , PRIMARY KEY (settlementName), FOREIGN KEY (factionID) REFERENCES Faction(factionID) ); INSERT INTO Settlement ( population , settlementName , factionID ) VALUES (1000 , "Settlement 1" , 1), (5000 , "Settlement 2" , 1), (2000 , "Settlement 3" , 2), (4000 , "Settlement 4" , 2);

SQL Server: Preserve result

Result: Copy Clear

PHP code: Copy Format Clear

<?php use Carbon\Carbon; $now = Carbon::now()->format('d/m/Y'); printf("Today is %s\nCurrent PHP version: %s \n\n", $now, phpversion()); $query = "SELECT VERSION() as version;"; // get DB version using PDO $stmt = $pdo->prepare($query); $stmt->execute(); $row = $stmt->fetch(PDO::FETCH_ASSOC); printf('DB version (PDO): %s ' . PHP_EOL, $row['version']); // Run query using mysqli $result = $mysqli->query($query); $version = $result->fetch_object(); printf('DB version (mysqli): %s ' . PHP_EOL, $version->version); // Run query using mysqli $havingClause = "Having total >"; $val = 2; $havingClause.=" ".$val; echo $havingClause; // $query2 = "SELECT factionID, COUNT(*) as total FROM CharacterN GROUP BY factionID HAVING total > 1;"; $query2 = "SELECT * FROM (SELECT COUNT(*) AS total, factionID FROM Character GROUP BY factionID) a ORDER BY a.total DESC;" $result = $mysqli->query($query2); echo "<table>"; echo "<tr><th>FactionID</th><th>Character Count</th></tr>"; $success = 0; while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { echo "".$row; echo "Hello"; $factionID = $row['factionID']; $total = $row['total']; echo "".$factionID; echo "<tr><td>".$factionID."</td><td>".$total."</td></tr>"; } echo "</table>";

PHP version:

Show: Warnings Notice

Result: Copy Clear

PHPize Online / SQLize Online / SQLtest Online