TalkPHP - View Single Post

Tanax · 10-07-2007, 04:39 PM

Okey, I got another issue regarding this script.

The server doesn't store the actual NAME of the vocation in the database, they store it as an integrer: 1 beeing knight for example, 2 sorcerer, 3 druid and 4 paladin. And if I just print the value from the row vocation, it prints 1 to 4. However, that's not a problem to fix.

PHP Code:


			
if($vocation == 1) {
echo 'knight';
}
elseif(....)

However, I want them to be able to SEARCH for vocations, so that if they type in paladin, the script search the database for everyone with vocation value of 4, get the idea?

How would I achieve this the best way possible?

10-07-2007, 04:39 PM	#13 (permalink)
Tanax The Prestige Join Date: Sep 2007 Location: Sweden, Stockholm Posts: 1,080 Thanks: 115	Okey, I got another issue regarding this script. The server doesn't store the actual NAME of the vocation in the database, they store it as an integrer: 1 beeing knight for example, 2 sorcerer, 3 druid and 4 paladin. And if I just print the value from the row vocation, it prints 1 to 4. However, that's not a problem to fix. PHP Code: `if($vocation == 1) { echo 'knight'; } elseif(....)` However, I want them to be able to SEARCH for vocations, so that if they type in paladin, the script search the database for everyone with vocation value of 4, get the idea? How would I achieve this the best way possible?