mysql row id

[Destramic]

bit of weird questions

1. but when selecting rows from the database, other than using the primary key(id number) is there anyway of getting the row number?

like mysql_insert_id; in a way but to get the number while your fetching the rows..?

2. is there a mysql function that has the array of the columns you wish to fetch..ie:

[code]
$query          = "SELECT news_id,
                          author,
                          DATE_FORMAT(date, '%d/%m/%y %r ') AS date,
                          status
                    FROM news
                    ORDER BY news_id ASC
                    LIMIT ".$from.", ".$limit."";
[code]

and to have a function that calls back array('news_id', 'author', 'date', 'status')
but only the selected columns and not the whole lot from the table.

hope someone can help thanks..[/code][/code]

[Barand]

1. Set a $count variable and increment each time you read the next row.

2. [code]
$row = mysql_fetch_assoc($result);
$cols = array_keys($row);
[/code]