I think this is more of a .NET related problem than a MySQL problem. The error says it can't load the required assembly, you might have more look on the .NET board

Quote

correct, I was doing that on my tablet, and didn't notice it had auto-corrected to that.

Hi again, I've just found this article which is related to your question.

It basically uses the method you were attempting, and which I now believe to be a better method (contrary to my last comment), especially for high usage, multi user systems.

Hi

Just to be clear, you want to return the last 20 messages in a conversation between 2 users?

If so you're just missing a few SQL constructs, I think this should work:

SELECT *
FROM member_messages
WHERE
(
(
message_from = userid
AND
message_to = friendid
)
OR
(
message_from = friendid
AND
message_to = usetid
)
)
AND message_I'd <= upperid
ORDER BY message_I'd DESC
LIMIT 20

This will gather messages from user A to user B or user B to user A, where the message is is less than the specified upperid, order them by the message is (highest and therefore latest first) and then take only the first (or because of the sorting latest) 20.

Also if you're trying to implement some sort of paging here the LIMIT construct can take 2 parameters, when you pass 2 parameters the first is how many rows to skip and the second is how many to take so LIMIT 0 20 will skip 0 and take 20 (I.e. the first 20)

Hi guys

I think the best way to achieve this is by setting the

ON DELETE

option on the foreign key constraint to

CASCADE

.

This will automatically delete all the referencing rows when the parent row is deleted - no need for extra programming or triggers