Adding record to a MYSQL DB using PHP ?

What is the best way to add a new record to a MYSQL DB using a FORM and PHP
?
Any examples or URLS ?

Thanks

"Metnetsky" <mimetnet@syr.edu> wrote in message
newsan.2003.07.08.17.48.01.15654@syr.edu...
> On Tue, 08 Jul 2003 17:49:42 +0100, James wrote:
>
> > What is the best way to add a new record to a MYSQL DB using a FORM and
> > PHP ?
> > Any examples or URLS ?
> >
> > Thanks
>
> If you can make use of the PEAR (pear.php.net) library you should give it
> a shot as it's a great interface to databases. But here's a simple
> example using pure PHP commands.
>
>
> if (!$myConn = mysql_connect("localhost")) {
> exit("Unable to make a connection to the database");
> }

mysql_connect can work just as well with

$connectionid=mysql_connect($host,$user,$pass) or die ("Could not connect");

as the 'or die' statement exits the program after the string is sent to the
browser..
just another way of doing things.

That, and it looks neater.