i want to check 3 columns in the same row for values. My columns are
|column1| column2 |column3 |
|-------|----------|--------|
| row1 | row2 | row3 |
I want to check if row1 has value, if it doesn't then i want to insert into it, same as row2 if it doesn't have value i want to insert into it and same as row 3. The goal is that when a user registers we give 3 gifts to them. so when you register row1, row2 and row3 are null, i want to insert into them according to ASCENDING ORDER in the database.
For example: if row1 is empty then it should update it from being empty to a toy or a baloon and then for the two other rows, but if the second row has a value then it should go for the third row, if the third has a value then it should go to the next line
via OG Paul Caleb