Forum Moderators: coopster
$query="SELECT region_name FROM regions_tbl WHERE region_is_popular=1 && region_is_state=0";
$result=mysql_query($query)or die("mysql error ".mysql_error());
$popularArray=array();
$count=0;
echo $num_rows;
while($row=mysql_fetch_array($result)){
$popularArray[$count]=$row[0];
$count++;
}
print_r($popularArray);
$query="SELECT region_name FROM regions_tbl WHERE region_is_popular=1 && region_is_state=0";
$result=mysql_query($query)or die("mysql error ".mysql_error());
$popularArray=array();
$count=0;
echo $num_rows;
while($row=mysql_fetch_array($result)){
$popularArray[$count]=$row["region_name"];
$count++;
}
print_r($popularArray);