Monday 11 August 2014

drupal custom mysql statement

 $sql_query = db_query("select * from pms_link_master");
  echo "total rows ".$sql_query->rowCount();

    $sql_array = array();
    foreach ($sql_query as $row) {
        $reaged = (array) $row; // Standard object to array    
        $sql_array[] = $reaged;
    }
dpr($sql_array);

No comments:

Post a Comment