open($sql); $rs = $conn->execute("SELECT * FROM TableName"); while (!$rs->EOF) { echo $rs->Fields['FieldID']->Value ; echo $rs->Fields['FieldName']->Value ; $rs->MoveNext() ; } $rs->Close() ; $conn->Close() ; ?>