Matt Juszczak wrote: >>> SELECT some_attribute FROM some_rel WHERE user_id=X AND account_id=Y > > Yes, but this can return multiple rows. What if you only want to return > one row? You don't necessarilly *need* a new auto_increment, and in > fact, it probably isn't necessary, but you should make sure there's an > inde on (user_id,account_id) :)
That's what the primary key is for ;) Dan _______________________________________________ New York PHP Users Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/Show-Participation
