front end/client for mysql
I am looking for a Win32 front end/client for mysql. I want to be able to run it on my local machine, but modify a remote mysql db. I would like it to be as user friendly as possible, with the user having to know as little sql as possible. Any suggestions? Or maybe a web client that I can run from my website...I believe my webhost is running Linux. Any suggestions there? I have been using phpMyAdmin 2.0.1, but it doesn't allow me (or I can figure out how to) edit a record's data without using a query, which requires a knowledge of sql syntax. I can edit the structure, but just not the data (again without the use of sql queries...) Maybe I am wrong about that though Ed - 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
db design questions
I am working on a website which will make use of a MySQL database. I know little if anything about the best way to design my db for efficiency, or anything else for that matter. The information which I need to put in the database will be contact/profile information on various people: Name, Address, Phone, Email, Marital Status, Spouse, kids, things like that and a field for comments submitted from the various people. Right now I have a single table with a record for each item I want to store. Is that an acceptable way? What are some websites which contain some basic information on DB design etc. Things such as the best way to structure the db for effiency, searches, what do all the terms mean (keys, index etc) etc. Ed - 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: front end/client for mysql
Thanks to all those who offered suggestions...However, I just found out that my webhost does not remote connections to the mysql server. It was suggested that I use a Perl program to modify my database. Any suggestions on something I can load on my website to modify the db? Ed -Original Message- From: Ed Peddycoart [mailto:[EMAIL PROTECTED]] Sent: Friday, July 06, 2001 10:26 AM To: [EMAIL PROTECTED] Subject: front end/client for mysql I am looking for a Win32 front end/client for mysql. I want to be able to run it on my local machine, but modify a remote mysql db. I would like it to be as user friendly as possible, with the user having to know as little sql as possible. Any suggestions? Or maybe a web client that I can run from my website...I believe my webhost is running Linux. Any suggestions there? I have been using phpMyAdmin 2.0.1, but it doesn't allow me (or I can figure out how to) edit a record's data without using a query, which requires a knowledge of sql syntax. I can edit the structure, but just not the data (again without the use of sql queries...) Maybe I am wrong about that though Ed - 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
Need help on mysql/php
I recently move my website to FastWebServers.com. MySQL and PHP is provided. I have a control panel which allows me to initialize MySQL for my use. The initialization creates a db, named celticblues_com (my domain is celticblues.com). So far, I have added a table to my database, and added the neccessary fields. Now I am at a total loss at what to do. I want to use PHP scripts to pull info from the db and search the db etc. I have contacted my support from FWS, but they point me to MySQL.com for Mysql commands technical support. Seems to me I would need to know how to set username/password to access the db from script etc. The bottom line question is can someone point me to information on what I need to do to be able to access(open/close) the db, retrieve/store information, etc. in this type of environment (i.e. MySQL provide by my host service, not installed by me)? Ed - 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: Need help on mysql/php
Thanks...this helped...Just had success in connecting to the MySQL server and dumping the db contents to the screenOne worrisome bit though...My username and password for connecting to the db on my host is my username and password for the web account. If I want to create dynamic webpages by pulling data from my db, won't I have to put this information (usersname and pw) in the php file and leave it on the server? Sounds pretty darn scary to me...maybe I am confused. Ed -Original Message- From: Jorge Oliveira [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 12:47 PM To: Mysql@Lists. Mysql. Com Subject: RE: Need help on mysql/php Hi, Please refer to http://www.php.net/manual/en/ref.mysql.php Jorge Oliveira [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] © webfroggie.com - Recursos Online! web: http://www.webfroggie.com wap: http://www.webfroggie.com -Mensagem original- De: Ed Peddycoart [mailto:[EMAIL PROTECTED]] Enviada: Terça-feira, 5 de Junho de 2001 21:31 Para: [EMAIL PROTECTED] Assunto: Need help on mysql/php I recently move my website to FastWebServers.com. MySQL and PHP is provided. I have a control panel which allows me to initialize MySQL for my use. The initialization creates a db, named celticblues_com (my domain is celticblues.com). So far, I have added a table to my database, and added the neccessary fields. Now I am at a total loss at what to do. I want to use PHP scripts to pull info from the db and search the db etc. I have contacted my support from FWS, but they point me to MySQL.com for Mysql commands technical support. Seems to me I would need to know how to set username/password to access the db from script etc. The bottom line question is can someone point me to information on what I need to do to be able to access(open/close) the db, retrieve/store information, etc. in this type of environment (i.e. MySQL provide by my host service, not installed by me)? Ed - 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
