if statements

CONTEMAN

Vocation:
<?php if ($row['vocation']="1")
			echo " Sorcerer";
?>
<?php if ($row['vocation']="2")
			echo " Druid";
?>
<?php if ($row['vocation']="3")
			echo " Paladin";
?>
<?php if ($row['vocation']="4")
			echo " Knight";
?>

this creates:

Vocation: Sorcerer Druid Paladin Knight

Piranha

This defenetley doesn't belong to the database forum. As the headline says it is an if-statement, and it belongs in newbie or possibly coding.

Also, in the future please give a little more information.

In this case I can help you out anyway. When you want to compare variables you should use == and not =

If you do as you did the variable will be set to "1" and go into the if-statement. Then it will be set to "2" and go into the second if-statement.

Sxooter

But it is a good example of something that should probably be in your database. There are several ways to handle such data in the database.

select 
  case 
    when row=1 then 'Sorcerer'
    when row=2 then 'Druid'
    when row=3 then 'Paladin'
    when row=4 then 'Knight'
  end as char_class
from ...

That way doesn't store the char_class value in the db.

There's

smarlowe=# create table char_class (id int primary key, nam text);
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "char_class_pkey" for table "char_class"
CREATE TABLE
smarlowe=# insert into char_class values (1,'Sorcerer'), (2,'Druid'), (3,'Paladin'), (4,'Knight');
smarlowe=# create table chars (id int primary key, nam text, cclass int references char_class(id));
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "chars_pkey" for table "chars"
CREATE TABLE
smarlowe=# insert into chars values (1,'joe',1);
INSERT 0 1
smarlowe=# insert into chars values (2,'sally',2);
INSERT 0 1
smarlowe=# insert into chars values (3,'sam',4);
INSERT 0 1
smarlowe=# insert into chars values (4,'frank',3);
INSERT 0 1
smarlowe=# select c.nam as username, cc.nam as charclass from chars c join char_class cc on (c.cclass=cc.id);
 username | charclass 
----------+-----------
 joe      | Sorcerer
 sally    | Druid
 sam      | Knight
 frank    | Paladin
(4 rows)

This was stores the class in the db and references it for the user.

Sxooter

Oh yeah, there's enum as well.

postgres=# create type cclass as enum ('Sorcerer','Druid','Knight','Paladin'); 
CREATE TYPE
postgres=# create table chars (id int primary key, nam text, class cclass);
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "chars_pkey" for table "chars"
CREATE TABLE
postgres=# insert into chars values (1,'stan','Paladin');
INSERT 0 1
[\code]

and so on.

CONTEMAN

Sxooter wrote:
But it is a good example of something that should probably be in your database. There are several ways to handle such data in the database.
select 
  case 
    when row=1 then 'Sorcerer'
    when row=2 then 'Druid'
    when row=3 then 'Paladin'
    when row=4 then 'Knight'
  end as char_class
from ...
That way doesn't store the char_class value in the db.

what format do i use where u put "from ..."?