Fetching text field from the node
In general to get the value of field if the entity type is a node

$node = node_load($nid);
echo $node-&gt;field_image_url['und'][0]['value'];


or try to print the $node to figure out how to get it

echo '&lt;pre&gt;'; var_dump($node); var_dump($node-&gt;field_image_url); die;


in your situation try the next to figure out what is happen there

&lt;?php
$node_type = "slider_image";
$sql = db_query("SELECT nid FROM node WHERE type = $node_type");
$results = db_query($sql);
foreach($results as $row){
   $node = node_load($row-&gt;nid);
   echo $node-&gt;field_image_url['und'][0]['value'];
   echo '&lt;br&gt;';  
}
?&gt;