Just select the values out, and put them as the default
in the value portion of the form inputs, example:

$query = mysql_query('select firstname,lastname from table where
id=1;');
$array = mysql_fetch_array($query);

<input name="firstname" value="<?php echo $array['firstname']; ?>">
<input name="lastname" value="<?php echo $array['lastname']; ?>">


On Thu, 2003-07-24 at 11:41, Matt Hedges wrote:
> Hello. I am building a webpage for a sorority- [url]http://www.olemissaoii.com[/url] .
>
> I built a basic php script where they add the sisters and their names, grad.
> date, and email. Is there anyway to build a page that shows all the fields
> where someone could go in and edit/add what they need? What I basically
> want is a webpage that works like MyCC SQL Database. The only thing I've
> been able to figure out is a basic update page, but using that they have to
> type in everything again- so for example if they want to change the email
> address, they'd have to retype the names and grad. date. So I'd like a
> script that shows all the rows and columns and allows someone to go in and
> change whatever field they want.
>
> Any help greatly appreciated,
> Hedges
>
>
>
>
> --
> ___________________________
> | Matt Hedges
> | [url]http://hedgesinnovations.com[/url]
> |
--
Adam Voigt (adam@cryptocomm.com)
Linux/Unix Network Administrator
The Cryptocomm Group