Posted by Daz on 10/25/06 00:21

Rik wrote:
> I have told you several times an index on 2 columns is perfectly possible.
> Make the index:
> ALTER TABLE `user_books` ADD UNIQUE (
> `user_id` ,
> `book_id`
> )
>
> Voilá.

Hi Rick. Sorry, I believe that I have also mentioned several times that
I can't, as each user has one row per book, meaning there won't be any
unique uids, and if there were, it wouldn't be for very long at all.
The book_ids in the user table will also be duplicated, as more than
one user is likely to have the same book.

Thanks for your help. :)

Daz.

• Next in forum: Re: Using PHP to add a word to a txt file every X charachters
• Prev in forum: Re: PROBLEM: passing variables to FILE()
• Thread view: Re: A Question of design.

[Reply to this message]