I have a database table with the following fields: name, company_name, geo_loction. I want to get those fields using the following query.
$zip_code = db_query("SELECT * FROM data_set WHERE id = 1", array(":city" => $city))->fetchObject();
Is that the correct code? How do I show the result?