serialize / unserialize working with mysql

[matthewlesh]

I am currently working on something where i put a serialized array into mysql database.

 

I am putting in a numbers which correspond to id nums from another table.

 

Before without allowing for multiple selections it looked something like...

 

mysql_query("SELECT rm.*, sc.* FROM menu_items as rm, pages as sc WHERE rm.section='$id' AND sc.id='$id'");

 

But now so basically i want to be able to select what menu items are used for what page without doing a wide query then looping through hundreds of records.

 

I was wondering how i would go about doing it the simplest way?

 

(By the way it has to be in a serialize format...)

 

Thanks for any help

 

Let me know if you don't get what i mean .