Help with php query

[escolta]

Hello fellas!, I think im gonna be fired if i dont get to work this by friday and i only have php experience with mailforms but those a are no brainers! .

see, I have a mysql table like this one. as you can see, there are a lot of columns with zero`s values on that table

so lets pretend someone access php login page, and imputs
their id,name and then press login.
Would it be posible that the page then returns only all the non-zero values for their specific record?

how do i do that with php?

[devinemke]

a simple example:

$result = mysql_query('SELECT * FROM table WHERE id = ' . $_POST['id']) or exit(mysql_error());
$row = mysql_fetch_assoc($result);
foreach ($row as $key => $value)
{
	if ($value) {echo $key . ' = ' . $value . '<br>';}
}