What’s the best way to avoid problems when one of the four JOINed tables is empty. The page renders fine until I add the fourth table. The only reason I can think of is due to that table being empty.
What I’m trying to do is this:
Each form, once filled out, will be stored in the database. I want a status button that will change from a TODO state to a COMPLETED state.
I was thinking that I could use the ID in each table row of that new record to trigger the HIDE / SHOW for that particular button.
The initial table (starts the process), once it is filled out, that records ID is passed on to the next table as a FK. I am trying to use the initial table’s ID as a JOIN for all other attached tables.
Everything works fine until I JOIN a table that has no data. At which time the complete page renders as a blank page.
There may be another way to do this, but I have ran into a dead-end street.
Any resolutions or comments would be very appreciated. Thanks!
Last updated: