identifying data

[The_PHP_Newb]

I'm new to arrays, can someone tell me what is wrong with this code:

$ck1 = mysql_query("select block from table where id = '64'");
while ($ck2 = mysql_fetch_array($ck1)) {
$bad = $ck2[block]; }

I then do a query in a 2nd table using $bad but I keep getting only the last entry from table 1. How do I array all the table 1 entries into 1 variable name? All the array examples I can find show a set # of values for $bad and I might find 20 or I might find none, depending on the id # (in table 1).

[yousaf931]

It would be like this.

$ck1 = mysql_query("select block from table where id = '64'"); 
while ($ck2 = mysql_fetch_array($ck1)) { 
$bad = $ck2[block]; 

echo $bad;

} 

If you to display this is formated form in the table than.

<?
$ck1 = mysql_query("select block from table where id = '64'"); 
?>
<table>
<tr>
<?
while ($ck2 = mysql_fetch_array($ck1)) { 
$bad = $ck2[block];  ?>

<td> <? echo $bad; ?> </td>

<?} ?>
</tr>
</table>