Is there any method to show complete row in mysql?

Is there any method to show complete row in mysql?
I don’t know what is the command for doind this type of thing.
I mean, if any table in mysql has a row, with id, name etc. etc.

And we want to show only 1 post details.
How could we do this if we have the id.

I mean something like,

select row from mysql where id=1;

and show them line by line,
like,

id=1
name=abc
college=xys

etc…

if you want all columns, then you should select all columns

SELECT [COLOR="Blue"]name
     , college[/COLOR] 
  FROM daTable 
 WHERE id = 1

of course, you wouldn’t select id, because you already know what value it has

:wink:

Thank you sir.
But how to show them line by line in PHP?