How to create an array?

claire

Hi,
I have a small problem;

I do a search in my MySQL db collecting names and apartement numbers, resulting in vars $persons and $aptno.

I do a second search in MySQL in order to find out if two persons live in the same aptno. This is done with:


unset ($persons);

$result = mysql_query("SELECT * FROM tbl WHERE Aptno=$aptno ");

	while ($row = mysql_fetch_array ($result)) {

			 if (!isset($persons)) {


					$persons = $row[Name];

				} else {

					$persons = $persons . ", " . $row[Name];

				}


		 }

The idea is to get names written out together on the same line for the same apt.
If I echo out within the function I get the whole list correctly. However, I would like to store the result in an array for later use outside of the function.

Don't know how to do that.

Any help appreciated. (Know this is basic stuff - quite embarrassed to ask...)

Wave

try this way.

unset ($persons);

$result = mysql_query("SELECT * FROM tbl WHERE Aptno=$aptno ");

    while ($row = mysql_fetch_array ($result)) {
           $persons[] = $row[Name];
    }

Frag

What I would do is use classes. THen store each class object (each person & apartment) in an array. That will allow better data management.

As for putting them in an array. Just create the array array(); and use array_push();

$myArray = array();
array_push($myArray, $myClassObject);

claire

Wave, already tried that. results in Fatal error: [] operator not supported for strings in /home/b/...

dannys

Which version of PHP are you working on?

claire

php 4.2.2

dannys

$persons=Array();

if ($result=mysql_query("SELECT Name FROM tbl WHERE Aptno=$aptno"))
{
	while ($row = mysql_fetch_assoc($result))
		$persons[] = $row['Name'];
}
else
	die("Query Failed!: [".mysql_errno()."] ".mysql_error());

var_dump($persons);

That should work.

Wave

usually it works without declaring variable as array.

dannys

Yeah. usually it does - but, IMO, it's better than unset()

Wave

php is fairly loyal to bad coding style.

you right, it's a good practice to declare variables.
it's my fault. and i promice - next time i'll use Array() 🙂

dannys

I was forced to learn C where you must declare everything before use - So I do it by instinct in PHP.

claire

Originally posted by dannys

$persons=Array();

if ($result=mysql_query("SELECT Name FROM tbl WHERE Aptno=$aptno"))
{
	while ($row = mysql_fetch_assoc($result))
		$persons[] = $row['Name'];
}
else
	die("Query Failed!: [".mysql_errno()."] ".mysql_error());

var_dump($persons);

That should work. [/B]

Slowly getting there...
The array now contain duplicate entries (since apartments with two names are listed twice...

Also, further down in the script I need to assign each name or pair of names with a number.

When I call it with:


for ($i = 0; $i < sizeof($distribution); $i++) {
echo $persons[$i]." ";

...

I still get only the last apartment in the db and the names in that apartment one by one!

Sigh...