DatabaseJoin Eval options Help

[jmoises]

Hello, i have a databasejoin element fill with all the countries names, i will like to add Mexico and United States as first 2 options, right know all the names are sort by name, so it take time to found the country name.

it is posible to use the Eval option to make this arrangment?

Thanks for any help.


it will be great to found a way to depending of you location automaticaly show the country but that is too much to ask maybe.

 

[cheesegrits]

Nope, can't use eval options for that.

The only way I can think of would be to add another field to your countries table, like sort_order, and add an ORDER BY to the joins's WHERE clause, like ...

1=1 AND ORDER BY sort_order ASC

-- hugh

 

[jmoises]

Nice that easy way to do it! thanks