Problem using iSQL and variables

view story

http://www.unix.com – I have searched the forums and other sites and cannot come with the applicable approach for what I am trying to do. I am trying to setup a cron job that executes this script. The script uses iSQL - which is connecting ok - to then query a field and then assign that field to a variable to do an If statement on. I have tried various different isql statement combinations and cannot get it to work right. The data being returned is the headers and the data. I need the $server variable to equal one string such as "data1" or "data2", which is what is contained in the field fro (HowTos)