how to show all data. Only one row showing

[ItsMe5247]

how to show all data. Only one row showing

[pritaeas]

row contains only one record. Every group needs to be echoed separately inside the while.

[ItsMe5247]

how

[amith_ami]

hi ItsMe5247..
pls try this

<?php 
$num =1;
$sql = "SELECT pp_number,Nationality,employer_id FROM `submission_form`";
$result = $database->query($sql);
while($row = $database->fetch_array($result)){
?>
<div id=form_group<?php echo $num; ?>>
<input type="text" value="<?php echo $row['pp_number']; ?>" class="pp_number" />
<input type="text" value="<?php echo $row['Nationality']; ?>" class="nationlity" />
<input type="text" value="<?php echo $row['employer_id']; ?>" class="registry_number" />
</div>
<?php $num++; } ?>

[rubberman]

This is why you need to read my tutorial about using PHP properly as an object-oriented language. Don't do this stuff inline. Build your data strings dynamically in a class method or a function first, then output it.

https://www.daniweb.com/web-development/php/tutorials/484310/why-you-dont-want-to-mix-php-and-html-directly

[mattster]

@rubberman I think I could say that to just about every PHP post that gets asked.

Those that aren't are normally using a framework and haave no choice aha.

[diafol]

Without going into it too deeply, this would probably do as well with concatenating the output into a string on every iteration and then outputting a single string.

[mattster]

Without going into it too deeply, this would probably do as well with concatenating the output into a string on every iteration and then outputting a single string.

That would make things alot simpler I suppose, maybe he should try that.

[ItsMe5247]

i cant have the text box iterated because the text box are fixed