PHP [symfony] query over multiple tables

[Tealk]

I am trying to read out the worst global and worst group status from a table, unfortunately I have no idea how to handle this.

I have a table service_group which has a OneToMany connection to the table service. The service table has a ManyToMany connection to the status table.
The status is given by an ID 0 = good and 3 = the worst.

It is also important that it is only the most recent status of a service, because each service has several entries in the past.

Code: https://codeberg.org/RollenspielMonster/server-status-page

 

[simong1993]

i mean this has flown over my head BUT if im reading right are we talking about a MySQL lock?

 

[Tealk]

MySQL lock?

why exactly would i want to lock mysql?

it is about how to map this "complicated" query. i have to have the whole thing in php as a variable or function so i can display it in the template.

 

[simong1993]

You dont want to lock it but they lock them selfs 😀 its a annoying part of SQL where if 2 things are on the database they can cause each other to lock 🙂 Im porbably now much help then in that case 😀