how to display like below from my table?

[smansakra]

i want to display ID and Profile that Check = 0

and i want the result is like this 2,16,26

how to do that? thanks

below is my table image

[smansakra]

this is my SQL QUERY :
$sql = "SELECT `ID`,`Profile` FROM `sys_friend_list` WHERE `Check`=0";

so, what is next?

[smansakra]

any expert here?

[smansakra]

may be none understand what i mean

[JShor]

Sorry, you need to explain better. Are you trying to sort everything in numerical order and have it displayed?

If so, this code should vork:

<?php

$sql = "SELECT `ID`,`Profile` FROM `sys_friend_list` WHERE `Check`=0 ORDER BY Profile ASC"; // ASC for ascending order, DESC for descending

$qq = mysql_query($sql)  or die(mysql_error());

echo '
<table align="center">
<tr>
  <th>ID</th>
  <th>Profile</th>
  <th>Check</th>
  <th>When</th>
</tr>
';

while($row = mysql_fetch_array( $qq  )) {

echo '
<tr bgcolor="#E8E8E8">
  <td><b>'.$row[ID].'</b></td>
  <td><b>'.$row[Profile].'</b></td>
  <td><b>'.$row[Check].'</b></td>
  <td><b>'.$row[When].'</b></td>
</tr>
';

}

?>

HTH

[heavensgate15]

can you explain it better?