HOWTO fetch a row from DB and fill it in HTML form?

[ahoo]

I have a members' biodata table in MySQL.

How can I fetch a row with the ID='2' and display only the 'name' and 'dob' into a HTML form?

[cahva]

Simply:

<?php
// put your mysql conn here

$query="SELECT name,dob FROM biodata WHERE id='2'";
$result=mysql_query($query);
$row=mysql_fetch_array($result);
?>

<form action="something.php" method="post">
Name: <input type="text" name="name" value="<?=$row['name']?>"><br>
DOB: <input type="text" name="dob" value="<?=$row['dob']?>">
</form>

[AlGale]

Hi.

First time Ive had the chance to help anyone else out - Im usually the one doing the asking.

I presume you are happy with connecting to your database, and that you are just wondering how to extract specific data and generate a table?

Firstly, run a MySQL query:

?>
$cursor = mysql_query ("SELECT * from TABLE where TABLE.ID = '2'");
?>

(use YOUR tablename obviously)

To have some pre-defined headers for your table, run some HTML:

<table border=1 align="center" name="Whatever">
<tr>
<th class="Styles">Name</th>
<th class="Styles">DOB</th>
</tr>

Now you need to dynamically generate the rest of the table and populate it at the same time:

<?
if (!$cursor)
{
echo("<H3>MySQL error: " . mysql_error() . "</H3>");
exit();
}

while ( $row = mysql_fetch_array($cursor) )
{

echo '<TR>
<TD class="Styles">' . $row['Name'] . '</TD>
<TD class="Styles">' . $row['DOB'] . '</TD>
</TR>
}
?>

I`m fairly new to all this myself, so that is re-hashed from my code to fit your requirements.

[ahoo]

Thanks guys!

It's work! Now I'm very happy to continue my system development progress.