Drupal querying database table

Question

I am a newbie in Drupal, I have a table in a drupal database. I wanted to query all the content of it and display in a tabular format. Whenever I execute the query the link directs me to the blank page and nothing appears. I have attached the PhP code for the reference. Any help will be highly appreciated.

   <?php
  $header = array('Name', 'Age', 'Sex','University');
  $rows = array();

  $sql = 'SELECT Name, Age, Sex,University FROM {data_pulling} ORDER BY Name';
  $res = db_query($sql);
  while ($row = db_fetch_array($res)) {
    $rows[] = $row;
  }

  print theme('table', $header, $rows);
?>

a blank page usually means that you had a PHP error of some sort. — Peter Wooster
– Peter Wooster, Commented Jan 13, 2013 at 9:19
Exactly I view the PHP error it complains about this, Fatal error: Call to undefined function db_fetch_array() in /var/www/drupal/modules/php/php.module(80). Any idea ? — Mohan Timilsina
– Mohan Timilsina, Commented Jan 13, 2013 at 10:05
which version of Drupal are you using. dp_fetch_array was removed from Drupal 7 because there is a new database API. — Peter Wooster
– Peter Wooster, Commented Jan 13, 2013 at 10:40
I am using drupal 7, yes I find out recently that db_fetch_array was not there in the new API of Drupal 7. Thank you very much for your suggestion. :-) — Mohan Timilsina
– Mohan Timilsina, Commented Jan 13, 2013 at 10:51

Clive · Accepted Answer · 2013-01-13 10:35:57Z

4

At a guess you're using Drupal 7 but are trying to use API functions from Drupal 6.

Try this

foreach ($res as $row) {
  $rows[] = (array) $row;
}

print theme('table', array('rows' => $rows, 'header' => $header));

Have a look at the docs for db_query and theme_table for more information

edited Jan 13, 2013 at 10:35

answered Jan 13, 2013 at 10:30

Clive

36.9k8 gold badges89 silver badges113 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Drupal querying database table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related