Re: How to tell if a field type is auto_increment

["John L. Creed" <john@xxxxxxxxxxxxxxxx>]

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" <niel@xxxxxxxxxxxxx> wrote in message 
news:20070129224943.FD72.NIEL@xxxxxxxxxxxxxxxx
> 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