[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] http://www.ma

Re: [PHP-DB] Mysql autentication problem

2007-03-03 Thread Roberto Tavares
Yep, there is a hash... and the hash is valid - I can connect using the shell with this password... On Fri, 02 Mar 2007 12:17:33 -0800, Micah Stevens wrote > Strange. If you look at the users table, is there a password hash in > the password field? > > Roberto F Tavares Neto wrote: > > Micah: >

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: > Sent: Saturday, March 03, 2007 3:17 AM > Subject: Re: [PHP-DB] Mysql autenti

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

2007-03-03 Thread Haydar TUNA
Hello, You can use class like the following code .:) Execute(); $query2 = new MySQLCommand ($sql2, $conn); $query2->Execute(); .. ?> "Micah Stevens" <[EMAIL PROTECTED]>, haber iletisinde sunlari yazdi:[EMAIL PROTECTED] > Classes are overrated. :) > > Bastien Koe

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

2007-03-03 Thread Haydar TUNA
Hello, You can use HTML 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 PROTECTED

[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 Natio

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 ""; echo "Header1Header2Header N"; while ($data = mysql_fetch_array($res)) { $idfield = $data['IDFIELD']; $name = $data['Name']; $effect = $data['Effect']; $category = $data['Category']; $origin = $data['Origi

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 t

[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