Getting Part of a Player's name from MySQL
#1

How would I do this:

say I type in /findnumber Grant

It gives me a list (according to the database) of everyone that has the firstname or part of their name "Grant" And displays the number?
Reply
#2

Is your first name and last name separated into columns or is it in one column?
Reply
#3

One column.
Reply
#4

Quote:
Originally Posted by Dokins
Посмотреть сообщение
One column.
Then you have to split it with sscanf as _ as the delimiter.
Reply
#5

Hi, I think you will need to use a query designed like:

pawn Код:
SELECT username FROM Accounts WHERE username LIKE '%s'
And then for each row, grab the username and display it, either in a dialog, or client messages.
Reply
#6

Quote:
Originally Posted by T0pAz
Посмотреть сообщение
Then you have to split it with sscanf as _ as the delimiter.
Could you give me an example?
Reply
#7

Yeah, i need it too
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)