<?
$connect = mysql_connect("localhost","id","pw");
mysql_select_db("db_name",$connect);
$query = "SELECT * FROM db_name.oh_yea WHERE oh_oh LIKE '2012%' ";
$result=mysql_query($query,$connect);
$total =mysql_num_rows($result);
for($a=0; $a<$total; $a++) {
$data= mysql_fetch_array($result);
$new_Num= $data[num];
$new_Area= $data[area];
echo $new_Num; echo $new_Area; echo"<br>";
}
?>
|
