$sqlHelper = a framework to connect / provide functions of sql statements.
execute = can run the query
moveNext = get next row
the problem I am facing is that all off the return results are being populated into the same array. The test runs I have made should return a couple in each array, however its like it tests the first part and just groups the rest in with that.
anyone familiar with Sourdough and/or see an error in the code?
PHP Code:
if( $sqlHelper->execute() )
{
while( $sqlHelper->db->moveNext() )
{
unset($lower);
$lower = strtolower($sqlHelper->db->record['number']);
if( $sqlHelper->db->record['fe_only'] == 1 || is_readable('/images/parts/'. $lower .'.jpg') )
{
$hardwareArray[] = array(
'HRDWR_ID' => $sqlHelper->db->record['part_id'],
'HRDWR_NUM' => $sqlHelper->db->record['number'],
'HRDWR_DESC' => str_replace("\n", "<br />", $sqlHelper->db->record['description']),
'HRDWR_NOTES' => $sqlHelper->db->record['notes'],
'HRDWR_QTY' => $sqlHelper->db->record['quantity'],
'HRDWR_UNIT' => $sqlHelper->db->record['unit']
);
}
else
{
$childArray[] = array(
'SUB_ID' => $sqlHelper->db->record['part_id'],
'SUB_NUM' => $sqlHelper->db->record['number'],
'SUB_DESC' => str_replace("\n", "<br />", $sqlHelper->db->record['description']),
'SUB_NOTES' => $sqlHelper->db->record['notes'],
'SUB_QTY' => $sqlHelper->db->record['quantity'],
'SUB_UNIT' => $sqlHelper->db->record['unit'],
'SUB_IMAGE' => strtolower($sqlHelper->db->record['number']),
);
}
}
}
returns the 1 array, when it should provide 2 arrays
Bookmarks