User #thisuser_ID#
Performances selected #performance_ID#
Select LYDIA seat:

select * from tix where performance_ID=#val(performance_ID)# insert into seasontix (seat) values ('#seat_lydia#') select seat from seasontix select * from tix where performance_ID=#ListGetAt(performance_ID, i, ",")# TIX_SOLD="#TIX_SOLD#"

select * from seasontix Seats selected: #getseats.seat#

Available

Sold

Pending

Reserved