DZkBJJdU

1CREATE TABLE IF NOT EXISTS `countries` (
2  `id` int(10) NOT NULL AUTO_INCREMENT,
3  `country` varchar(50) NOT NULL,
4  `continent` varchar(50) NOT NULL,
5  `description` longtext NOT NULL,
6  PRIMARY KEY (`id`)
7) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
8
9
10
11$result = mysql_query("select * FROM $sTable where $sTable.id = $sId");
12while($item = mysql_fetch_assoc($result)) {
13    foreach($item as $key => $val) {                  
14        echo '
15            <tr>
16                <td>' . ucfirst($key) . '</td><td><input type="text" value="' . $val . '" name="' . $key . '"></td>
17            </tr>
18        ';
19    }
20}
21	
22$result = mysql_query("SHOW COLUMNS FROM $sTable");