How do I show the parent's name on the table?

EricD

Hi,
My name is Eric, I do not speak English very well, but if anyone can help me please.
How do I show the parent's name on the table above?

link: doghouse.epizy.com/pets.php

Thanks

allan

You need to use a join as described here.

Allan

EricD

Hi Allan,

Thanks for the reply, i made some changes but it's not working as I expected.

doghouse.epizy.com/pets.php

I'll try other approaches with datatables later.

I can make it work without datatables using 2 sql statement separately but i wanna make it work with datatables

Thanks anyway

EricD

Hi again

Sorry, i made some mistake on left join, now i got it working as you can see

doghouse.epizy.com/pets.php

Thanks again