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/2007

[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] 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 php-db@lists.php.net Subject: [PHP-DB]

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

2007-03-11 Thread bedul
u can't - Original Message - From: Ron Piggott [EMAIL PROTECTED] To: PHP DB php-db@lists.php.net 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

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 is

[PHP-DB] Fw: odbc problem

2007-03-11 Thread bedul
- Original Message - From: gunawan [EMAIL PROTECTED] To: php-db@lists.php.net 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()

Re: [PHP-DB] Fw: odbc problem

2007-03-11 Thread Chris
bedul wrote: - Original Message - From: gunawan [EMAIL PROTECTED] To: php-db@lists.php.net 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

Re: [PHP-DB] Fw: odbc problem

2007-03-11 Thread bedul
- Original Message - From: Chris [EMAIL PROTECTED] To: bedul [EMAIL PROTECTED] Cc: php-db@lists.php.net Sent: Monday, March 12, 2007 12:00 PM Subject: Re: [PHP-DB] Fw: odbc problem bedul wrote: - Original Message - From: gunawan [EMAIL PROTECTED] To: php-db@lists.php.net

[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: php-db@lists.php.net Sent: Monday, March 12, 2007 10:21 AM Subject: Fw: odbc problem

[PHP-DB] Re: odbc problem

2007-03-11 Thread bedul
- Original Message - From: IMRAN [EMAIL PROTECTED] To: bedul [EMAIL PROTECTED] Cc: php.db php-db@lists.php.net 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