hi, how do i get multiple arrayrows in variables?
What i have is:
<?
$sql = "SELECT cat_id, cat_title FROM tbl_category WHERE cat_parent=0";
$result = mysql_query( $sql,$connection );
while( $row=mysql_fetch_row($result) )
{
$cat_titles[] = $row[1];
}
mysql_free_result( $result );
foreach( $cat_titles as $v )
{
echo $v."<br />\n";
};
?>
What i want is
<?
$sql = "SELECT cat_id, cat_title FROM tbl_category WHERE cat_parent=0";
$result = mysql_query( $sql,$connection );
while( $row=mysql_fetch_row($result) )
{
$cat_id[] = $row[0]; // <---??
$cat_titles[] = $row[1];
}
mysql_free_result( $result );
foreach( $cat_titles as $v ) AND ( $cat_id as $b ) // <---??
{
echo $v."<br />\n";
echo $b."<br />\n";
};
?>