franzwarning

Hi there, Say I have some table, foo, and I want to select all rows in foo where 'name' is a member of an array of names that I have. How would I go about doing that? Cheers, George

Hi, What's the best way I can organize my database to keep track of which users like certain photos. Should I just create a new table called "Likes" and store the user_id along with the photo_id? Or is there a more efficient way? Thanks, George

Alright, you've convinced me. Cheers, Raymond

I feel like that's less efficient though. I have a table called groups, where each row contains a group id, and all the member of that group in a BLOB.

After doing some research, I think I can do it like this: <?php $result = ibase_query("SELECT blob_value FROM table"); $data = ibase_fetch_object($result); $blob_data = ibase_blob_info($data->BLOB_VALUE); $blob_hndl = ibase_blob_open($data->BLOB_VALUE); echo ibase_blob_get($blob_hndl, $blob_data[0]); ?> But what is ibase? Is it like mysql_query but for BLOBS?

I plan on storing multiple user_id's in binary format, assuming each id is an int (4 bytes).

Hi there, How could I get the value of every 4 bytes of a BLOB? Additionally, how can I add an item to the end of a BLOB and store it back in the database? Cheers, George