Gegevens uit database in formulier..

<? \\connect\\

mysql_select_db($db);
 $query = mysql_query("SELECT * FROM jos_users where id = $id");
  while ($arr = mysql_fetch_array($query, MYSQL_ASSOC)) {  
  echo "" . $arr['username'] . "";    << dat werkt
  }   
?>
    <td width="253">Naam 
<?php echo "<input name=\"naam\" type=\"text\" maxlength=\"50\" value=\" " .$arr['username']. "\"></td>"; ?>  << dit werkt natuurlijk niet... 

<? \\connect\\
 
mysql_select_db($db);
 $query = mysql_query("SELECT * FROM jos_users where id = $id");
  while ($arr = mysql_fetch_array($query, MYSQL_ASSOC)) {  
  echo "" . $arr['username'] . "";    << dat werkt
  }   
?>
    <td width="253">Naam 
<?php echo "<input name=\"naam\" type=\"text\" maxlength=\"50\" value=\" " .$arr['username']. "\"></td>"; ?>  << dit werkt natuurlijk niet...

<?PHP
// connect
$query = mysql_query("SELECT * FROM jos_users where id = ".$id);
while($fetch = mysql_fetch_assoc($query))
{
?><td width="253">Naam 
<?php echo "<input name=\"naam\" type=\"text\" maxlength=\"50\" value=\" " .$fetch['username']. "\"></td>"; ?>  << dit werkt natuurlijk niet... 
<?PHP
}
?>

<?PHP
// connect
$query = mysql_query("SELECT * FROM jos_users where id = ".$id);
while($fetch = mysql_fetch_assoc($query))
{
?><td width="253">Naam 
<?php echo "<input name=\"naam\" type=\"text\" maxlength=\"50\" value=\" " .$fetch['username']. "\"></td>"; ?>  << dit werkt natuurlijk niet... 
<?PHP
}
?>

<?php
// Hier verbinding maken
$qSelectUsername = mysql_query("SELECT username FROM jos_users WHERE id = ".$id);

while ($aUserInfo = mysql_fetch_assoc($qSelectUsername)) {
?>
    <td width="253"><input type="text" name="naam" id="naam" value="<?= $aUserInfo['username']; ?>" maxlength="50" /></td>
<?php
}
?>

<?php
// Hier verbinding maken
$qSelectUsername = mysql_query("SELECT username FROM jos_users WHERE id = ".$id);
 
while ($aUserInfo = mysql_fetch_assoc($qSelectUsername)) {
?>
    <td width="253"><input type="text" name="naam" id="naam" value="<?= $aUserInfo['username']; ?>" maxlength="50" /></td>
<?php
}
?>

<?php
// Hier verbinding maken
$id = htmlEntities($_GET['id'], ENT_QUOTES);
$sSelectUsername = "SELECT username FROM jos_users WHERE id = ".$id;
if(!$rSelectUsername = MySQL_Query($sSelectUsername))
{
    echo "Error!- ".MySQL_Error()."<br />".MySQL_Errno();
} else
{
    while ($aUserInfo = MySQL_Fetch_Assoc($rSelectUsername)) {
?>
    <td width="253"><input type="text" name="naam" id="naam" value="<?= $aUserInfo['username']; ?>" maxlength="50" /></td>
<?php
    }
}
?>

<?php
// Hier verbinding maken
$id = htmlEntities($_GET['id'], ENT_QUOTES);
$sSelectUsername = "SELECT username FROM jos_users WHERE id = ".$id;
if(!$rSelectUsername = MySQL_Query($sSelectUsername))
{
    echo "Error!- ".MySQL_Error()."<br />".MySQL_Errno();
} else
{
    while ($aUserInfo = MySQL_Fetch_Assoc($rSelectUsername)) {
?>
    <td width="253"><input type="text" name="naam" id="naam" value="<?= $aUserInfo['username']; ?>" maxlength="50" /></td>
<?php
    }
}
?>