Select where not equal to multiple values of keys of associative array

Question

I had made three tables.

Table1=users.And the column names are userid (auto_increment) and username.
Table2=hobbies. column names are hobbyid (auto_increment) and hobbyname.
Table3=users_hobbies. column names are FK_userid and FK_hobbyid.

Now hobbyname has cricket,football,volleyball.
During sign-up user selects only cricket and football and I store it in $_SESSION['hobby_id'] associative array.

But in profile he/she wants to add some more hobbies.

So I want to display list of hobbies which are not equal to $_SESSION['hobby_id'].

This , ofcourse didn't work:

foreach($_SESSION['hobby_id'] as $k=>$v)
{

  $query="select hobbyid,hobbyname from hobbies where hobbyid!= $v";
}  
Output was football,volleyball and cricket,volleyball....but i wanted only volleyball

So i want that

$query="select hobbyid,hobbyname from hobbies where hobbyid!=(multiple values of session hobby id)";

What code will I have to enter to get desired result(only volleyball)?

rabudde · Accepted Answer · 2012-06-26 06:24:05Z

2

remove foreachloop and use NOT IN comparision in MySQL:

$query="
    SELECT hobbyid,hobbyname
    FROM hobbies
    WHERE hobbyid NOT IN (" . implode(',', $_SESSION['hobby_id']) . ")
";

answered Jun 26, 2012 at 6:24

rabudde

7,7826 gold badges58 silver badges95 bronze badges

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

2 Comments

Santosh Over a year ago

worked like a charm!.. there was problem when the $_SESSION['hobby_id'] was empty but i solved it by using simple if(empty($_SESSION['hobby_id']))...... thanks

rabudde Over a year ago

Sure you have to check if variable is not empty, I give you only the final query. But you have to ensure, that $_SESSION['hobby_id'] contains only numeric values (in fact of SQL injection)

Collectives™ on Stack Overflow

Select where not equal to multiple values of keys of associative array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related