查询运行但不显示任何内容

Question

i have following code in my program. i don't add database connection and $cat_id those are all good.

<?php
$subCategoryResult = mysql_query("SELECT * FROM sub_category WHERE cat_id='".$cat_id."' ORDER BY id");
?>
<div class='col-lg-12'>
            <?php
                while($subCategoryRow = mysql_fetch_assoc($subCategoryResult)){
                    echo "<h3 class='cd-box cd-header'>asd".$SubCategoryRow[2]."</h3>";
                }
            ?>  
            </div>

now, this query display 7 h3 tags if 7 records in database but not displaying any thing for $SubCategoryRow[2]. it's displaying blank...any help?

Answer 1

Look for var names: $subCategoryRow and $SubCategoryRow