[RESOLVED] array of inputbox wont fit

[Under_Control]

hi all,
i want to make this input box appear inside table each input box has a value from mysql db the code is blow:

<table>
<tr>
<td>Name:</td>
<td>$name</td>
</tr>
</table>

<?php
 connect::db_connect($host,$user,$pass);
 connect::db_select($db);

$result = Name::SelectByID($ID);
whil ($row = mysql_fetch_array($result))
{
  print $name="<input type=\"text\" value=\"$Name\" name=\"uname\" > <br />";
}
?>

every time i run it the input box not shown inside table, what's wrong with that!!!
thanks in advance :d

[rincewind456]

Well two things are wrong:

1st You call $name in html code not in php code.

2nd PHP developers have not yet mastered the physic interface so that you can call a variable (and expect it to hold data) before you fill it with data.

[Under_Control]

so how could i import all user names from mysql db and put them in text box at once to be easy for editing??
would it possible?
thank you

[rincewind456]

would it possible?

Yes but you have to run the php code before you try to access the values.
Like this

<?php
connect::db_connect($host,$user,$pass);
connect::db_select($db);
$name='';
$result = Name::SelectByID($ID);
while ($row = mysql_fetch_array($result))
{
   $name .="<input type=\"text\" value=\"$Name\" name=\"uname\" > <br />";
}
?>

<table>
<tr>
<td>Name:</td>
<td><?php echo $name;?></td>
</tr>
</table>

[Under_Control]

yeah that's working great 😃
but i wonder how determine which one is changed and update it in mysql db!!!😕
thanks in advance

[Under_Control]

I mean how determine which this array keys has been changed so I can update it's value in mysql db

[rincewind456]

You would need to get the user id when you get the name and use the id to identify which record to change.

[Under_Control]

it's ok now
thank you so much bro