[PHP-DB] Re: odbc problem

2007-03-11 Thread Haydar Tuna
Hello, I faced same problems. My table had many rows but I couldn't run odbc_num_fields. It return -1 result. I looked PHP help file. But I get rows with odbc_fetch_row() function. My operating system was Windows 2003. I think, there is a bug odbc_num_fields function in Windows 2003 operat

[PHP-DB] Re: php with IIS

2007-03-11 Thread Haydar Tuna
Hello, if your operating system is windows XP, you can run PHP and IIS without any problems. if your operating system is windows 2003, you can face some problems becuase microsoft change user privileges in Windows 2003 but if you work more in Windows 2003 operating systems, you can solve

[PHP-DB] Re: odbc problem

2007-03-11 Thread bedul
- Original Message - From: "IMRAN" <[EMAIL PROTECTED]> To: ""bedul"" <[EMAIL PROTECTED]> Cc: "php.db" Sent: Monday, March 12, 2007 1:03 PM Subject: Re: odbc problem > Is odbc_num_fields return any value ? > You can disable the warnings in php.ini file. > > Please let me know if that hel

[PHP-DB] Re: odbc problem

2007-03-11 Thread IMRAN
Is odbc_num_fields return any value ? You can disable the warnings in php.ini file. Please let me know if that helps... - Original Message - From: ""bedul"" <[EMAIL PROTECTED]> Newsgroups: php.db To: Sent: Monday, March 12, 2007 10:21 AM Subject: Fw: odbc problem > > - Original Me

Re: [PHP-DB] Fw: odbc problem

2007-03-11 Thread bedul
- Original Message - From: "Chris" <[EMAIL PROTECTED]> To: "bedul" <[EMAIL PROTECTED]> Cc: Sent: Monday, March 12, 2007 12:00 PM Subject: Re: [PHP-DB] Fw: odbc problem > bedul wrote: > > - Original Message - > > From: "gunawan" <[EMAIL PROTECTED]> > > To: > > Sent: Monday, Marc

Re: [PHP-DB] Fw: odbc problem

2007-03-11 Thread Chris
bedul wrote: - Original Message - From: "gunawan" <[EMAIL PROTECTED]> To: Sent: Monday, March 12, 2007 11:46 AM Subject: odbc problem i have this warning.. i don't know what the meaning http://www.php.net/manual/en/function.odbc-error.php Use the error function and work out what it

[PHP-DB] Fw: odbc problem

2007-03-11 Thread bedul
- Original Message - From: "gunawan" <[EMAIL PROTECTED]> To: Sent: Monday, March 12, 2007 11:46 AM Subject: odbc problem > i have this warning.. i don't know what the meaning > > Using odbc_num_fields > > Warning: odbc_exec() [function.odbc-exec]

Re: [PHP-DB] auto_increment command

2007-03-11 Thread Micah Stevens
Actually you can. As Bastien pointed out: ALTER TABLE tbl AUTO_INCREMENT = 1; This may screw with your indexes though, if you have a primary indexed, or unique indexed row, and you set this to 1, mysql >>MAY<< try and insert conflicting values. I've never done this so I have no idea how this

Re: [PHP-DB] auto_increment command

2007-03-11 Thread bedul
u can't - Original Message - From: "Ron Piggott" <[EMAIL PROTECTED]> To: "PHP DB" Sent: Monday, March 12, 2007 7:52 AM Subject: [PHP-DB] auto_increment command > I am not sure if that last e-mail went through or not. I am wondering > how to re-set the auto_increment field back to 1 in o

[PHP-DB] auto_increment command

2007-03-11 Thread Ron Piggott
I am not sure if that last e-mail went through or not. I am wondering how to re-set the auto_increment field back to 1 in one of my tables. Ron

RE: [PHP-DB] auto_increment

2007-03-11 Thread Bastien Koert
are you dumping the data or you just want to reset? issuing the 'empty table' command in phpmyadmin will do that or you can do ALTER TABLE tbl AUTO_INCREMENT = 100; bastien From: Ron Piggott <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: PHP DB Subject: [PHP-DB] auto_increment Date: S

[PHP-DB] auto_increment

2007-03-11 Thread Ron Piggott
How do I reset the auto_increment value to 1 in table abc? Ron

Re: [PHP-DB] Creating drop down lists

2007-03-11 Thread Bruce Cowin
Your select is only selecting the field 'root' but then you're trying to get the field 'username' in your while loop. So, you can add username to your select (or change it to *): select root, username from training select * from training Regards, Bruce >>> Scott <[EMAIL PROTECTED]> 11/03/2