How to display tables with sorting + column numbering?

Question

PHP

Good night, please point out the error code , in the code the commented line is $result = mysql_query("SELECT * from `table`.`column` order by `bandate` desc"); what's wrong with the request? Why, if you connect a string, it works, but the 'username' column disappears .. and please tell me how to number the output according to the principle ?

Answer 1

solved by changing the query "mysql_query("SELECT * FROM `account` WHERE `id` = $accout_id LIMIT 1", $connect" after which everything started working