quick mysql question
quick mysql question
- Started
- Last post
- 3 Responses
- foreign
hi, anyone around that can help me?
i'm working on a competition entry form...
entrants get a chance to refer friends - if a friend signs up, the referrer gets another entry for the competition draw.
is there a quick way to duplicate a row in a table, or should i select the row data, and create another insert? seems tedious.
- moth0
I would just add in another field called "referrer" and set it to 0. When they refer someone, have it look up the referrer and set the 0 to 1.
- moth0
Then use that 1 at some point to give them a second shot... somehow.
- foreign0
thanks moth, i wasn't thinking along those lines.
cheers.