Re: New PHP

First of all there's no reason to be using and ODBC Driver. You can access mysql directly through PHP. So you can access mysql through the mysql set of functions in the php documentation at: http://www.php.net/manual/en/ref.mysql.php Secondly you can learn how to make the querys in question at: http://www.devshed.com/Server_Side/MySQL/Intro/page1.html To Print the results you would simply do something to the effect of: while(list($field1,$field2) = mysql_fetch_row($queryresult)) { print $field1 . " " . $field2; } If you still can't figure it out then email the list again.

I'm thinking of making the conversion from Cold Fusion. I am NOT a programmer and so Cold Fusion has been very easy for me to use. However due to cost and a few other factors, I"m thinking PHP might be a good switch. Some the deciding factors will be its ease of use and how good these forums are. The Cold Fusion forums have proven to be a fantastic resource for problems and so I would need these forums to be as good or better for me to justify changing languages...this leads me to my first php question. I have a database set up using MySQL on my windows 2000 server using an ODBC driver for my connection. My datasource name is "test," my database name is "testdatabase" and I have a table named "testtable". My username is "usernametest" and my password is "passwordtest" How would I run a simple query to insert a row in my testtable table that has two fields, one called testfield1 the other called testfield2. Then, how would I run another query to select that row and print it on my html page? I have scanned over the manual (VERY BRIEFLY) and didn't see anything related to the database integration. My apologies for this totally mundane question, but as I said above, this messages serves a two-fold purpose and the first is to see how good these forums are :) any help you can provide is greatly appreciated, thx in advance for your time, Burrito -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net For additional commands, e-mail: php-windows-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net

_________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx