Consulta para seleccionar elementos de un Tipo de Contenido
Consulta Estática
Devuelve todos los campos de la consulta
$result = db_query("SELECT * FROM {node} WHERE type = :type", array(
':type' => 'article',
));
if ($result) {
while ($row = $result->fetchAssoc()) {
print_r($row);
}
}
Los campos que devuelve la consulta son los sigueientes:
Array ( [nid] => 51 [vid] => 51 [type] => slider [language] => es [title] => Slider 01 [uid] => 1 [status] => 0 [created] => 1450642829 [changed] => 1450643815 [comment] => 0 [promote] => 0 [sticky] => 0 [tnid] => 0 [translate] => 0 )