Where I would run a query like below and the results is only 1 row how would I access the the individual data fields
SELECT state, batch FROM stock WHERE serialnum = '444'
state, batch
1 , 003
I have only seen examples where the code is while looped and printf'ed