Re: insert into

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: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >