[madmacgames]

Hello,

Does anyone know if it is possible to get mySQL column attributes with PHP?

I am developing an addon for osCommerce and want it to work with both versions MS1 and MS2. There is just one area where a column has changed attributes that I'd like to run a check for (in one version it defaults to 1 and in the other it is auto-incrementing).

[mzllr]

give this a whirl...

[php]
<?

$connect = mysql_connect("localhost", "user", "pass");
$db = mysql_select_db("database", $connect);

$query = "DESCRIBE table_name column_name";
$result = mysql_query($query, $connect);

list($field, $type, $null, $key, $default, $extra) = mysql_fetch_array($result);

if ($extra == NULL)
{
echo "column does not auto-increment";
}
else
{
echo "column auto-increments";
}

?>
[/php]

[madmacgames]

perfect!

just what I was looking for.

Thank you very much!