show count row with same id in another mysql table

saee2838

i want show in one column , count of row with same id in another mysql tabel.
how i can do it
is any example for it?

allan

If you are using the Editor libraries to populate the table, you can use an Mjoin and then just use the length of the resulting array.

If you aren't using our libraries, you'd need to modify whatever SQL query you are using to get the data - a CTE might be required, but it depends on the database you are using.

Allan