Populating Forms

[Anon]

Hi,
BACKGROUND.
i have a database and i can read from this source. But when i create a php file with a form i dont know how to populate the items in the form with data from the database.

Dose anyone know how to.??

[Anon]

Forexample:

suppose that you have the followings:

1. localhost
2. database
3. table

<form action = filename.php method=post>
show all information in a given table
<input type=submit name=ShowAll Value = show>
</form>

<?
if(isset($ShowAll)){
$connect = mysql_connect("localhost", "", "");
$database = mysql_select_db("databasename");
$query = "select * from table";
$result = mysql_query($query);
while($data = mysql_fetch_object($result)){

display the results ....
}
}

[Anon]

I think i know what you getting at...

If you want to display information from a database in a text box, or a one line text box do the following:

First, connect to you database, and collect the information, if you prefer, set them to variables, then when you make your form, use:

<input type="text" name="YourName" size="20" value="<? echo"$yourvariable"; ?>">

or

<textarea rows="2" name="YourName" cols="20"><? echo"$yourvariable"; ?></textarea>

if you use a text box.

I hope this is what you were looking for.