Re: [PHP-DB] How to tell if a field type is auto_increment
Ahhh, thanks. I'll do that. -- Regards, John L. Creed pcExpressWay Consulting * dBASE Gold Charter Member 210 * http://www.pcexpressway.com * "Niel Archer" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi John, > > I'd suggest searching within the Extra field instead of testing for the > value explicitly, as this field can theoretically hold several extra > pieces of information. > > Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] How to tell if a field type is auto_increment
Hi John, I'd suggest searching within the Extra field instead of testing for the value explicitly, as this field can theoretically hold several extra pieces of information. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] How to tell if a field type is auto_increment
Here's what I did wih your help:
function isAutoinc($table,$fieldname){
// returns 0 if false, 1 if true
$breturn = 0;
$sql = "SHOW COLUMNS FROM $table LIKE '$fieldname%' ";
$result = mysql_query($sql) or die("Couldn't open table");
// check column Extra
$row = mysql_fetch_array( $result );
if( $row["Extra"] == "auto_increment" ){
$breturn = 1;
}
mysql_free_result($result);
return $breturn;
}
Thanks again!!!
--
Regards,
John L. Creed
pcExpressWay Consulting
*
dBASE Gold Charter Member 210
*
http://www.pcexpressway.com
*
"Niel Archer" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi
>
> Try using:
> SHOW COLUMNS FROM db.table LIKE 'field_name%'
>
> and from the returned row, check the 'Extra' column for 'auto_increment'
>
> Niel
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] How to tell if a field type is auto_increment
Thanks a Million my Friend. I've been struggling with this for days now -- Regards, John L. Creed pcExpressWay Consulting * dBASE Gold Charter Member 210 * http://www.pcexpressway.com * "Niel Archer" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi > > Try using: > SHOW COLUMNS FROM db.table LIKE 'field_name%' > > and from the returned row, check the 'Extra' column for 'auto_increment' > > Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] How to tell if a field type is auto_increment
Hi Try using: SHOW COLUMNS FROM db.table LIKE 'field_name%' and from the returned row, check the 'Extra' column for 'auto_increment' Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] How to tell if a field type is auto_increment
I've been struggling to figure a way to determine if a mySql filed type is auto inc. Any ideas? Iv'e written a function that will INSERT form data which has the exact field names as the mysql table, thus looping through the table names and then building a query string for the insert. However I'd like to skip a field that's autoinc. That can be done if there's no hidden field in the form with the same name. I've created another function that updates a table but only with values in the http form that have changed, using the same logic as above, except I have to have a hidden field of the autoinc field so I know whcih row to update. Obviously the autoinc field won't be changed. Thanks a million in advance. -- Regards, John L. Creed pcExpressWay Consulting * dBASE Gold Charter Member 210 * http://www.pcexpressway.com * -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
