Guys, I'm making a database program in PHP. I have got everything working, from the inserting, deleting, and viewing records. But I can't get Updating records to work. I want the user to be able to click on "Edit button" GETing the previous records and make changes then update. Thanks.

what code have u tried ?

Thanks. I tried sending the row I'd with my edit button on the page where my database entries are in a loop.
Echo '<td><a href="edit.php?id=' . $row['id'] .'">Edit</a></td>';

On the edit.php page
I tried.....
1: creating a form with the input values as php echo $_POST['some row from the table I'm working on']

UPDATE `table` SET `column name`='newdata' WHERE `column`='blah blah'

Jregz:
UPDATE `table` SET `column name`='newdata' WHERE `column`='blah blah'

Nice one. Buh I'm trying to retrieve records and display them in a fieldset before updating

ivcraig:

Nice one. Buh I'm trying to retrieve records and display them in a fieldset before updating

*use a SELECT statement to retrieve this info from ur db
*store this info in variables
*attach these variables to your form values while displaying them

*Ehm, are u getting errors from ur code or u are looking for the Edit Record Logic ?

ivcraig:

Nice one. Buh I'm trying to retrieve records and display them in a fieldset before updating

it has been answered by the poster above me,do remember to add the PHP tag before echoing the variable, else na so so dollar sign go full your web app

codemarshal08:


*use a SELECT statement to retrieve this info from ur db
*store this info in variables
*attach these variables to your form values while displaying them

*Ehm, are u getting errors from ur code or u are looking for the Edit Record Logic ?

Thanks CodeMarshal. Just what I need, the Edit Record Logic.

ivcraig:

Thanks CodeMarshal. Just what I need, the Edit Record Logic.

Lets Assume i want to edit user with ID 603,
i will create two pages Edit.php and update.php (Note: You can as well use a Page for both)

in Edit.php,

* store this id in a variable , like:
$userID = 603;

* then use this id in the WHERE clause of ur SELECT statement like:
SELECT something from TABLE WHERE id = 603

* retrieve the result result using:
mysql_fetch_array or stuff like that o

* save ur values u got from DB QUERY in variables like
$username = $row["username"];
$dept = $row["dept"];

* echo out ur form by attaching those variable u saved to the html tags like:

echo"<form action='edit' method='POST'>";
echo"<input type ='text' name='username' value='$username' />";
echo"<input type ='text' name='dept' value='$dept' />";

* Attach the id to a hidden text field (so u can retrieve it in the next page) something like:
<input type=''hidden' name='userID' value=$userID>

* remember to add a submit button to ur form o

In Update.php

* retrieve form value
i guess u can do this (hint: POST)

* use these values to update ur DB

hint: using UPDATE statement

codemarshal08:


Lets Assume i want to edit user with ID 603,
i will create two pages Edit.php and update.php (Note: You can as well use a Page for both)

in Edit.php,

* store this id in a variable , like:
$userID = 603;

* then use this id in the WHERE clause of ur SELECT statement like:
SELECT something from TABLE WHERE id = 603

* retrieve the result result using:
mysql_fetch_array or stuff like that o

* save ur values u got from DB QUERY in variables like
$username = $row["username"];
$dept = $row["dept"];

* echo out ur form by attaching those variable u saved to the html tags like:

echo"<form action='edit' method='POST'>";
echo"<input type ='text' name='username' value='$username' />";
echo"<input type ='text' name='dept' value='$dept' />";

* Attach the id to a hidden text field (so u can retrieve it in the next page) something like:
<input type=''hidden' name='userID' value=$userID>

* remember to add a submit button to ur form o

In Update.php

* retrieve form value
i guess u can do this (hint: POST)

* use these values to update ur DB

hint: using UPDATE statement

Wow! Thanks... Lemme quickly follow ur steps. Testimony loading....

Codemarshal08, thank you so much for this piece of code. It worked smoothly like a charm. Bros lemme have u on speed dial, I've got a lot to learn from you. My Sensei.

ivcraig:
Codemarshal08, thank you so much for this piece of code. It worked smoothly like a charm. Bros lemme have u on speed dial, I've got a lot to learn from you. My Sensei.

i am glad u got the idea .
my mail : com(dot)gmail(at)codemarshal08 (READ FROM right to Left)

codemarshal08:

i am glad u got the idea .
my mail : com(dot)gmail(at)codemarshal08 (READ FROM right to Left)

You are a real Code Marshal. Nice one. Added to my contacts.