Re: [PHP-DB] MySQL editor
MySQL CONTROL CENTER from mysql.org (very nice) SQLYOG from sqlyog.com PHPMYADMIN from phpmyadmin.net (web interface) - Original Message - From: "Angelo Zanetti" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 19, 2003 11:40 AM Subject: [PHP-DB] MySQL editor Hi all. I need to get a program (interface) for MySQL, I was using MySQL Front but they've discontinued its use. Any suggestions. thanx in advance -Angelo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Having more than one id in the same field
Hi. I have a database designing question to ask. I want to build a table of events. Among the other fields there must be a field that holds the 'responsible organization' of the event. This organization of course will be responsible for other events as well so I have to create another table that holds the organizations (id, name, phones, director etc) and then just pull the organization id to the events table. The problem is that it happens too often to have 2 organizations responsible for the same event so I'll have to add them both to the events table in the same record. How do you advice me to do that? I thought that I could use a text field to hold the ids and then when searching the database just change the MySQL command from "...where events.id='$id'..." (As it would be if only one id was going to be used) to "...where '$id' in (events.ids)..." or maybe something using LIKE. Do you think it can be done this way? Apart from the responsible organization I may have other fields in the same table having the same problem (for example: the event visitors are staying in one hotel and I want to hold control of the hotels as well. Maybe 2 hotels are used instead of one). If I solve my problem this way, do you think that it will be too difficult or 'heavy' to have more than one condition like this in my queries? Do you think of any other way? Thanx in advance Achilles -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Variables coming from forms
Hi. I have posted this thread before but didn't come to a solution so I try again. I've installed Apache 2.0 and PHP 4.2.3 (both with the msi installers) on Windows 2000 Pro. The problem I have is that I get the message Notice: Undefined variable: var_name in every time I pass a new variable into another page whether this happens using the URL or a form or even sessions. The strange thing is that if I run phpinfo() in the same page (where the variable is considered to be undefined) I see that my variables do exist in the variables section of phpinfo. For example. If I use a form to pass a variable in a php file like this: and have the var.php like this: I'll get the message: Notice: Undefined variable: var in C:\Progr.\htdocs\var.php on line 2 while I'll also get a line like this in the variables section of phpinfo(): Variable Value _GET["var"] the value I typed before I think this is really strange. Has anyone something to suggest? Thanx in advance!! Achilles -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Passwords
Thanx guys!! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Passwords
Hi folks. I have a quetion for you which maybe a little silly as I'm still new here.. I want to build a database in which access will have only registered memebers, so I need to protect it. The database will have over 10 records and hopefully over 1000 users-visitors. Everyone of them is going to have his own password. I suppose I will have to build a table with usernames and encrypted passwords but what I don't know is how to protect the pages not to be seen without authorization. At first I thought about the .htaccess and .htpasswd files but I'm not sure yet... Can anyone suggest the best way to protect my database? If it is to complicated to be explained in an email please suggest just the functions names and I'll try to find the way... Thanx Achilles
