Jump to content

mysql row id


Destramic

Recommended Posts

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]
Link to comment
https://forums.phpfreaks.com/topic/33141-mysql-row-id/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.