Re: insert into
| From: | Sterling | Date: | Tue, 24 Apr 2001 17:55:42 +0000 |
| Subject: | Re: insert into | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-50134@lists.php.net to get a copy of this message | ||
H-
Here ya go.
http://www.php.net/manual/en/function.pg-connect.php
This page and the links on the left hand column have everything you'll
ever want to know about db connects and sql queries. 8^)
-Sterling
shawn wrote:
>
> Could someone tell me how to actually execute this script please?
>
> $hostname = "";
> $username = "";
> $password = "";
> $dbName = "";
> $userstable = "booking";
>
> MYSQL_CONNECT($hostname, $username, $password)
> or die("Unable to connect to database");
>
> @mysql_select_db( "$dbName")
> or die( "Unable to select database");
>
> $mysql_query INSERT INTO $userstable (client, contact, email, address, city, state, zip, phone,
> fax, model, country, details, type)
> VALUES('$client', '$contact', '$email', '$address',
> '$city', '$state', '$zip', '$phone', '$fax',
> '$model', '$country', '$details', '$type');
>
> MYSQL_CLOSE();
>
> ?>
>
> Thanks, also if you know any tutorials for PHP and MySQL
>
> Shawn