Problem by showing merged data from database

[DedoMraz]

Hello

I want to merge data from two tables and then post it into html table.

I have two database tables, one is: model_periferie (is like type of periphery) and another is periferie (periphery). Now, I want to show periphery and type of periphery in html table.

Problem is select returns two rows , but just the first row is showed and there is not showed type of periphery. I think I have error in my two FOR cycles which shows the data in html table

Here is piece of my code:

<?php
/*
THIS PIECE OF CODE SHOULD RETUR PERIPHERY FOR ACTUAL SELECTED COMPUTER
*/

//Connection to database (function is based in another file)
$db_conn = db_connect();
if (!$db_conn)
{
  	return "Nepodarilo sa pripoji&#357; k datab&#225;ze - sk&#250;ste to pros&#237;m nesk&#244;r.";
   	pata_html();
	exit;
} 




//Select from model_periferie (model_periferie its like type or model of periphery)
//returns no error and in this tabe are this data
$query_mod_per = "select * from model_periferie";
$result_mod_per = $db_conn->query($query_mod_per);

If (!$result_mod_per)
{
	echo '<br />Chyba! Pri v&#253;bere modelu perif&#233;rie nastala chyba<br />';
	pata_html();
	exit;
}

//Check if id_pc was POSTET from hidden field
If ($_POST['hid_id_pc'])
{
	$id_pc = $_POST['hid_id_pc'];
	$vc_pc = $_POST['hid_vc'];



//Select data (periphery)where id_pc is equal to posted (id_pc)
//This select returns two rows
$query_per = "select * from periferie where id_pc= '$id_pc' order by vyrobne_cislo";
$result_per = $db_conn->query($query_per);


$num_results = $result_per->num_rows;
If (!result_per)
{
	echo 'Chyba!!! Nastala chyba pri vycitavani periferii podla pocitaca';
}

//$num_results = $result_per->num_rows;

IF 	($result_per->num_rows > 0)
{
 	?>
 	<form action="pridat_per_form.php" method="post">
	<table border=0 cellpadding=4>
 	<?php
 	echo '<tr><td></td><td>Model perif&#233;rie</td><td>V&#253;robn&#233; &#269;&#237;slo</td><td>Invent&#225;rne &#269;&#237;slo</td><td>Upravi&#357;</td></tr>';
 //In next two for cycles(loops) I want to merge type of periphery to actual showed periphery and show it
	for ($i=0; $i < $result_per->num_rows; $i++) //shows selected periphery row
	{
    	$row=$result_per->fetch_assoc();
		$id_periferie=$row['id_periferie'];
		echo '<tr><td><strong>'.($i+1).'. </strong></td>';
//next for should show model_periphery row equal to showed periphery 
			for ($i=0; $i < $result_mod_per->num_rows; $i++) 
			{
				$row_mod=$result_mod_per->fetch_assoc();
				If ($row_mod['id_model_periferie'] == $row['id_model_periferie'])
				echo '<td>'. $row['vyrobca'] . ' ' . $row['model'] .'</td>'; 
			}
			echo '<td>'.htmlspecialchars(stripslashes($row['vyrobne_cislo'])).'</td>'; 
			echo '<td>'.stripslashes($row['inventarne_cislo']).'</td>';
			echo "<td><input type='radio' name='rad_edit_pc[]' value='$id_periferie'></td>";
		}
		$result_mod_per->free();
		$result_per->free();
	}
	else
	{
		echo 'K dan&#233;mu po&#269;&#237;ta&#269;u neboli priraden&#233; &#382;iadne perif&#233;rie.';

}
}
?>
</table>

[jeremyphphaven]

You're already setting $i in the first FOR loop. Use $j and see what happens.

OR replace the second FOR with a WHILE loop -

while($row_mod = mysql_fetch_array($result, MYSQL_ASSOC)) { ... }

[DedoMraz]

jeremyphphaven wrote:

You're already setting $i in the first FOR loop. Use $j and see what happens.

OR replace the second FOR with a WHILE loop -

while($row_mod = mysql_fetch_array($result, MYSQL_ASSOC)) { ... }

Thanks, I have changed in the second for i to j. But this was helpfull just for displaying all data from "periferie" but not from "model_periferie"