[RESOLVED] Display Query Results before Updating

transfield

Hello,
I've got a MySql database containing names, email addresses, etc of my customers. I've created my own control panel to display the info instead of going into PHPMyAdmin all the time. Please refer to the attached clip_image001.jpg for a sample.

Now, I want to update some particulars of my customers. For example, I may want to change his email address but leave everything else unchanged. I'm looking for a script that will display all the particulars of my customers in an editable text box similar to clip_image002.jpg so that I can edit what I want to edit & ignore the others.

How do I do this?

Thanks for your advice. Much appreciated.

Rodney_H_

What you will do is create one page that is a menu/list of all your users/customers.

for example:

<?php
// connect to db and ...
$query = "SELECT id,fname,lname FROM customers";
$result = mysql_query($query) or mysql_error();
while($row = mysql_fetch_array($result))
{
     echo '<a href="edit.php?cid='.$row['id'].'">'.$row['fname'].'  '.$row['lname'].'</a>';
}
?>

On that page you will link to a specific EDIT page, but you will pass an identifier through the query string to that page, so when the php script on that page is run, it will query the database for all the items you may wish to edit for that person and echo/print them into a form, by pre-populating the values for each textarea or input-text box.

That page could post to itself or to a third page. To process the changes you made using an UPDATE query.

Hope that helps........

transfield

Thank you Rodney. I understand the logic behind your explanation. I will try it out.

Thanks a lot for your guidance.