I AM CONFUSE
PL. HELP

I WANT TO POPULATE MY FORM WITH THE INFO.FROM FETCHED
ROW FROM MYSQL DATABASE.

TO EDIT INFO BY USER AND UPDATE DB AGAIN.


CAN ANYBODY WILL HELP ME OUT???????????????/:(

May ( or may not ) get something in querystring ( or use other method ) and do a SELECT query:
$query="SQL SELECT WHERE statement";
$row=mysql_fetch_array(mysql_query($query));
or
$row=mysql_fetch_array($query);

then use value='$row[mysql_field_name]' in input or checkbox(s), radio(s); I hope, you'll manage :)

use $_REQUEST[] to get querystring data.

Hi,
I can give you an example. Say, I have a customer table. I want to give the customers option to change their information. For this I query from the database and take the info.
<code>
$sql = "SELECT * FROM customers WHERE customer_id = '$cid'";
</code>
this $cid comes from the selection of previous page. Then useing some functions I fetch the info.
<code>
$sql_res = mysql_query($sql);
$c_info = mysql_fetch_array($sql_res);
</code>
Now i have the row in the $c_info array. Now create your edit or update form and populate that.
<code>
<form action="update.php" method="POST">
Name :<input type=text name=id value="<?php echo $c_info['id']; ?>">
Address : <input type=text name=addr value="<?php echo $c_info['id']; ?>">
.
.
.
.
</code>

The information can be edited by the user.
Then the next script that would update the information ( i.e. update.php) should have the sql queries to fetch the information from the previous page and update the db table accordingly.

Bes of luck.