Edit MySQL Column & Update

Hi all,

I am able to display the data from a table in my database. I have an Edit link, which you can see in the code. Obviously it’s not active but want to when it is pressed to display the current user’s data in textfield’s that I can change and then click Update and it saves them… Anyone have any ideas?

[code=php]<?php

/* connect to the mysql database and use different queries for the count of members */

include ‘configure.php’;
include ‘open.php’;

//navigation
include(“nav.php”);

$info = mysql_query(“SELECT * FROM tbladministrators”);

echo ‘<table border=”1″ cellpadding=”3″ cellspacing=”1″>
<tr valign=”top”>
<td>First Name</td>
<td>Last Name</td>
<td>Username</td>
<td>Password</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>’;

if (mysql_num_rows($info) < 1) {
echo ‘<tr valign=”top”>
<td colspan=”4″>There are no members that match the query. Please go back and try again</td>
</tr>’;
}

else {
while ($qry = mysql_fetch_array($info)) {

//create the layout
?>
<link href=”cs_style.css” rel=”stylesheet” type=”text/css” />

<tr valign=”top”>
<td><?php echo $qry[‘firstname’]; ?></td>
<td><?php echo $qry[‘lastname’]; ?></td>
<td><?php echo $qry[‘username’]; ?></td>
<td><?php echo $qry[‘password’]; ?></td>
<td>Edit</td>
<td>Delete</td>
</tr>
<?php
}
}

echo ‘</table>’;

include ‘library/closedb.php’;

?>[/code]

Also in #PHP _↴