issues creating an array php
<p>I'm writing a PHP application, and one of the features is be able to query gene interactions in all our tables <code>(gene_r, genes_newL_dn, genes_newL_up, genes_oldL_up, genes_oldL_dn)</code>.
So I have the following <code>PHP</code> function to query all those databases at once.</p>

<pre><code>public function getAllInteractions($input){
    $data = array();

    $sql_list = (
        "SELECT * FROM genes_r JOIN drugs_r ON drugs_r.id = genes_r.id WHERE drug_name='$input' OR gene_name='$input'",
        "SELECT * FROM genes_newL_dn JOIN drugs_newL_dn ON drugs_newL_dn.id = genes_newL_dn WHERE drug_name='$input' OR gene_name='$input'",
        "SELECT * FROM genes_newL_up JOIN drugs_newL_up ON drugs_newL_up.id = genes_newL_up WHERE drug_name='$input' OR gene_name='$input'",
        "SELECT * FROM genes_oldL_dn JOIN drugs_oldL_dn ON drugs_oldL_dn.id = genes_oldL_dn WHERE drug_name='$input' OR gene_name='$input'",
        "SELECT * FROM genes_oldL_up JOIN drugs_oldL_up ON drugs_oldL_up.id = genes_oldL_up WHERE drug_name='$input' OR gene_name='$input'"
    );

    foreach($sql_list as $sql){
        $query = $this-&gt;db-&gt;query($sql);
        // case 1 : SQL Query invalid / empty results
        if(!$query || $query-&gt;num_rows() == 0) {
            continue;   
        }
        else {
            $id = $query-&gt;row()-&gt;id;
            $sql = "SELECT interaction from matrix_r WHERE id='$id'";
            $query = $this-&gt;db-&gt;query($sql);
            array_push($data, $query-&gt;row());
        }   
    }

    return $data;
}
</code></pre>

<p>However, I'm getting the following error:</p>

<pre class="lang-none prettyprint-override"><code>PHP Parse error:  syntax error, unexpected ',' in 
/chemicalgenomics/ci/application/models/search_model.php on line 81
</code></pre>

<p>I'm not getting why does not like the ','. It's supposed to be an array of strings. Could someone please help me with that?
Thanks</p>

<p>PS: <code>Line 81</code> is the first line in the array: <code>"SELECT * FROM ...</code></p>
