Newbie problem with SQL and arrays

[Anon]

Ok, I´m starting to feel like a total newbie over here. I have this extremely simple piece of code:

$sql2 = "SELECT kingdom FROM targetfinder_allies WHERE type = 'Warriors'";
$result2 = mysql_db_query("warriors","$sql2");
$warriors=mysql_fetch_array($result2);
foreach($warriors as $warriors2) {
echo $warriors2;
}

Now there is one row in the database where type is Warriors, thus $warriors2 should be echoed once in my opinion, but it´s echoed out two time with the same (correct) value.

I must have missed something really simple since I´m not that used to use foreach. Any help ?

[Anon]

Your foreach is echo'n twice because when mysql_fetch_array creates the array it is from one row, but it is doing to ways:
$warriors[0];
$warriors["colname"]

So your foreach is echoing both.

If you are just trying to loop through the database and echo each value once, try something like this:
$sql2 = "SELECT kingdom FROM targetfinder_allies WHERE type = 'Warriors'";
$result2 = mysql_db_query("warriors","$sql2");

while($row = mysql_fetch_array($result2))
{
echo $row["kindom"];
}