PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE employees ( `first_name` varchar(64), `last_name` varchar(64), `email` varchar(64), `salary` int ); INSERT INTO employees values ('John', 'Connor', 'john.connor@gmail.com', 130), ('Mr', 'Black', 'mr.black@gmail.com', 310);
Copy Clear
Copy Format Clear
<?php $query = "SELECT * FROM employees ORDER BY salary DESC"; ($result = mysqli_query($mysqli, $query)) or die("Error querying database."); while ($row = mysqli_fetch_array($result)) { $first_name = $row["first_name"]; $last_name = $row["last_name"]; $salary = $row["salary"]; printf( "%s %s salary : %d " . PHP_EOL, $first_name, $last_name, $salary); } ?>
Show:  
Copy Clear