Sterling, it appears Shawn is using MySQL, not PostgreSQL. That said,
Shawn, have a look here :
http://www.php.net/manual/en/ref.mysql.php
You'll see a list of MySQL functions, which are in your snippet below.
PHP functions such as :
mysql_connect, mysql_select_db, mysql_query, mysql_fetch_array ...
Attend each manual page for further information on each function and note
the examples. This tutorial may help :
http://php.vamsi.net/mysql/
http://www.sqlcourse.com/
Look around www.zend.com, php.faqts.com, www.phpbuilder.com and
www.devshed.com for a few more goodies, as well as many many other sites!
Also note that when you view tutorials, they are not the only way. Also
note the difference between SQL and PHP.
Regards,
Philip
On Tue, 24 Apr 2001, Sterling wrote:
> 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
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
