I realize this is a very old topic, but whenever I go to parse through my MySQL DB any text because a number - not the text..
;****************************************
; Get all Non-Active Articles
;****************************************
If Not _EzMYSql_Query('SELECT * FROM rars_articles WHERE IsActive = 1;') Then
MsgBox(0, 'Query Error', 'Error: ' & @error & @CR & 'Error string: ' & _EzMySql_ErrMsg())
Exit
Else
For $i = 1 To _EzMySql_Rows() Step 1
$a1Row = _EzMySql_FetchData()
MsgBox (0, "ID ", $a1Row[0] + 0)
MsgBox (0, "Date", $a1Row[1] + 0)
MsgBox (0, "Section", $a1Row[2] + 0)
MsgBox (0, "Title", $a1Row[3] + 0)
MsgBox (0, "Author", $a1Row[4] + 0)
;_ArrayDisplay($a1Row, "Result: " & $i)
Next
EndIf
Where this should return a Text return for "Section", "Title", and "Author" it is returning 0 for each of those rows. Yet _ArrayDisplay displays them correctly:
What am I doing wrong, please?