Re: Re[2]: [PHP] STrange Problem

2004-03-12 Thread trlists
On 12 Mar 2004 Richard Davey wrote: > It is, but if he hasn't modified it otherwise, that's what it'll be. > Also for local development purposes, there is no harm in it. Agreed, as long as he's not connected so someone can try to connect to the MySQL port. -- Tom -- PHP General Mailing List (

Re[2]: [PHP] STrange Problem

2004-03-12 Thread Richard Davey
Hello trlists, Friday, March 12, 2004, 6:37:34 PM, you wrote: tcc> Configuring a MySQL database with a blank root password sounds like a tcc> potential security risk to me ... It is, but if he hasn't modified it otherwise, that's what it'll be. Also for local development purposes, there is no ha

Re: Re[2]: [PHP] STrange Problem

2004-03-12 Thread PHP
Yes, I have it configured to run as apache. But, as I mentioned, I have no problems accessing the database and running querys against it, it is only the mysql_select_db function that fails. > Hello PHP, > > Friday, March 12, 2004, 6:25:09 PM, you wrote: > > P> OK, I do get the following error. >

Re[2]: [PHP] STrange Problem

2004-03-12 Thread Richard Davey
Hello PHP, Friday, March 12, 2004, 6:25:09 PM, you wrote: P> OK, I do get the following error. P> 1044: Access denied for user: '@localhost' to database 'mydatabase' P> Even though I specify the user in mysql_connect, for some reason, P> mysql_select_db is trying to user a blank user, P> Any Ide

Re[2]: [PHP] Strange problem...

2001-11-30 Thread faeton
Hello Daniel, $date = $birth_year."-".$birth_month."-".$birth_day; And you can try inserting such kind o' date to a DATETIME field. There's an alternative way: $time = mktime(0,0,0, $birth_month, $birth_day, $birth_year); That would return a unix timestamp that can be written to a BIGINT field

Re[2]: [PHP] Strange problem...

2001-11-30 Thread faeton
Hello Daniel, Maybe $user_birthdate = (int) $birth_year.$birth_month.$birth_day; would've solved the problem. :) But i'm not 100% sure. DA> I guess it´s too late here now .) It fixed itself when i altered the field DA> type to varchar. Although - i don´t really get why it can´t store the vlaue D