This topic is locked
[SOLVED]

Contact database in v11 crashed if I try to enable a hide user feature

1/31/2025 12:47:40 PM
PHPRunner General questions
W
wfcentral author

The project is much more complex than listed below, but this is the part that is failing.

I just want to know if I'm trying to do something stupid and if there is another way around it.

Imagine a project with a table called "users" and in that table you have
id, name, email, password, phone, hidden

So, I use that table for logging in to the project so people can see and search the user table.

Since I (admin) don't want people to see my account I check a box that says "hidden"

I change the query to only pull where "hidden <> 1"

This causes the phprunner build to crash. I'm guessing you cannot exclude the record that is logging in with the query.

So, how can this be done to hide people if they check "hide my account"

W
wfcentral author 1/31/2025

solved it - in case anyone else is trying same thing.

I created a VIEW of the user table and put the query "hidden <> 1" on that