Please ask how to recharge this category

How can I recharge this category? How can I change the value of a dataset column to be retrieved from the data table? PHPcode $ SQL = & quot; selectsid, townshipfromtbl_townshipwherepid = 1 & quot; $ res = how can I recharge this quota column?
How can I change the value of a dataset column to be retrieved from the data table?

PHP code

  $ SQL = "select sid, township from tbl_township where pid = 1"; $ res = db_query ($ SQL); while (list ($ sid, $ township) = mysql_fetch_row ($ res): endwhile;

The sequence column type is as follows:

PHP code

  $ Provinces = array ('Sid '=> 'BJ', 'township '=> 'Beijing'), array ('Sid' => 'hb ', 'township '=> 'hubei '));

------ Solution --------------------
While ($ row = mysql_fetch_assoc ($ res )){
$ Provinces [] = $ row;
}