09.07.2018, 20:42
A table has 5 columns: a, b, c, d, e
If you do:
row indexes 0, 1, 2, 3, 4 are reserved to * (all, five of them)
row index 6 is login_date
If you do not remember what column is first, what is second and so on, you can retrieve by its name. Make sure the datatype is correct. This means, if column is VARCHAR you cannot use cache_get_value_int to retrieve it as integer.
100 columns in vehicles table? way too many. Optimize database structure as well.
For more information, you will need to post the code you load the data with these queries.
If you do:
pawn Код:
SELECT *, DATE_FORMAT(...) as login_date ...
row index 6 is login_date
If you do not remember what column is first, what is second and so on, you can retrieve by its name. Make sure the datatype is correct. This means, if column is VARCHAR you cannot use cache_get_value_int to retrieve it as integer.
100 columns in vehicles table? way too many. Optimize database structure as well.
For more information, you will need to post the code you load the data with these queries.