Thanks for the advice. I have the tables and columns set up using the script from texas and I have the odbc entry in place. I can't figure out why the script thinks that the variables are undefined. If anyone else has any pointers, I would appreciate it. Thanks, Molly
-----Original Message----- From: Dobbs, Aaron [mailto:[EMAIL PROTECTED] Sent: Thursday, November 20, 2003 4:29 PM To: [EMAIL PROTECTED] Subject: RE: Mysql and php and iis Be sure the Column names in the MySQL tables are named the same way in the php on the TILT pages. Have you run the tilt_sql_code.txt texas provided to create the correct tables? Do you have an ODBC entry for your MySQL database? Here's the contents of the tilt_sql_code.txt fiel if you don't have it. -Aaron :-)' CREATE TABLE org (org_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(55)); CREATE TABLE person (person_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, org_id INT, first_name VARCHAR(55) NOT NULL, last_name VARCHAR(55) NOT NULL, class ENUM('freshman','sophomore','junior','graduate','senior','other') NOT NULL DEFAULT 'other', birthdate VARCHAR(20) NOT NULL, email VARCHAR(75), date_modified TIMESTAMP(14)); CREATE TABLE quiz (quiz_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, person_id INT NOT NULL DEFAULT 0, module TINYINT NOT NULL DEFAULT 0, anwers TEXT, comments VARCHAR(255), date_created VARCHAR(55), date_modified TIMESTAMP(14)); Global Internet, Once a spring of liberty, Autumn chill so near. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Signs, Molly Sent: Thursday, November 20, 2003 4:15 PM To: [EMAIL PROTECTED] Subject: RE: Mysql and php and iis Changing our IIS to include html files to be parsed by PHP worked. We are now able to use php. However, we may now have a problem with the mysql implementation. Did anyone see these types of errors when trying to register using reg.html and shortreg.html? Notice: Undefined variable: first_name in D:\inetpub\wwwroot\Library\tilt\tilt_files\intro\reg.html on line 4 Notice: Undefined variable: last_name in D:\inetpub\wwwroot\Library\tilt\tilt_files\intro\reg.html on line 5 Notice: Undefined variable: email in D:\inetpub\wwwroot\Library\tilt\tilt_files\intro\reg.html on line 6 Notice: Undefined variable: month in D:\inetpub\wwwroot\Library\tilt\tilt_files\intro\reg.html on line 7 Notice: Undefined variable: day in D:\inetpub\wwwroot\Library\tilt\tilt_files\intro\reg.html on line 7 Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in D:\inetpub\wwwroot\Library\tilt\tilt_files\intro\reg.html on line 19 Notice: Undefined variable: org in D:\inetpub\wwwroot\Library\tilt\tilt_files\intro\reg.html on line 24 Notice: Undefined variable: class in D:\inetpub\wwwroot\Library\tilt\tilt_files\intro\reg.html on line 30 Warning: Cannot modify header information - headers already sent by (output started at D:\inetpub\wwwroot\Library\tilt\tilt_files\intro\reg.html:4) in D:\inetpub\wwwroot\Library\tilt\tilt_files\intro\reg.html on line 33 Notice: Undefined variable: redirect in D:\inetpub\wwwroot\Library\tilt\tilt_files\intro\reg.html on line 34 Warning: Cannot modify header information - headers already sent by (output started at D:\inetpub\wwwroot\Library\tilt\tilt_files\intro\reg.html:4) in D:\inetpub\wwwroot\Library\tilt\tilt_files\intro\reg.html on line 34 Any advice is appreciated. Thanks, Molly -----Original Message----- From: Signs, Molly Sent: Thursday, November 20, 2003 3:05 PM To: [EMAIL PROTECTED] Subject: RE: Mysql and php and iis Thanks Jim, I think that your advice along with a newer version of PHP is going to do the trick for us. -----Original Message----- From: Jim Gillispie [mailto:[EMAIL PROTECTED] Sent: Thursday, November 20, 2003 11:38 AM To: '[EMAIL PROTECTED]' Subject: RE: Mysql and php and iis If you're talking about calling the reg.html and short_reg.html files, those have PHP code in them, but are .html files (this threw me for a loop at first too). This means that you have to set the mime type in IIS to allow PHP to process .html files. TILT seems to use .htm as the extension for straight HTML files with no PHP, but if you have other non-PHP .html files on your server, they should still work but this can cause a slight downgrade in server performance, depending on your traffic load. But the only other option is to change all the .html files in TILT with PHP code to different file extensions, as well as all the links and calls to them. Hope this helps. - Jim -----Original Message----- From: Signs, Molly [mailto:[EMAIL PROTECTED] Sent: Thursday, November 20, 2003 11:46 AM To: [EMAIL PROTECTED] Subject: Mysql and php and iis We are new to tilt and are attempting to set up the mysql server on our windows NT IIS server. We are having trouble getting the php scripts to run properly. When we attempt to run the logon script we get an error that says, '405 method not allowed. The method specified in the request line in not allowed for the resource identified by the request. Please ensure that you have the proper mime type set up for the resource you are requesting.' We have the mime type set for .phtml and .php in IIS, but this error seems to indicate a problem with IIS or the server configuration. If we try to go into tilt as a guest, we are given a blank page which probably indicates that our server is not processing the php request. I have checked permission on the NT server and mime types. I have also reinstalled the latest version of php. I also have set up the Mysql for tilt based on the instructions. Has anyone recently set up mysql, php and iis on their server? If so are you willing to give me some advice? Thanks, Molly http://library.millsaps.edu/tilt/ > _________________________________________ > > Molly Signs | Systems Librarian > Millsaps-Wilson Library | Millsaps College > 1701 North State Street > Jackson, Mississippi 39210-1066 > 601-974-1086 | fax 601-974-1082 > http://library.millsaps.edu/library/ [EMAIL PROTECTED] >
