problems with switch

[jowatkins]

The following code is used to populate a multidimenstional array, using a switch statement to determeni which value to populate. Everything works well the first time through, when j=0, but on subsequent pass throughs the code isn't retreiving the data out of the query.

Can anyone suggect a fix?

Cheers, Jo

if (mysql_num_rows($guest_result) != 0)
			{					
				for ($j=0; $j<=4; $j++) //second dimension
				{
					$guest_row = mysql_fetch_object($guest_result);

				switch ($j)
				{						
					case 0:
						echo "<br/>count = ".$count." - j = ".$j."<br/>";
						$guestsArray[$count][$j]=$guest_row->PartnerID;
						echo " 1  PartnerID - ".$guest_row->PartnerID;
						break;
					case 1:
						echo "<br/>count = ".$count." - j = ".$j."<br/>";
						$guestsArray[$count][$j]=$guest_row->GuestName;
						echo " 2 GuestName - ".$guest_row->GuestName;
						break;
					case 2:
						echo "<br/>count = ".$count." - j = ".$j."<br/>";
						$guestsArray[$count][]=$guest_row->GuestID;	
						echo " 3 GuestID - ".$guest_row->GuestID;
						break;
					case 3:
						echo "<br/>count = ".$count." - j = ".$j."<br/>";
						$guestsArray[$count][]=$guest_row->IsChild;		
						echo " 4 IsChild - ".$guest_row->IsChild;	
						break;
				}	

[mrhappiness]

As you didn't provide a specific description of what exactly doesn't work (what happens, what should happen, ...) I sugges, that maybe [man]mysql-data-seek[/man] might help

if not, please answer the questions mentioned

[jowatkins]

each time the case staement evaluates to something other than 0, the debug items prints to the screen, but there is nothing in the DB data.

I know the data is there, and retrievable, because if I echo it outside the switch case it's fine. For some reason $guest_row->GuestName (and other fields except PartnerID) don't return anything in the switch case.

[mrhappiness]

above your switch please insert

echo '<pre>'.$j. '  -  '.print_r($guest_row, true).'</pre>';

and post the output please

[jowatkins]

Output:

2 - stdClass Object
(
[PartnerID] => 1
[GuestID] => 2
[GuestName] => Penny
[IsChild] => 0
)

for each row; with data correct to the row in the DB; but only outputs if $j == 0

[mrhappiness]

Impossible

you surely won't have the "2" appearing as the very first character for 4 times

show the current code plase and the complete output

[jowatkins]

Apologies, of coure $j incrments, and this is reflected in the output, I was trying to keep my response brief.

ALL actual output (with my own debug extracted):
0 - stdClass Object
(
[PartnerID] => 2
[GuestID] => 3
[GuestName] => Gilly
[IsChild] => 0
)

1 -

2 -

3 -

4 -

0 - stdClass Object
(
[PartnerID] => 3
[GuestID] => 4
[GuestName] => Dusk
[IsChild] => 0
)

1 -

2 -

3 -

4 -

....and so on for each row in the DB.

code:

if (mysql_num_rows($guest_result) != 0)
			{					
				for ($j=0; $j<=4; $j++) //second dimension
				{
					$guest_row = mysql_fetch_object($guest_result);
					#echo " **CHECK** GuestName - ".$guest_row->GuestName."<br/><br/>";

									echo '<pre>'.$j. '  -  '.print_r($guest_row, true).'</pre>'; 
				switch ($j)
				{						
					case 0:
						echo "<br/>count = ".$count." - j = ".$j."<br/>";
						$guestsArray[$count][$j]=$guest_row->PartnerID;
						echo " 1  PartnerID - ".$guest_row->PartnerID;
						break;
					case 1:
						echo "<br/>count = ".$count." - j = ".$j."<br/>";
						$guestsArray[$count][$j]=$guest_row->GuestName;
						echo " 2 GuestName - ".$guest_row->GuestName;
						break;
					case 2:
						echo "<br/>count = ".$count." - j = ".$j."<br/>";
						$guestsArray[$count][]=$guest_row->GuestID;	
						echo " 3 GuestID - ".$guest_row->GuestID;
						break;
					case 3:
						echo "<br/>count = ".$count." - j = ".$j."<br/>";
						$guestsArray[$count][]=$guest_row->IsChild;		
						echo " 4 IsChild - ".$guest_row->IsChild;	
						break;
				}	

				echo "<br/>";
			}

[mrhappiness]

and you're sure you don't want to use mysql_data_seek?

what does

echo mysql_num_rows($guest_result).' results found';

output if placed directly above the switch?

[jowatkins]

Guess I'll have too; just means changing my logic a little. Thanks for all your help.