如何从mysql数据库中回显列1 ... n除了php中的第一列？

Question

I have a table with par_id and columns (par1-5) 1 up to 5, but I'm trying to have my php function below to echo any number of columns

//-------------------------------------- get about ----------------------------------------------
function getAbout($option){
    $div = array();
    $sql_st = "undefined";

    if($option == "about")
        $sql_st = "SELECT * FROM  `about` where par_id='1'";

    // connect to database
    mysql_connect($_SESSION['dbSever'],$_SESSION['dbUser'],$_SESSION['dbPass']) or die(mysql_error());
    mysql_select_db($_SESSION['tblName']) or die(mysql_error());

    $result = mysql_query($sql_st) or die(mysql_error()."<br/>".$sql_st);
    $num_rows =  mysql_num_rows($result);

    while ($row = mysql_fetch_array($result) ){     
        // not sure what to do here
    }
    // disconnect
    mysql_close();

    return $div;
}

Answer 1

From your question title I'm assuming you have an ID maybe in your first column and you want to keep that from being printed. You could try something like:

$numberOfColumns = mysql_num_fields($result);
while ($row = mysql_fetch_array($result) ){     
     for ($i = 1; $i < $numberOfColumns; $i++){
         echo $row[$i];
     }
}

The $i iterator in the for loop is initiated with value of 1 because PHP handles (like many languages) arrays as zero-based, which means that the first element is referenced by $row[0] (as in this example) - by starting the loop at one and going for as many elements there are in the array, you're effectively grabbing all elements except for the first one.