PHP mySQL data select

xiong_ster123 · 02-25-2013, 09:02 AM

Hi, I have an odd situation. I have table "locked". Here is my data.

Code:

+--------+----------+
|username| locked   |
+--------+----------+
| admin  | yes      |
| guest  | no       |
+--------+----------+

I want to select it and insert it on page load. So the next person who loads page, I want it to do this.

Code:

+--------+----------+
|username| locked   |
+--------+----------+
| admin  | yes      |
| guest  | no       |
| test   | no       |
+--------+----------+

But if I'm using admin. I don't want a duplicate row. Instead I want it to just be selected or print nothing.

Is there a possible way for this?

EDIT: Never mind. I fixed it.