Problem with storing database queries values in array

Question

I have a simple table with four field email,title,url & status

status can be '0' or '1'

There can be multiple values with status '1'. I want to store the all datas from the table with status '1' in array so i can output it later.

$values = db_query('select email,title,url from {example_table} where status= :one', array(':one' => '1'))->fetchAssoc();

The above array only stores one record in $values array.

Clive · Accepted Answer · 2013-11-30 11:44:31Z

up vote 3 down vote accepted

fetchAssoc() is only supposed to return a single result.

Returns the result set as an associative array keyed by the given field.

answered Nov 30 '13 at 11:44

Clive♦
101k7125187

add a comment |

1 Answer 1