mark,
you need to actually write the code somehow in frontpage. i've not dealt
w/ frontpage in a LONG time (mainly cos i can't stand it, but that's
personal opinion so i'll refrain from commenting) ... but i believe there
is a way you can write raw html or php code in there somewhere. that part
you'll have to figure out on your own. :)
the actual php code you'll need really isn't that difficult, something
like this usually works for me:
$link = mysql_connect("hostname.com", "username, "password");
$query = "select * from table where field='blah'";
$result = mysql_db_query("database", $query, $link);
while($row = mysql_fetch_assoc($result)) {
print "The value of 'address' is: " . $row["address"];
}
mysql_close($link);
that's just a rough example, but basically what it does, is: connect to
the database; execute a query, storing the result of the query in the
$result variable; create an array called $row containing the contents of
the query; and loop through that array record by record, printing the
value of the "address" field.
i hope that example was clear enough, i'm not the best at explaining
things sometimes. if you need more information on mysql and php, you can
find it at the following url:
http://www.php.net/manual/en/ref.mysql.php
hope this helps!
~shawn
On Thu, 2 Aug 2001, Mark A. Perez wrote:
> Hello,
>
> I am creating a web based table that when users request or want
> information they list the information in a form. This works great but
> the problem I am having is that I cannot link MySQL table with the form.
> I am using FrontPage 2000 and the only tables that it wants to create
> are result tables in *.mdb or Microsoft Access. These tables cannot be
> imported or exported to my web. And, I have found no actual means of
> connecting my PHP database to my form. Can someone explain what it is I
> am not doing correctly. I have been using databases for many years now,
> but I am at a loss with PHP.
>
> This is greatly appreciated.
>
> Best Regards,
>
> Mark A. Perez
> President and CEO
> MP International
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
