Hi guys,
I’m using a PHP class for my database connections as follows:
//Query rowset from the database.
//returns a full row or rows.
//return value is an associative array with column names as keys.
public function query($sql) {
$DBresult = mysql_query($sql);
if (empty($DBresult)) {
$DCResults = "";
return $DCResults;
} elseif(mysql_num_rows($DBresult) == 1) {
$DCResults = $this->processRowSet($DBresult, true);
} else {
$DCResults = $this->processRowSet($DBresult);
}
mysql_free_result($DBresult);
mysql_close();
return $DCResults;
}
//takes a mysql row set and returns an associative array, where the keys
//in the array are the column names in the row set. If singleRow is set to
//true, then it will return a single row instead of an array of rows.
public function processRowSet($rowSet, $singleRow=false)
{
$resultArray = array();
while($row = mysql_fetch_assoc($rowSet)) {
array_push($resultArray, $row);
}
if($singleRow === true)
return $resultArray[0];
return $resultArray;
}
If there is one row returned, it returns a simple associative array. In the case of more than one row returned, it returns an array of arrays. This is fine normally, but I’ve run into an issue.
On queries where I’m not sure how many rows will come back (one or many), I can’t seem to write the loop code that can handle this properly. How can I detect from the resulting array which type it is?
