20.04.2010, 09:21
pawn Код:
new HighestNumber[ 12 ], HighestNumberInt;
mysql_query( "SELECT * FROM Users WHERE PhoneNumber = ( SELECT MAX( PhoneNumber ) FROM Users );" ); // Query for the result.
mysql_store_result(); // Store the result in memory
mysql_fetch_row_data(); // Fetch row data of the result
mysql_fetch_field( "PhoneNumber", HighestNumber ); // Fetch specific field
HighestNumberInt = strval( HighestNumber ); // This should be your highest number.
mysql_free_result(); // Free the result to avoid using excessive memory