I understood your question perfectly I believe.  And what I responded with
is the beginning stages of doing this.  Once the values are retrieved from
the database, then they must be echoed to the screen in the form of html
using the following command:

<?
echo "html code including the values from the database";
?>

Restricted characters must be escaped when using the html within the php
brackets.

Thanks,
Keith D Sellars
WebGraffix
www.webgraffix.com

"Making database sites seem easy"
----- Original Message -----
From: "Beauford.2002" <beauford.2002(at)rogers.com>
To: "Keith D Sellars" <Keith(at)webgraffix.com>
Cc: "HWG Basics" <hwg-basics(at)hwg.org>
Sent: Friday, January 10, 2003 4:31 PM
Subject: Re: Forms Question


> Thanks for your response, but you misinterpreted my question. I know how
to
> get the information, what I need to know is how to display it in an html
> form.
>
> i.e.
>              _________                    ___________
> Name:  |_________|    Address: |___________|
>
> How do I put the values I retrieve in these form boxes......?
>
> ----- Original Message -----
> From: "Keith D Sellars" <Keith(at)webgraffix.com>
> To: "HWG Basics" <hwg-basics(at)hwg.org>
> Sent: Thursday, January 09, 2003 11:27 AM
> Subject: Re: Forms Question
>
>
> > Beauford,
> >
> > This would probably be more appropriate to post to the languages list,
but
> > here is how you would do it using php (similar results can be achieved
> using
> > perl).  You will need to use a statement such as the following, assuming
> the
> > script has already made the database connection:
> >
> > $result = mysql("$DBName","SELECT * FROM Tablename WHERE Itemname =
> > '$Itemname' ") or die(mysql_error());
> >
> > ... something similar, with possible variations, would retrieve the
> > information you want.  In cases where you may want drop down menus for
> > instance, you would need to create an array, then list the values, which
> > gets a little more complicated, but still isn't too bad.
> >
> > Thanks,
> > Keith D Sellars
> > WebGraffix
> > www.webgraffix.com
> > ----- Original Message -----
> > From: "Beauford.2002" <beauford.2002(at)rogers.com>
> > To: "HWG Basics" <hwg-basics(at)hwg.org>
> > Sent: Thursday, January 09, 2003 10:19 AM
> > Subject: Forms Question
> >
> >
> > > Hi,
> > >
> > > I have a mysql database and want to be able to retrieve information
from
> > it
> > > and put it in a form on my website, but through all my research
haven't
> > been
> > > able to do this.
> > >
> > > Any help is appreciated.
> > >
> > > Beauford
> > >
> > >
> > >
> >
> >
>
>
>

HTML: hwg-basics mailing list archives, maintained by Webmasters @ IWA