Advanced Search

Return to Snippet

Revision: 43155
at March 18, 2011 01:34 by erraja_07
Initial Code 
mysql_connect("localhost", "root",'root') or die();
mysql_select_db('itemtest') or die();

$query = "SELECT * FROM itemmasterlist WHERE 1";

$result = mysql_query($query);

$numfields = mysql_num_fields($result);
$row = 0;

for($i=0; $i < $numfields; $i++){
    if(mysql_result($result, $row, $i) != ''){
        $name[$count] = mysql_field_name($result, $i);
        $count++;
    }
    
}

echo 'num of fields filled : '.$count.'<br />';
for($i=0; $i< count($name); $i++){
    echo 'field : '. $name[$i]. ' is not empty<br />';
}
Initial URL 
http://www.webdeveloper.com/forum/showthread.php?t=171879
Initial Description 

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
PHP get mysql table column count

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
PHP