Hi, I am trying to build a asset tracking application with Mysql. I have selected all from the tables but how can I loop through the columns? Func Search() Local $sql = Connect() $string = "select * from assets" $i = _Query($sql, $string) With $i $a = .Fields("asset_no").value MsgBox(0, "test", $a) EndWith Will I have to use multiple with statements and assign them to each variable or is their a easier way to loop through them all?