SELECT * 
FROM COMPANY, AGENDA 
WHERE COMPANY.COMPANY_ID = AGENDA.COMPANY_ID

Hello Andrej,

What do you need in order to do that ? Pure SQL or PHP code ? And what RDBMS are you using ?

In theory, the difficult part is getting this recordset from the database, that can be done quite easily with a simple joined query between the two tables through the COMPANY_ID common field (Primary key on the first table, Foreign key on the other one).

Something like that should do it :

[sql]SELECT *
FROM COMPANY, AGENDA
WHERE COMPANY.COMPANY_ID = AGENDA.COMPANY_ID[/sql]

The php part is pretty straightforward really, and you can find good examples of it on any decent PHP resource available on the web, including the must-read php manual : http://php.net/mysql_query . (We could link you to several good resources to learn from though, but they'd all be written in french !).

Hope this helps. Please consider [url=http://www.youtube.com/watch?v=pfUmW_Mf5qc]learning french[/url] if you intend to post on this forum in the future, if you want to take full advantage of it.

Hello.

Welcome to PHPFrance's forums.
I must warn you that we are a french forum, and you may not have many answers to an english question, and you can certainly find more appropriate english forums on the net.

Wishing you good luck.

Helo
I have two table:
COMPANY and AGENDA
[b]Example Tbl COMPANY[/b]
COMPANY_ID
RAISONSOCIALE
[b]Tbl AGENDA[/b]
AGENDA_ID
COMPANY_ID
Date_evenement
Titre

So I want display repeat region sommething like this:
---------------------------------------------------------------------------------------------
[b]RAISONSOCIALE , Company_id 1[/b]
Agenda.Date, Agenda.titre ( all records by company_id 1 )
[b]RAISONSOCIALE , Company_id 2[/b]
Agenda.Date, Agenda.titre ( all records by company_id 2 )

Thanks in advance

Andrej