How to Pick and Choose Information from a MySQL Database
With the WHERE clause, you can sort records.
With the WHERE clause, you can pull out only the records that meet a certain condition.
SELECT columnname(s) FROM tablename WHERE columnname operator value
Visit our SQL tutorial to learn more about SQL.
MySQL lets you choose and sort data.
The next example chooses the id, firstname, and lastname columns from the student table where the lastname is \”lal\” and puts them on the page:
Example:
<!DOCTYPE html>
<html>
<body><?php
$servername = \”localhost\”;
$username = \”username\”;
$password = \”password\”;
$dbname = \”school\”;// Create connection
$link = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$link) {
die(\”Connection failed: \” . mysqli_connect_error());
}$sql = \”SELECT id, firstname, lastname FROM student WHERE lastname=\’lal\’\”;
$result = mysqli_query($link, $sql);if (mysqli_num_rows($result) > 0) {
// output data of each row
while($row = mysqli_fetch_assoc($result)) {
echo \”id: \” . $row[\”id\”]. \” – Name: \” . $row[\”firstname\”]. \” \” . $row[\”lastname\”]. \”<br>\”;
}
} else {
echo \”0 results\”;
}mysqli_close($link);
?></body>
</html>
Output
id: 1 – Name: ram lal