Re: [PHP-DB] mysql went away

2004-05-13 Thread Jeffrey Moss
I would start by seeing if the files are there after you create/load the table. It should by default create a file for each table you create. Sounds to me like a problem reading the disk. If you don't find any answers on your own, post your system specs to the MySQL lists. You could also try

[PHP-DB] php-mysql problem

2004-05-13 Thread Jianping Zhu
have redhat 9.0 and Server version: Apache/2.0.40. i have installed rpms php-4.2.2-17.2.i386.rpm php-mysql-4.2.2-17.2.i386.rpm After i create a database called mydb and serveral tables in mysql, I tried to run following testdb.php script

[PHP-DB] Re: question on select

2004-05-13 Thread Neil Smith [MVP, Digital media]
** Or send XML files up and down dynamically using xmlhttp in IE and Mozilla ;-) Cheers - Neil At 04:06 13/05/2004 +, you wrote: To make a client-side solution possible, you'd have to send ALL POSSIBLE data to the page all at the same time then manipulate it with JavaScript. -- PHP Database

RE: [PHP-DB] Linux/PHP/Access Database - oh boy :(

2004-05-13 Thread Alex Gemmell
Well, I have reached a solution that works brilliantly - unfortunately it doesn't involve connecting to the MS Access db file. Instead I have beaten the server administrator with a stick (harassing by phone works!) until he installed MySQL for me. Now I can work with PHPMySQL in harmony! Thanks

RE: RE: [PHP-DB] question on select

2004-05-13 Thread hengameh
Thanks everyone for all your help. I found some code that is using Java script and although it's not fully functional yet I am working on it. If anyone is interested here it is: ?php require_once(util.php); /*file holding DB info*/ global $db; $db = mysql_connect(DBSERVERHOST, DBUSERNAME,

[PHP-DB] Re:RE: [PHP-DB] question on select

2004-05-13 Thread Neil Smith [MVP, Digital media]
That *should* read : document.fcountry.newcountry.value = document.fcountry.country[document.fcountry.country.selectedIndex].value; Skip the 'options' object - I'm surprised you're not getting a javascript error, maybe you have error reporting turned off in your browser ? In any case, always

Re: [PHP-DB] php-mysql problem

2004-05-13 Thread Stefan Dengscherz
hello, did you load the mysql module in your php.ini configuration file? i.e. is the following line there: extension=mysql.so regards On Thu, 13 May 2004 11:47:41 -0400 Jianping Zhu [EMAIL PROTECTED] wrote: have redhat 9.0 and Server version: Apache/2.0.40. i have installed rpms

Re: [PHP-DB] Linux/PHP/Access Database - oh boy :(

2004-05-13 Thread Michael Forbes
I'm glad you found a solution to your problem-- how big a stick did it require? I actually learned a LOT just reading that thread (although I'm an Access guru who came to PHP/MySQL by way of conversion to zealotry, I've never used PHP against an Access back-end). Many thanks to those who

Re: [PHP-DB] Linux/PHP/Access Database - oh boy :(

2004-05-13 Thread Michael Forbes
I'm glad you found a solution to your problem-- how big a stick did it require? I actually learned a LOT just reading that thread (although I'm an Access guru who came to PHP/MySQL by way of conversion to zealotry, I've never used PHP against an Access back-end). Many thanks to those who

Re: [PHP-DB] question on select

2004-05-13 Thread Michael Forbes
Interesting idea. Since I'm convinced that javascript is the bastard offspring of Bill Gates, Larry Ellison, and Baalzebub, can I sue too? :) Hengameh wrote: Well I am suing Java script to capture the selected item and make it the value of my input box. But my problem is how to access this

[PHP-DB] Secure MySQL Access md5()

2004-05-13 Thread Theisen, Gary
Hi all, I've got: WinNT php 4.3.1 phpmyadmin 2.5.6 MySQL 4.0.18-nt I can connect to my db via my php script using: [php] $connection = mysql_connect (localhost, root, ) [/php] That works no problem. This will not work however: [php] $somePass = md5(somePass); $connection =

[PHP-DB] Re: Secure MySQL Access md5()

2004-05-13 Thread Uzi Klein
Gary Theisen [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi all, I've got: WinNT php 4.3.1 phpmyadmin 2.5.6 MySQL 4.0.18-nt I can connect to my db via my php script using: [php] $connection = mysql_connect (localhost, root, ) [/php] That works no problem. This

[PHP-DB] Re: Secure MySQL Access md5()

2004-05-13 Thread Hans Lellelid
Hi, Passwords in the mysql.users table must be encrypted using MySQL's native PASSWORD() function, not MD5(). With newer versions of MySQL, I think there is some change in this, but AFAIK for 4.0.18 this is still true. When connecting to the database you always use the plaintext password,