Hi all,
If I'm getting my data from Mysql like so:
$result = $dbConnector->Query("SELECT * FROM branches, businesses WHERE branches.BusinessId = businesses.Id ORDER BY businesses.Name");
$resultNum = $dbConnector->GetNumRows($result);
if($resultNum > 0)
{
for($i=0; $i < $resultNum; $i++)
{
$row = $dbConnector->FetchArray($result);
// $row['businesses.Name'];
// $row['branches.Name'];
echo $row['Name'];
}
}
Does anyone know how to print the field Name in businesses and how to print the name from branches?
My only other alternative is to rename the fields or to call Mysql with two separate queries.
Thanks in advance