array out of a database

[Ryflex]

Hi all,

 

This is a piece of code of my php page and what I need is that $n1 till $n4 is filled. Somehow only $n1 is filled.

Can anyone tell me what I'm doing wrong here.

 

Thnx Ryflex

 

$sql				= "SELECT name FROM unittype WHERE type = 1";
$result				= mysql_fetch_array(mysql_query($sql)) or die("Could not find units");
$n1					= $result[0];
$n2					= $result[1];
$n3					= $result[2];
$n4					= $result[3];
echo "$n1 <BR> $n2 <BR> $n3 <BR> $n4";

[PFMaBiSmAd]

mysql_fetch_array() only fetches ONE ROW from the result set. You would need to use a while(){} loop to fetch all the rows from the result set.

[Ryflex]

Hi PFMaBiSmAd,

 

If a mysql_fetch_array query only fetches one row what would a while loop do then???

 

Thnx Ryflex

[harristweed]

$sql= "SELECT name FROM unittype WHERE type = 1";
$result=mysql_query($sql) or die("Could not find units");
while($data=mysql_fetch_array($result)){
   echo"$data[0]<br />\n";
}

[Ryflex]

Hi harristweed,

 

but my problem is not getting the information echoed but I need them in the variables $n1 till $n4

 

Thnx Ryflex

[Pikachu2000]

To clarify what was being said, mysql_fetch_array() only retrieves one row at a time.

[Ryflex]

Hi Pikachu2000,

 

I do understand that but is it possible in some other way to get the information in the way I mentioned???

 

Thnx Ryflex

[PFMaBiSmAd]

A) Don't use a series of named variables, $n1, $n2, ... Use an array (arrays are for sets of data, which is what you have.)

 

B) Instead of an echo statement, you would assign the value to an array element. Programming is about doing what you want when and where you want it to happen.

 

C) Done!

[Ryflex]

Hi all,

 

I got this far and got what is underneath but then how do I get the right values???

 

Thnx Ryflex

 

$sql				= "SELECT name FROM unittype WHERE type = 1";
$result				= mysql_query($sql) or die("Could not find units");
while($data = mysql_fetch_assoc($result))
{
$n[]				= $data;
}
print_r($n);
echo $n[0],$n[1],$n[2],$n[3];

Array ( [0] => Array ( [name] => gunner ) [1] => Array ( [name] => marine ) [2] => Array ( [name] => sniper ) [3] => Array ( [name] => special ops ) ) ArrayArrayArrayArray

[Ryflex]

Hi all,

 

I found out how to get to my info but it's kind of awkward...

I have to use $n[1][name] to get my info out. Is there a way to get around the [name] part and just make it one-dimensional???

 

Thnx Ryflex

[kenrbnsn]

Don't store the full array, only store the information you need:

<?php
$sql				= "SELECT name FROM unittype WHERE type = 1";
$result				= mysql_query($sql) or die("Could not find units");
while($data = mysql_fetch_assoc($result))
{
$n[]				= $data['name'];
}
print_r($n);
echo implode(',',$n);
?>

 

Ken

[Ryflex]

Hi kenrbnsn,

 

Thnx this really helped me.

 

Not only kenrbnsn thnx but all who responded thank you.

 

Ryflex