将数据mysql爆炸成所选项目[关闭]

Question

i have data in mysql which is

id|merchant_id|card_support|

1 | 000001 | visa,mastercard,amex |
2 | 000002 | visa,mastercard |

php:
i think something wrong in php here:

<?php $qryselect = mysql_query("select * from cc_merchant"); ?>
  <span style="font:25px Verdana, Arial, Helvetica, sans-serif; color:#666666; font-weight:bold;">CREDIT CARD TYPE</span>
            <?php 
            $getcard = mysql_fetch_assoc($qryselect);
            $card = $getcard['card_support']; 
            $cctype = explode(',',$card);
            ?>
            <select>
            <option value="">&nbsp;</option>
            <?php for ($a = 0; $a < sizeof($cctype); $a++) {?>
            <option value="<?php echo $cctype[$a]; ?>"><?php echo $cctype[$a]; ?></option>
            <?php } ?>
            </select>

what is the problem here...i want to display the data into selected item after i explode it...but it seem nothing to display...please help..

Answer 1

it is preferred to use count() over sizeof(), as sizeof() doesn't mean the same thing in most other languages. Additionally, it is recommended to use foreach() to iterate through arrays:

foreach($cctype as $c){
    echo '<option value="'.$c.'">'.$c.'</option>';
}