I have a column in my profileTable called "Associations"... I am trying to query profiles relative to the associations. 

```
$sql = mysqli_query($con,"SELECT * FROM profileTable  WHERE  Keyword_ID LIKE
'%".$getKeyID."%' ORDER BY  Associations <> 'School of Engineering 
and Computer Science', Associations AND LaName ASC LIMIT $start,$end");

```

I am able to index profiles by education but not by Association. 

```
    while ($row = mysqli_fetch_array($sql)) {
        $key = $row['Keyword_Name'];
        $keyID = $row['Keyword_ID'];
        $fname = $row['FirName'];
        $lname = $row['LaName'];
        $mname = $row['MName'];
        $suffix = $row['Suffix'];
        $title = $row['Title'];
        $title2 = $row['Title2'];
        $title3 = $row['Title3'];
        $education = $row['Education'];
        $education2 = $row['Education2'];
        $education3 = $row['Education3'];
        $dept = $row['Dept'];
        $phone1 = $row['PH1'];
        $phone2 = $row['PH2'];
        $email = $row['Email'];
        $photo = $row['Photo'];
        $bio = $row['BioLK'];
        $website = $row['Website'];
        $assocs = $row['Associations'];

$actions=array('School of Engineering and Computer Science'=>'Computer Science 
       and Engineering');

```

I need to relate the Associations with the $key(word) so if a user clicks on a keyword "Computers" it will relate to "School of Engineering and Computer Science" and index those in the "School of Engineering and Computer Science" first. 

This works fine with other columns like "Education" but can't seem to get it to work with my associative array. Any ideas?

example sqlfiddle: <http://sqlfiddle.com/#!2/c1802/7/0>