Re: Forms Question

by "Keith D Sellars" <Keith(at)webgraffix.com>

 Date:  Thu, 9 Jan 2003 11:27:36 -0500
 To:  "HWG Basics" <hwg-basics(at)hwg.org>
 References:  p1
  todo: View Thread, Original
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

This page is part of a preserved archive of archives.hwg.org. The site is no longer active and its content is not maintained. For enquiries about this archive, write to archive(at)iwanet.org.