If you're familiar with getting data out of a table, then I don't believe
you really need any examples.

Consider the following over view or what you might do with a CD store:

Get a product row from a data base into an array.  it might look something

$myrow["id"] (55)
$myrow["artist"] (Nine Inch Nails)
$myrow["title"] (The downward Spiral)
$myrow["price"] (25.99)
$myrow["category"] (Alternative)
$myrow["additional_info"] (Limted edition cover art)

Apart from the category, these are all text fields, so build your form, and
echo these values into the form value="".  eg:

<INPUT type="text" value="<?=$myrow["artist"]?>" size="50" maxlength="255">
etc etc

In the case of category, you might have 5 categories in a pull down.  the
aim would be to list all categories, and flag the current category as
SELECTED.  This can be done with an if statement:

<SELECT name="category">
    <OPTION value="rock" <? if($myrow["category"] == "rock") { echo
"SELECTED"; } ?>>rock</OPTION>
    <OPTION value="jazz" <? if($myrow["category"] == "jazz") { echo
"SELECTED"; } ?>>jazz</OPTION>
    <OPTION value="alternative" <? if($myrow["category"] == "alternative") {
echo "SELECTED"; } ?>>alternative</OPTION>
    <OPTION value="blues" <? if($myrow["category"] == "blues") { echo
"SELECTED"; } ?>>blues</OPTION>

This would echo SELECTED in the "alternative" OPTION only.

Check boxes, groups of radio buttons, etc etc can all be done in simular

Justin French
Creative Director

on 30/04/02 9:29 PM, Denis L. Menezes ([EMAIL PROTECTED]) wrote:

> Hello friends,
> Can someone please tell me where I can find sample scripts for populating
> textboxes and listboxes on a form(when the form opens) using the data from
> fields in a table?
> Thanks
> Denis

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to