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
How do I reset the auto_increment value to 1 in table abc? Ron
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]
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
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
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
- 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()
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
- 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
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
- 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
11 matches
Mail list logo