MySql Where Clause

How To use a WHERE clause

The code below prints out our APCS table for all rows whose id is greater than 5

	<?php 
	 $selectTable = "SELECT * FROM apcs WHERE id > 5";
 $selectEntireTable= mysql_query($selectTable ) or die(mysql_error());

while($rowFromTable = mysql_fetch_array($selectEntireTable) )
	{
	echo $rowFromTable['firstName'] . '  '. $rowFromTable['lastName'] . ": age =" . $rowFromTable['age']  .
	', grade = ' .$rowFromTable['gradeLevel'] . ', unique id = ' . $rowFromTable['id'] .
	'
';
	} 
?>

Compound WHERE clause

You can also have compound conditions in a WHERE clause.

$selectTable = "SELECT * FROM apcs WHERE id > 5 AND gradeLevel < 12";
$selectEntireTable= mysql_query($selectTable ) or die(mysql_error());
while($rowFromTable = mysql_fetch_array($selectEntireTable) )
	{
	echo $rowFromTable['firstName'] . '  '. $rowFromTable['lastName'] . ": age =" . $rowFromTable['age']  .
	', grade = ' .$rowFromTable['gradeLevel'] . ', unique id = ' . $rowFromTable['id'] .
	'
';
	}