Steps I took to create a database connection (which does not work yet): I downloaded the driver for mySQL & put it in my system DSN. Then I went to Frontpage 2002's Tools, Web Settings, Database. I selected 'Network Connection to DB Server'. I selected mySQL driver, input my server ip address & the database name. I clicked Verify & it confirmed the connection was OK. After doing this, Frontpage created a global.asa file which looks like an HTML page but is an ASP page. When I published this file to my web hoster's server, an error message said my web server does not support .ASP files. I said upload anyway & tested my site; my query did not execute. See below *. Some documentation re: if your server does not support ASP says to go to Tools, Page Options in Frontpage and uncheck ASP support. I don't know if I should do this or not. If Frontpage needs to use this global.asa file for connectivity but my web hoster's server does not support ASP pages, how do I connect????! BTW, my web hoster supports Frontpage 2000 extensions & I have this enabled on my web site setup. As far as I know, I am not using Frontpage 2002 features at all in my web site. I have contacted my web hoster & they just give me sites to go to like mysql or php to read documentation, so they are not helping me at all since I've read the relevant documentation & that's how I got this far by myself but now I'm stuck! * In the script below, the results I get on my site is that I can only see "Here is the current schedule:"; nothing else is on the page! I don't get any errors! I changed the username & password below in order to send this to you. My .php script which I created a hyperlink to is: <html> <head> <meta name="GENERATOR" content="Microsoft FrontPage 5.0"> <meta name="ProgId" content="FrontPage.Editor.Document"> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>Dave's Schedule</title> </head> <body> <?php // Connect to the database server $dbcnx = @mysql_connect("localhost", "fakename", "99999"); if (!$dbcnx) { echo( "<P>Unable to connect to the " . "database server at this time.</P>" ); exit(); } // Select Dave's database if (! @mysql_select_db("dauerbac") ) { echo( "<P>Unable to locate the schedule " . "database at this time.</P>" ); exit(); } ?> <P> Here is the current schedule: </P> <BLOCKQUOTE> <?php // Request the students' schedules $result = mysql_query( "SELECT First, Last, Monday, Tuesday, Wednesday, Thursday, Friday, Sunday, Comments FROM dauerbac`.`students` LIMIT 0, 30"); if (!$result) { echo("<P>Error performing query: " . mysql_error() . "</P>"); exit(); } // Display the text of each row in a paragraph while ( $row = mysql_fetch_array($result) ) { echo("<P>" . $row["First, Last, Monday, Tuesday, Wednesday, Thursday, Friday, Sunday, Comments"] . "</P>"); } ?> </BLOCKQUOTE> </body> </html> --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php