[PHP-DB] Re: Query Object in PHP?

2007-03-03 Thread js
Ansering myself. DB_DataObject http://pear.php.net/package/DB_DataObject/ On 2/25/07, js [EMAIL PROTECTED] wrote: Hi list, Is there any implementation of Query Object [1] written in PHP? I spent some time searching on the net but no clues're found. Thank you in advance. [1]

Re: [PHP-DB] Mysql autentication problem

2007-03-03 Thread Roberto Tavares
I got 5 or 6 users... and a respectable computer... On Fri, 02 Mar 2007 22:48:52 -0800, Micah Stevens wrote Reloading the grant tables should happen almost immediately unless you have an extremely large set of users, very little memory, or a very slow computer. On 03/02/2007 06:17 PM,

Re: [PHP-DB] Mysql autentication problem

2007-03-03 Thread Roberto Tavares
I did the reload, but with no effect... On Sat, 3 Mar 2007 09:17:36 +0700, bedul wrote - Original Message - From: Micah Stevens [EMAIL PROTECTED] To: Roberto F Tavares Neto [EMAIL PROTECTED] Cc: php-db@lists.php.net Sent: Saturday, March 03, 2007 3:17 AM Subject: Re: [PHP-DB] Mysql

Re: [PHP-DB] recursion in php and mysql

2007-03-03 Thread Haydar TUNA
Hello, You can use class like the following code .:) ?php require (mysql.class); $conn = new MySQLConnection ($user, $password, $host,$database); ... ... $query1 = new MySQLCommand ($sql1, $conn); $query1-Execute(); $query2 = new

[PHP-DB] Re: Creating a Table to line query results in php?

2007-03-03 Thread Haydar TUNA
Hello, You can use HTML center tag. if you change your echo line in the code below, may be your problem will be fixed :) -- Haydar TUNA Republic Of Turkey - Ministry of National Education Education Technology Department Ankara / TURKEY Web: http://www.haydartuna.net Scott [EMAIL

[PHP-DB] Re: mssql Database name grater than 30 characters

2007-03-03 Thread Haydar TUNA
Hello, All of objects that you created in SQL Server is in the master database. In this database, there is a table called sysobjects that put all of information about tables and so on. You can see table name length in this table :) -- Haydar TUNA Republic Of Turkey - Ministry of

Re: [PHP-DB] Re: Creating a Table to line query results in php?

2007-03-03 Thread Brad Bonkoski
How can I create a table...or even something similar...to line information up? echo table; echo trthHeader1/ththHeader2/ththHeader N/th/tr; while ($data = mysql_fetch_array($res)) { $idfield = $data['IDFIELD']; $name = $data['Name']; $effect = $data['Effect']; $category = $data['Category'];

Re: [PHP-DB] Mysql autentication problem

2007-03-03 Thread Micah Stevens
In mysql 4.1, they changed the hash format of the passwords. If you stored the password from a 3.x client, and area accessing with a 4.x or 5.x client, or the other way around, you might have similar problems. Your command line client is likely the same version as the server, so I'm guessing

[PHP-DB] Re: auto upload

2007-03-03 Thread Haydar TUNA
Hello, I have got a very interesting answer. I built an exe program with Delphi or other Visual Programming. In this program, I use WebBrowser API. With this API, I use your secure file upload program. then I call this exe program from task manager. In this way, you can auto uplaod file

Re: [PHP-DB] error creating tables

2007-03-03 Thread Haydar TUNA
Hello, I tried to run your SQL query with my private database and there wasn't any problem. You can use primary key like your PHP code because I run your SQL in the mysql command line succesfully. Did you connect root account to your mysql server? If the account is root, there isn't any