PHP MySQL WHERE Clause. Free online PHP and MySQL Web Database Programming Tutorial...

We use the WHERE clause in different MySQL statements to filter records. Its use in the SELECT, UPDATE and DELETE statements is very common. In other words, the WHERE clause is used to extract only those records that fulfill a specified criterion. Its syntax follows:

SELECT column_name(s)
FROM table_name
WHERE column_name operator value

We use the mysql_query() function in PHP to execute the above statements. Let's see an example:

Example
The following example selects all rows from the "Students" table where "Name='Ibrahim':

<?php
$con = mysql_connect("localhost", "adam" ,"ada");
if (!$con)
{
die('Error connecting database');
}
mysql_select_db("my_db", $con);
$result = mysql_query("SELECT * FROM Students
WHERE name='Ibrahim'");
while($row = mysql_fetch_array($result))
{
echo $row['name'] ;
echo "<br />";
}
?>

Next: PHP MySQL Order By Keyword