occasion

I created the database using cpanel. Created a user with permissions. Created an sql to create tables in the database Example of code in sql: Create Table tablename( field1_id SMALLINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, field2_id SMALLINT UNSIGNED, field3 VARCHAR(200) ); Imported file and executed it All tables were created perfectly. Then I tried to add data to the table by creating the following sql. LOAD DATA LOCAL INFILE 'c:dir\on\my\computer.txt' INTO TABLE logonname_databasename.tableName FIELDS TERMINATED BY '|'; Imported file and executed it No error message in red appeared. Rather the following statements Inserted rows: -1 (Query took 0.0070 sec) SQL-query: LOAD DATA LOCAL INFILE 'c:dir\on\my\computer.txt' INTO TABLE logonname_databasename.tableName FIELDS TERMINATED BY '|' No data was added to the table and yet no error message appeared. I checked and verified that 'c:dir\on\my\computer.txt' exist and contains data. Any suggestions on where I am going astray.

I created the database using cpanel. Created a user with permissions. Created an sql to create tables in the database Example of code in sql: Create Table tablename( field1_id SMALLINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, field2_id SMALLINT UNSIGNED, field3 VARCHAR(200) ); Imported file and executed it All tables were created perfectly. Then I tried to add data to the table by creating a file contaning the following code. LOAD DATA LOCAL INFILE 'c:dir\on\my\computer.txt' INTO TABLE logonname_databasename.tableName FIELDS TERMINATED BY '|'; Save file and imported it. No error message in red appeared. Rather the following statements Inserted rows: -1 (Query took 0.0070 sec) SQL-query: LOAD DATA LOCAL INFILE 'c:dir\on\my\computer.txt' INTO TABLE logonname_databasename.tableName FIELDS TERMINATED BY '|' No data was added to the table and yet no error message appeared. I checked and verified that 'c:dir\on\my\computer.txt' exist and contains data. Any suggestions on where I am going astray.

Thanks for the input. I'll review the information and experiment a little. Databases can be confusing, but are essential. Thanks again.

To develop my database, I installed Apache & MYSQL on my computer. Since I am still developing the site, I frequently recreate, and change the table structure using the following commands after deleting the database. mysqladmin -u username -ppassword create databasename mysql -u username -ppassword<filename.sql mysqlimport -L -h localhost -u username -ppassword --fields-terminated-by="|" databasename c:/directory/tables/filename.txt ... Is it possible for me to use this method of table construction on the server? Thanks

When I try to use dodosmail I get "page not found" while looking for *****/dodosmail.php I can go to cPanel and see the file listed. When I click on the file it shows it's name is *****/dodosmail.php As I have tried to resolve the trouble, dodosmail.php may be trying to call a page it can't find. I not sure. In a post on Dec 5, Don said the following "First in the file test.html remove the line <input type="hidden" name="your_email_address" value="you@******"> do not add your address to the form be sure you uploaded dodsmail.php with the second line edited to your adddress and removed the two # in front of it. The file dosmail.php is not in the same place as the test.html file so the form wil not work. once you edit dosmail.php and upload it goto test.html and fill out the form and it should work. " Now this I did. Any suggestions Thanks, Ron

When I try to use dodosmail I get "page not found" while looking for *****/dodosmail.php I can go to cPanel and see the file listed. When I click on the file it shows it's name is *****/dodosmail.php In a post on Dec 5, Don said the following "First in the file test.html remove the line <input type="hidden" name="your_email_address" value="you@******"> do not add your address to the form be sure you uploaded dodsmail.php with the second line edited to your adddress and removed the two # in front of it. The file dosmail.php is not in the same place as the test.html file so the form wil not work. once you edit dosmail.php and upload it goto test.html and fill out the form and it should work. " Now this I did. Any suggestions Thanks, Ron

Bruce and Don thanks for the links. They meet my needs perfectly.

In asking this question, I really don't expect someone to give me a step by step answer. Instead I looking for a place I can begin to gain knowledge on the 'how to do it'. I would like an email to be sent to an address after the form has been completed and the submit button clicked. Very similar to submitting a ticket at the help desk. How do I begin this process? Any good sites which could help give me direction? Thanks for your assistance. Ron

The bulletin board software, phpbb is not to my liking. I notice this board uses software from Invision Power Board. I would like to use the same software. What is the process? Would I purchase the software and up load it? Thanks again for your help in advance. Ron

On my site, I would like to give the users an option to download an excel file by clicking a link. Is there a site I could visit to get that information? In advance thanks. TotalChoice makes web hosting easy. I am 110% satisifed with TotalChoice.

Don & Mike, thanks for the information. I happened upon Total Choice Hosting by chance and I am glad I did. Where else can go you to enjoy a hobby at less than $10 a month.

Thanks Rick. Nameservers are now changed.

I have been told "The domain is registered but the nameservers are not pointing correctly as you may see from the whois info below." And " Please point your nameservers to ns1.totalchoicehosting.com and ns2.totalchoicehosting.com and it should work fine." But, how do I do it? I have moved my account to Total Choice Hosting and my new registrar is WILD WEST DOMAINS, INC. Thanks

If I begin my hosting win the deluxe plan, but then need to increae bandwidth, may I change to the gold plan and what would be the cost?