ordering from another table
Posted: Fri Nov 07, 2008 12:09 pm
Hi
i have offers table that contain a field as the user_id
and member table with the field "membertype" ( 1 , 2 or 3 )
I want to list the offers ordered by user type (gold type's offers are shown first)
solutions:
1. adding the membertype field to offer table when posting an offer
etc.
do you think this is the best (easiest and fastest) way?
thanks for your notes
i have offers table that contain a field as the user_id
and member table with the field "membertype" ( 1 , 2 or 3 )
I want to list the offers ordered by user type (gold type's offers are shown first)
solutions:
1. adding the membertype field to offer table when posting an offer
etc.
do you think this is the best (easiest and fastest) way?
thanks for your notes