Okay I have a mysql database (of course.. ) and when I run the 'update' command it doesn't seem to actually do it. It doesn't come back with any errors either.
Here is my code... its ASP btw.
The red line is the sql query i'm talking about. So what am I doing wrong?
set checkedIn = lpSQL.Execute("select * from CheckIn where picked='0';")
If checkedIn.EOF then
Do while not checkedIn.EOF
Final=Int((x - 1 + 1) * Rnd + 1)
If not Guests(Final)="" then exit do
lpSQL.Execute("UPDATE CheckIn SET picked=1 WHERE Name=' & Guests(Final) & ';")