Newbie question : How to specify relationship between tables ?

[eluser]Unknown[/eluser]
Hello,

Sorry to ask a so stupid question but ... :-)
I have to tables :
Country :
id
country_name

Wine :
id
wine_name
country

I want to have a drop down list when i add a new wine in my database with all the countries.

Can someone help me ?
Thanks.

Dominique.

[eluser]zdknudsen[/eluser]
This is one of the things CodeIgniter does not do for you. You'll have to do this yourself using the database library.

[eluser]Michael Wales[/eluser]
Pretty simple (not as easy as Ruby on Rails, which virtually does it automagically), but simple nonetheless. From your controller's method, make a query to select all of the country names, dump that into an array, pass it to your view, and then either use the form_dropdown() form helper or foreach() through it using your own XHTML select tag.

[eluser]Unknown[/eluser]
You are really fast to answer !
;-)

I was asking this question because i was trying just before cakephp.

Thanks for your answers. I'm going to try.

Dominique.