[PHP-DB] using php to generate html file?

2001-03-06 Thread Fai
Does any body know how to use php to generate html file? That is when a user input for a webpage title, webpage background color or image in a php page, and then we can generate a html file which contains the properties of user's input such as background color. -- PHP Database Mailing List (ht

[PHP-DB] Does php have build-in function to copy a directory?

2001-03-12 Thread Fai
How to use php to copy a whole directory including all files in that directory into another directory? Thank you very much! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list admin

[PHP-DB] connection id in mysql

2001-03-13 Thread Fai
Does any body know why the connection id in mysql will increase when you exit the mysql and login again? But I think the connection id should be cleared when user exit mysql. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e

[PHP-DB] what is connection id?

2001-03-14 Thread Fai
1. What is connection id? We will see this like "your mysql connection id is 12" when you enter into the mysql client programme. 2. Why will the connection id in mysql increase when you exit the mysql and login again? But I think the connection id should be cleared when user exit mysql. Thank yo

[PHP-DB] mysql grant problem?

2001-03-24 Thread Fai
When we use grant as following: GRANT select(col_name_1) on db_name_1.tbl_name_1 to peter identified by "peter"; Then peter can only select the field of col_name_1 on the tbl_name_1 of db_name_1. However, when peter issue the query: DESC tbl_name_1; he can see all the structure of that table. Th

[PHP-DB] auto_increment in mysql

2001-03-28 Thread Fai
In mysql, the auto_increment start at 1 default, But, how can I make the auto_increment start at 0? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL

Re: [PHP-DB] auto_increment in mysql

2001-03-28 Thread Fai
The version you use may be lower than 3.23 because auto_increment sequence number begin at 1 for MySQL version up to 3.23. "Russ Michell" <[EMAIL PROTECTED]> ? news:[EMAIL PROTECTED]... > I may be semi-new to this MySQl lark but I'm sure auto_increment starts > at 0. > > Russ > > #---

[PHP-DB] mysql grant problem

2001-05-16 Thread Fai
When we use grant as following: GRANT select(col_name_1) on db_name_1.tbl_name_1 to peter identified by "peter"; Then peter can only select the field of col_name_1 on the tbl_name_1 of db_name_1. However, when peter issue the query: DESC tbl_name_1; he can see all the structure of that table. Th

[PHP-DB] sql problem

2001-06-26 Thread Fai
SELECT @A:=SUM(salary) FROM table1 WHERE type=1; UPDATE table2 SET summmary=@A WHERE type=1; What does @A: mean? Thank you very much! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the

[PHP-DB] mysql optional file - my.cnf

2001-08-17 Thread Fai
Does any body know how to prevent mysql server looking for user specific optional file ( .my.cnf)? So, user cannot put the optional file (.my.cnf) in his home directory to affect the mysql server behaviour. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTE

[PHP-DB] storing binary data in mysql

2001-12-02 Thread Fai
I use MySQL rpm to install in RedHat 7.2 in one of my pc. Then I store binary data such as image in MySQL and it works normally. However, I install source MySQL in RedHat 7.2 in another pc. But it cannot store binary data. Does anybody know the reason? Is that it need some special configure opti

[PHP-DB] Re: storing binary data in mysql

2001-12-03 Thread Fai
t;Fred" <[EMAIL PROTECTED]> ¼¶¼g©ó¶l¥ó·s»D :[EMAIL PROTECTED] > Why do you think it cannot store binary data? Are you recieving an error > message. If so, what it is? > > Fred > > Fai <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECT

[PHP-DB] install mysql from source

2001-12-04 Thread Fai
Does anybody install mysql from source and able to insert binary data into mysql? I have tested it in the source installation MySQL server in RedHat 7.2 with PHP and found that the image can only be stored and retrival from mysql using PHP when the image's size is smaller than 1K. Although, I inc