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: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] > _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- PHP Windows 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]
