Help! little mysql query, somebody help me in this

[falfool]

Hello all,
Im new to PHP programming, and im having a little problem in my script:

I want to assign the columns' names to a variables

$sql = "SHOW COLUMNS FROM $table_name";
$sql_result = mysql_query($sql) or die...

while ($cols = mysql_fetch_row($sql_result) ) {
for ($i = 0; $i < count($cols); ++$i) {
if ($cols[$i] == "" || $cols[$i] == 0) {
unset($cols[$i]);
}
echo "<P>$cols[$i]";
$column[$i] = $cols[$i];
}
}

The problem in this code that it gives me all the columns' names and types and NULL values etc. i want it just to give me the column NAME
i will appreciate any help, sorry for long message
Thank You, FalfoOL[QUOTE]

[robotrebellion]

Try this:

while(list($name) = mysql_fetch_row($sql_result)) {
    $column[$i] = $name;
    echo "<p>$name";
    $i++;
} 

Each time it gets to a new column, it puts the name of the column into $name and ignores the rest of it. It then places each column name into the $column[] array. Let me know if that's not what you meant

[Cam]

I've used this code to do the same thing before.

while ( $row = mysql_fetch_array($rs) ) {
    foreach ( $row as $field ) {
        $dbField[] = $field;
        break;
    }
} 

[falfool]

Thanks alot guyes.. but there is another problem actually... im gonna try to fix it, if i couldnt ill let u in thank you