join
Posted: Fri Jan 05, 2007 7:30 am
Hello,
The categories contains categoryId field , two rows have been populated. I am getting,
I should get,
Code: Select all
$query=mysql_query("SELECT * FROM categories,events,story");
while($r=mysql_fetch_array($query))
{
$catId[]=$r['categoryId'];
}
print_r($catId);Code: Select all
Array ( [0] => 1 [1] => 2 [2] => 1 [3] => 2 [4] => 1 [5] => 2 [6] => 1 [7] => 2 [8] => 1 [9] => 2 [10] => 1 [11] => 2 [12] => 1 [13] => 2 [14] => 1 [15] => 2 [16] => 1 [17] => 2 [18] => 1 [19] => 2 [20] => 1 [21] => 2 [22] => 1 [23] => 2 [24] => 1 [25] => 2 [26] => 1 [27] => 2 [28] => 1 [29] => 2 [30] => 1 [31] => 2 )Code: Select all
Array ( [0] => 1 [1] => 2 [2]