[MySQL]Need help about PhoneNumber!
#9

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
I know it's not optimal, but I rushed it and the query could probably be executed better. Some functions may be different, depending on which plugin you use. I use StrickenKid's and I've used it for this example.
Reply


Messages In This Thread
[MySQL]Need help about PhoneNumber! - by Eliran Pesahov - 19.04.2010, 14:02
Re: [MySQL]Need help about PhoneNumber! - by Eliran Pesahov - 20.04.2010, 05:45
Re: [MySQL]Need help about PhoneNumber! - by Calgon - 20.04.2010, 05:48
Re: [MySQL]Need help about PhoneNumber! - by Eliran Pesahov - 20.04.2010, 07:58
Re: [MySQL]Need help about PhoneNumber! - by Calgon - 20.04.2010, 08:13
Re: [MySQL]Need help about PhoneNumber! - by Eliran Pesahov - 20.04.2010, 08:52
Re: [MySQL]Need help about PhoneNumber! - by DarrenReeder - 20.04.2010, 08:54
Re: [MySQL]Need help about PhoneNumber! - by Eliran Pesahov - 20.04.2010, 09:09
Re: [MySQL]Need help about PhoneNumber! - by Calgon - 20.04.2010, 09:21

Forum Jump:


Users browsing this thread: 1 Guest(s)