MySQL - Extract Column Data

[MLambert]

Hi,

Using the select statement "Select PostCode from Database .....

In QB64 can I use the name PostCode to obtain the post code information or do I have to use DB_RESULT(columns, rows) to obtain the post code information ?

Currently no value is being passed back to the program if I just reference the SQL column name.

I am using the Wiki MySQL code.

By the way the wiki example code is missing the "dim share rows" and "dim share columns"  reference to rows and columns . Without this the return values is always 0 for both fields from the function call DB_QUERY.

Mike

[Juanjogomez]

Hi,
If you use "SELECT PostCode FROM Database...." the result will be the rows you have, and a single column, because you are only selecting that data.
The result will always be saved in DB_RESULT (1, n) where 'n' are the rows that match the WHERE you entered in the query.

[MLambert]

Thank you
Mike