1. You should have posted table structure...
2. Use "... where nickname='%s';"
3. Try this (don't forget to replace column_name with name of id column in your table):
PHP Code:
if(SQL_MoreResults(Query)){
Aid = SQL_ReadResult(Query, SQL_FieldNameToNum(Query,"column_name")) //replace column_name with id column name !
log_to_file("testing.log", "Nactena data: %d; Time = %d", Aid, Time)
}else{
log_to_file("testing.log", "No data found")
}
4. If you used "select * from ..." then print all retrieved data, it makes things easier when debugging.
PHP Code:
if(SQL_MoreResults(Query)){
//...
iValue1 = SQL_ReadResult(Query,SQL_FieldNameToNum(Query,"iColumn1"))
new szValue2[32]
SQL_ReadResult(Query,SQL_FieldNameToNum(Query,"szColumn2"), szValue2, 31)
//...
log_to_file("testing.log", "iValue1: %d, szValue2: %s ....", iValue1, szValue2, ...)
}else{
log_to_file("testing.log", "No data found")
}
__________________