Since posting, I have been experimenting with how to get the current row number. The SQL query in the original post is unnecessary. The "better
" query is below.
$query = "Select IssueIDNUM FROM tblIssueList ORDER by IssueDate DESC, IssueIDNUM ";
A "beta" version of how to get the current row (cursor position) is below. I think the code can be substantially shrunk as I learn more.
$current_row_number = return_row_number();
// Loop through the Array; Get Row Number for the current issue
global $result,$issuenum, $rowcount;
if($issuenum == $row['IssueIDNUM'])
return $count -1;
I also found on the W3 School website a listing of PHP 5 Array Functions
. Yea, now I can get some DAO compatibility.