Store query result in an Object
<?php
mysql_connect("mysql153.secureserver.net","java2s","password");
mysql_select_db("java2s");
$query = "SELECT id, firstName FROM Employee";
$result = mysql_query($query);
while ($row = mysql_fetch_object($result)) {
$name = $row->firstName;
$id = $row->id;
echo "Product: $name ($id) <br />";
}
?>
Related examples in the same category