I need help to modify this code:

Purpose: This program lists the first and last names of all sales employees. Modify this so that, instead of using a loop to display the names, the program simply displays a paragraph that reports the number of sales staff, for example "There are 4 sales staff". Use a MySQL function to obtain the number of sales staff.

Hint: There are two different MySQL functions that you can use here: you can modify the SELECT statement to use a MySQL aggregation function, or you can use the MySQL function that returns the number of records in the result set.

Modify 5

Modify 5

$server = "localhost"; $user = "wbip"; $pw = "wbip123"; $db = "test";

$connect=mysqli_connect($server, $user, $pw, $db);

if( !$connect) { die("ERROR: Cannot connect to database $db on server $server using user name $user (".mysqli_connect_errno(). ", ".mysqli_connect_error().")"); } else { $userQuery = "SELECT firstName, lastName FROM personnel WHERE jobTitle='sales' "; $result = mysqli_query($connect, $userQuery);

if (!$result) { die("Could not successfully run query ($userQuery) from $db: " . mysqli_error($connect) ); }

if (mysqli_num_rows($result) == 0) { print("No records found with query $userQuery"); } else { print("

SALES STAFF REPORT

"); while ($row = mysqli_fetch_assoc($result)) { print ( "

".$row['firstName']." ".$row['lastName']."

"); }

} mysqli_close($connect); // close the connection } ?>