Speeding up Queries
I have an osCommerce Site along with another Dating site on a completely different server. on the oscommerce site I have 1200 products and the server queries the records very slowwly. I have enabled gzip compression to try and speed this up. Only very slightly has the oscommerce site been sped up. The dating site has 11000 records in it and the same thing has happened and I am wondering what I can do to speed up the queries that are made to each site. Any suggestions ? TIA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Master (pc) Slave (laptop) Replication
I have set up replication and have it working properly for the most part. If I update the master the slave follows suit. But my slave is a laptop, that I use for testing but would like that data to stay up to date withthe master. Overnight if 'live changes take place on the Master, while the slave is not connected, How to I sync up the slave ? (without dumping the db or creating a snapshot) mysql - master = 3.23.33 mysql - slave = 3.23.52 Thank you, --- -Daniel Negron // \\* / _ __ ___ \Lotus Notes Admin / Developer | | |/ /| _ ) | KB Electronic, Inc. | | ' | _ \ | 12095 NW 39th Street | |_|\ \|___/ | Coral Springs, FL. 33065 \ \_\ /954.346.4900 x 122 \\ // email: [EMAIL PROTECTED] - http://www.kbelectronics.com --- - 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
Re: Master (pc) Slave (laptop) Replication
It is automatic. Next time you connect your laptop to the network, and start mysqld on your laptop, it will catch up to the master provided the bin logs are still on the master. The reason i am asking is because it is not updating a couple of records. But if I create a new db with some contents in it, it replicates with no problem. is there anyway to force a sync ? Thank you, --- -Daniel Negron // \\* / _ __ ___ \Lotus Notes Admin / Developer | | |/ /| _ ) | KB Electronic, Inc. | | ' | _ \ | 12095 NW 39th Street | |_|\ \|___/ | Coral Springs, FL. 33065 \ \_\ /954.346.4900 x 122 \\ // email: [EMAIL PROTECTED] - http://www.kbelectronics.com --- - 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
Problem Editing mysql Text field
Hi all, I was wondering if anyone could help me with this issue. I have a TEXT field in my database, It contains HTML, when I edit the field through a web browser it updates fine with no problems. But If I manually edit with MySQL-Front or NaviCat and use the BLOB-TEXT editor It freezes up. I have added the following lines to my.ini, this is after following a few leads to my current problem. set-variable=max_allowed_packet=16M set-variable=thread_stack=1M With these variables in place, I still get the same problem. Any suggestions. TIA **DAN** - 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
Re: Problem Editing mysql Text field
This is weird, all of a sudden it starts working, if it happens again though I will try another front end. Thank you for your advice Thank you, --- -Daniel Negron // \\* / _ __ ___ \Lotus Notes Admin / Developer | | |/ /| _ ) | KB Electronic, Inc. | | ' | _ \ | 12095 NW 39th Street | |_|\ \|___/ | Coral Springs, FL. 33065 \ \_\ /954.346.4900 x 122 \\ // email: [EMAIL PROTECTED] - http://www.kbelectronics.com --- |+- || Insanely | || Great | || insanely420@Pu| || nkAss.com | || | || 02/13/2003 | || 11:22 AM | || | |+- | | | | To: [EMAIL PROTECTED], Daniel Negron/KBE [EMAIL PROTECTED] | | cc: | | Subject: Re: Problem Editing mysql Text field | | Hello There is a bug in both MySQL-Front and NaviCat where updating a field before retrieving all the record in the data result hangs up the thread as they use mysql_use_result() feature. Try using some other Front Ends. Insane - Original Message - From: Daniel Negron/KBE [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 13, 2003 8:13 PM Subject: Problem Editing mysql Text field Hi all, I was wondering if anyone could help me with this issue. I have a TEXT field in my database, It contains HTML, when I edit the field through a web browser it updates fine with no problems. But If I manually edit with MySQL-Front or NaviCat and use the BLOB-TEXT editor It freezes up. I have added the following lines to my.ini, this is after following a few leads to my current problem. set-variable=max_allowed_packet=16M set-variable=thread_stack=1M With these variables in place, I still get the same problem. Any suggestions. TIA **DAN** - 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 - 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 - 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
Re: ACCESS to MySQL
Has anyone tried before to import data from an Access Table to a MySQL Table? Actually, I just need to insert some of the columns and doing it by hand seems quite a long thing to do? I followed these instructions and it worked to a T http://www.sbu.ac.uk/authoring/mysql/convert.shtml Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com - 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
Is Table Name 'PURGE' ALLOWED
Does mysql allow you to name your tables anything. I created a table called 'purge' and insert 3 field purgeday, purgemonth, purgeyear. ALL of the fields are set to INT or INT NOT NULL. When I try to add a record to this table I get and error 'SELECT * FROM purge LIMIT 0,50' Anyone have a clue around this. I figured maybe mysql reserves some names for itself. Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com - 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
Re: Is Table Name 'PURGE' ALLOWED
I get the ID-10-T award of the day. http://www.mysql.com/doc/R/e/Reserved_words.html To answer my own question yes this work is reserved. PEBKAC Thank You /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\ Does mysql allow you to name your tables anything. I created a table called 'purge' and insert 3 field purgeday, purgemonth, purgeyear. ALL of the fields are set to INT or INT NOT NULL. When I try to add a record to this table I get and error 'SELECT * FROM purge LIMIT 0,50' Anyone have a clue around this. I figured maybe mysql reserves some names for itself. Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com - 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
Re: problem inst ...bench... rpm
http://rpmfind.net Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com |+ || Curt Söderberg| || curt.soderber| || [EMAIL PROTECTED] | ||| || 05/16/02 10:39| || AM| ||| |+ -| | | | To: [EMAIL PROTECTED] | | cc: | | Subject: Re: problem inst ...bench... rpm | -| I have now installed mysql-DBI-perl-bin. But I still get a message about failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.49a-1. Is this because of the spelling of mysql / MySQL? Or is it something else? /Curt torsdagen den 16 maj 2002 14.23 skrev Curt Söderberg: Hi, I have installed MySQL from rpm's downloaded from mysql.com. All seems ok except when I try to do rpm -i MySQL-bench-3.23.49a-1.i386.rpm I get an error message from rpm saying the I need MySQL-DBI-perl-bin. Where can I find this MySQL-DBI-perl-bin? Thanks in advance! /Curt - 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 - 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 - 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
Splitting a Table
Hi All, mysql newbie here, this may be a silly question, but I couldn't figure out how to word it for a google search I want to take a table that someone created, a break it up so that one table is NOT 125 fields large. I want to separate the table into user info, product info and product definition. everything happens to be in the same table. The table is heavily occupied with 20,000 entries. How would I start to execute this task ? Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com - 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
Re: no subject
I just had the same exact error two days ago. td checking for termcap functions library... checking for tgetent in -lncurses... no td checking for tgetent in -lcurses... no td checking for tgetent in -ltermcap... no td configure: error: No curses/termcap library found BWhen you installed your RH system, did you install the curses/termcap development tools? /B Some packages are split into runtime and development kits, so people who aren't interested in development don't need to waste the diskspace. The libtermcap libraries are in the libtermcap-devel package: $ rpm -ql libtermcap-devel /usr/include/termcap.h /usr/lib/libtermcap.a /usr/lib/libtermcap.so Make sure that package is installed. You'll also need the ncurses package, of course, but you probably already have that (so many things depend on it). The Key was I was missing the libtermcap-devel files. So download them, and this solved the problem. I also posted this here http://apachetoolbox.com/board/viewthread.php?FID=1TID=927 Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com |+ || Trocca Filippo| || ftrocca@inwin| || d.it | ||| || 04/22/02 03:07| || AM| ||| |+ -| | | | To: [EMAIL PROTECTED] | | cc: | | Subject: no subject | -| I try to compile mysql-2.23.49 but configure process stopped for an error: checking for termcap functions library... configure:error/No curses/termcap library found I have gcc 2.95.3, make 3.79.1 on linux ppc 2000 with 2.2.x linux kernel. Can you help me? Thanks Filippo Trocca - 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 - 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
Installing MySQL via RPM on RH72 (Involves Compiling PHP)
Hi All having a problem with install for PHP. I am trying to compile using --with-mysql=/dir/name I used an RPM to install mysql. during configure I get an error saying that it can not find the header files for mysql. I have used '=/shared' and every directory where there is mysql and mysqld. Do I need to install the src files also ? what else do I need to do for this. PS. MySQL is working with No Problem v3.23 and php 4.1.2 Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com - 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
Re: Installing MySQL via RPM on RH72 (Involves Compiling PHP)
Jens and Jim Thank you, this helps alot. Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com |+ || Jim Philips | || jcphil@mindsp| || ring.com | ||| || 04/18/02 10:36| || AM| ||| |+ -| | | | To: Daniel Negron/KBE [EMAIL PROTECTED], [EMAIL PROTECTED] | | cc: | | Subject: Re: Installing MySQL via RPM on RH72 (Involves Compiling PHP) | -| It isn't generally a good idea to install one piece by rpm and another by compiling and installing. A straight compile and install will put things in different directories from an rpm install. You will have a hard time making it all work. You can go with rpm or compiling from source, but be consistent. If you want to compile everything from source, a goood tool to assist you is here: http://www.apachetoolbox.com It will install MySQL, Apache and PHP and allow you to enable the options you need. It takes a lot of the guesswork out of configuring and compiling. On Thursday 18 April 2002 09:37 am, Daniel Negron/KBE wrote: Hi All having a problem with install for PHP. I am trying to compile using --with-mysql=/dir/name I used an RPM to install mysql. during configure I get an error saying that it can not find the header files for mysql. I have used '=/shared' and every directory where there is mysql and mysqld. Do I need to install the src files also ? what else do I need to do for this. PS. MySQL is working with No Problem v3.23 and php 4.1.2 Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com - 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 - 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
Re: mysql forum
you can try http://phpnuke.org Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com |+ || Javier Gloria | || jgloriame@yah| || oo.com | ||| || 04/02/02 12:27| || PM| ||| |+ -| | | | To: mysql [EMAIL PROTECTED] | | cc: | | Subject: mysql forum | -| Hi everybody: where i can find a forum than works with php,mysql. for my site. or the source code for one. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - 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 - 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
Invalid Argument ??? Not sure how to debug this
Hi all and Good Morning. I have been struggling with this code: I was wondering if someone could lend me a hand. I am working with this code and can't get the error to disappear. After running I get |-| | Warning: Supplied argument is not a valid MySQL result resource in C:\My |Documents\My | | Webs\php\TMPibtpit3zq0.php on line 12 | | |-| Line 12 happens to be the WHILE statement. I am not sure if it is the while statement or the results its looking for. TIA So far, i havent been able to sleep atleast until I get this. html ? if (isset($searchstring)) { $db = mysql_connect(localhost,webuser,); mysql_select_db(cd_collection,$db); $sql= SELECT * FROM cd_list WHERE $searchstring LIKE '%searchstring%' ORDER BY artist ASC; $result = mysql_query($sql,$db); echo TABLE BORDER=2; echo trtdbArtist/btdbTitle/btdbOptions/b/tr; while ($myrow = mysql_fetch_array($result)) { echo trtd.$myrow[artist].td.$myrow[title]; echo tda href=\edit.php?id=.$myrow[cd_id]. \View/a; } echo /TABLE; } else { ? form method=POST action=? $PHP_SELF ? table border=2 cellspacing=2 trtdInsert Your Search String Here./td tdSearch Type/td/tr tr tdinput type=text name=searchstring size=28/td tdselect size=1 name=searchtype option selected value=artistArtist/option option value=titleTitle/option option value=categoryCategory/option /select/td /tr /table pinput type = submit value=Submit name=B1 input type=reset value=Reset/p /form ? } ? /html **DAN** - 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
Re: Some PHP - mySQL help please ... new to both
Thanx Lou, this really helps out. One question though and maybe this runs deeper then I think. When I start my machine, and run phpMyAdmin (VD in IIS5) it works fine. When I close the browser window after making changes to a user, and then try to re-open it, I PHP is no longer working. I am not sure what it is doing at this point. Seems like it left the connection open to the database and it tries to re-connect after re-opening a browser and shuts everything down. I just get a blank page. Other then that this works great. Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com Lou Picciano / Essex SystemsTo: MySQL List [EMAIL PROTECTED], [EMAIL PROTECTED] Omnis@comcast cc: .netSubject: Re: Some PHP - mySQL help please ... new to both 03/08/2002 07:14 PM Dan, Have you taken a look at phpMyAdmin? This very good tool not only administers your MySQL databases, but their php code is a good teaching tool, as well. Simply drop the whole thing into an apache-served directory, and you're off to the races! It's on Sourceforge, and anyone on this list can benefit from it. http://sourceforge.net Let me know how this works out! Lou -Original Message- From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 11:05 AM To: [EMAIL PROTECTED] Subject: Some PHP - mySQL help please ... new to both I am very new to both PHP and mySQL. Any help would be greatly appreciated. While running this code I get following fatal error. PHP is installed and running correctly on the server. mySQL I THINK is running properly. I created a table and this code is from a tutorial I am trying to run through for discussion threads. No matter what I make the connection as (admin or nobody) I still get the same result, which leads me to believe that there is something wrong with the coding. I am too new to this to debug. Line 5 of the dbconnect.php file is where the script stops. again any help would be greatly appreciated. - 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 - 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
Some PHP - mySQL help please ... new to both
I am very new to both PHP and mySQL. Any help would be greatly appreciated. While running this code I get following fatal error. PHP is installed and running correctly on the server. mySQL I THINK is running properly. I created a table and this code is from a tutorial I am trying to run through for discussion threads. No matter what I make the connection as (admin or nobody) I still get the same result, which leads me to believe that there is something wrong with the coding. I am too new to this to debug. Line 5 of the dbconnect.php file is where the script stops. again any help would be greatly appreciated. ? LINE 5 if (!($mylink = mysql_connect (localhost,administrator,))) { print h3could not connect to database/h3\n; exit; } mysql_select_db(mytest); ? RESULT while trying to run script. Fatal error: Maximum execution time of 60 seconds exceeded in dbconnect.php on line 5 Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com - 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
RE: Some PHP - mySQL help please ... new to both
Is the syntax of the statement correct ? ? LINE 5 if (!($mylink = mysql_connect (localhost,administrator,))) { print h3could not connect to database/h3\n; exit; } mysql_select_db(mytest); ? Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com |+ || Todd | || Williamsen | || todd@williams| || en.net | ||| || 03/08/02 12:32| || PM| ||| |+ -| | | | To: 'Daniel Negron/KBE' [EMAIL PROTECTED], [EMAIL PROTECTED]| | cc: | | Subject: RE: Some PHP - mySQL help please ... new to both | -| Daniel, Usually in PHP there are some sort of syntax error before the line that says failed. -Original Message- From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 11:05 AM To: [EMAIL PROTECTED] Subject: Some PHP - mySQL help please ... new to both I am very new to both PHP and mySQL. Any help would be greatly appreciated. While running this code I get following fatal error. PHP is installed and running correctly on the server. mySQL I THINK is running properly. I created a table and this code is from a tutorial I am trying to run through for discussion threads. No matter what I make the connection as (admin or nobody) I still get the same result, which leads me to believe that there is something wrong with the coding. I am too new to this to debug. Line 5 of the dbconnect.php file is where the script stops. again any help would be greatly appreciated. ? LINE 5 if (!($mylink = mysql_connect (localhost,administrator,))) { print h3could not connect to database/h3\n; exit; } mysql_select_db(mytest); ? RESULT while trying to run script. Fatal error: Maximum execution time of 60 seconds exceeded in dbconnect.php on line 5 Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com - 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 - 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