Collecting more than one record from table

$sql="select state from table_name WHERE state='USA'";

echo "<table>";
foreach ($dbo->query($sql) as $row) {
echo "<tr ><td>$row[state]</td></tr>";
}
echo "</table>";

$i=1;
echo "<table class='t1'>";
foreach ($dbo->query($sql) as $row) {$m=$i%2;
echo "<tr class='r$m'><td>$row[state]</td></tr>";
$i=$i+1;}
echo "</table>";

PHP MySQL PDO script
PDO PHP installation and phpinfo PDO PHP connection string for MySQL database Collecting single record by using PDO fetch from MySQL database Inserting record to MySQL table by using PHP PDO Updating records using PDO to MySQL table Deleting records using PDO to MySQL table Number of rows changed or updated or inserted by using rowcount function in PDO