Re: insert into

H- You are right. My bust. Sorry for the errant info. Although I still highly recommend the site. 8^) -Sterling Philip Olson wrote: > > 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 > > > > -- > 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