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?