Databases
StackOverflow2013
Postsdbo
POIn CakePhp, how can I retrieve only one column from my database?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POIn CakePhp, how can I retrieve only one column from my database?
    primarykey
    data
    text
    <p>I have a very simple application with 1 table, each row contains a word, it's definition, and an example.</p> <p>The definition and example fields are varchars(5000).</p> <p>On every page, I have a sidebar which displays the list of words. After a certain number of words I started getting the following error:</p> <pre><code>Error: Allowed memory size of 33554432 bytes exhausted </code></pre> <p>The code in the controller that sets the variable used in the Element:</p> <pre><code>$this-&gt;set('allWords', $this-&gt;Word-&gt;find('all', array('order' =&gt; array('Word.text ASC')))); </code></pre> <p>I suspect that the find method reads in all the row data, including the definition and example, which I really don't need at this moment, and this causes the error.</p> <p>Is there any way to just read the id and the word, and not the definition and example values for each row?</p> <p><strong>Update</strong></p> <p>Inside my Element I loop through the $allWords array to print out each word along with a link:</p> <pre><code>echo '&lt;h3&gt;Words ('.count($allWords).')&lt;/h3&gt;'; echo $this-&gt;Html-&gt;link('Add new', array('controller' =&gt; 'words', 'action' =&gt; 'add')); echo '&lt;br/&gt;&lt;br/&gt;'; foreach($allWords as $thisWord) { echo $this-&gt;Html-&gt;link($thisWord['Word']['text'], array('controller' =&gt; 'words', 'action' =&gt; 'edit', $thisWord['Word']['id'])); if( ($thisWord['Word']['example'] == '') || ($thisWord['Word']['definition'] == '') ) { echo '&amp;nbsp;' . $this-&gt;Html-&gt;image('warning.png'); } echo '&lt;br \&gt;'; } </code></pre> <p>It appears that if I comment out the inner part of the foreach loop, I don't get the memory error.</p> <p>The SQL output in this case is:</p> <pre><code>SELECT `Word`.`id` FROM `idioms`.`words` AS `Word` WHERE 1 = 1 ORDER BY `Word`.`text` ASC` </code></pre> <p>with 339 rows affected.</p> <p>Thanks!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USSandy
    1. USSandy
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POIn CakePhp, how can I retrieve only one column from my database?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POIn CakePhp, how can I retrieve only one column from my database?
      1. This table or related slice is empty.
      1. VTUpMod
    1. CODouble check that `$this->recursive` (in your model) is set to `-1`. Eg - before your `find()` in your model, set `$this->recursive = -1;`, or if you're in your Controller: `$this->Word->recursive = -1;`.
      singulars
      1. POIn CakePhp, how can I retrieve only one column from my database?
      1. USDave
    2. COSame error! It's weird because I only have around 400 rows. It's hosted on hostdime, so it's not a noob server config error (hopefully).
      singulars
      1. POIn CakePhp, how can I retrieve only one column from my database?
      1. USSandy
    3. COEdit the question and add the actual SQL query(s) it's running. Can them directly without error?
      singulars
      1. POIn CakePhp, how can I retrieve only one column from my database?
      1. USDave
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload