list3.php

조회처리관련 패턴

<?PHP
$con=mysql_connect('localhost','john','1');
mysql_select_db('johnDB');

$sql="select * from Member";
$res=mysql_querty($sql)

echo ("<table border='1'>);

//레코드의 배열단위로 가져옴
while($rs=mysql_fetch_array($res))
{
  $userid = $rs[userid];
  $userage = $rs[userage];
  echo("
        <tr>
        <td>$userid</td> <td>$userage</td>
        </tr>
      ");
};

echo "</table>";
mysql_close($con);

?>