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) :)


-M
_______________________________________________
New York PHP Users Group Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk

http://www.nyphp.org/Show-Participation

Reply via email to