So this this shoudl work? the table name is video... and the column is timelength...
Code:
$columns = $db->query_read("SHOW COLUMNS FROM video");
$videocolumns = array();
while ($column = $db->fetch_array($columns))
{
$videocolumns[] = $column['field'];
}
if (!in_array('timelength', $videocolumns))
{
echo('<li>Altering Table <strong>' . TABLE_PREFIX . 'video</strong> ... ');
$db->query_write("ALTER TABLE video ADD timelength int(10) unsigned NOT NULL");
}
I will use the install code stuff in future iterations...