After reading through original notes and example above as well as wading through the documentation, I finally got a loop to work with two stored procedures.
Using the results of the first one as a parameter for the second one. Easier to do this way than a huge modified sequence of Inner Join queries.
Hope this helps others...
<?php
$mysqli = new mysqli("$dbServer", "$dbUser", "$dbPass", "$dbName");
$resultPicks = $mysqli->query("CALL $proc ($searchDate, $maxRSI, $incRSI, $minMACD, $minVol, $minTrades, $minClose, $maxClose)", MYSQLI_STORE_RESULT);
while($picksRow = $resultPicks->fetch_array(MYSQLI_ASSOC)) {
$symbol = $picksRow['Symbol'];
clearStoredResults($mysqli);
$resultData = $mysqli->query("CALL prcGetLastMACDDatesBelowZero('$symbol', $searchDate)", MYSQLI_USE_RESULT);
$dataRow = $resultData->fetch_array(MYSQLI_ASSOC);
echo "<p>$symbol ... Num Dates: " . $dataRow['NumDates'];
$resultData->free();
}
$resultPicks->free();
$mysqli->close();
function clearStoredResults($mysqli_link){
while($mysqli_link->next_result()){
if($l_result = $mysqli_link->store_result()){
$l_result->free();
}
}
}
?>