Retrieving data from MySQL in one SQL statement
- by james.ingham
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++)
{
…
