Mysqli array loading drops first entry

artf

New Member
\[code\]$query_string="SELECT wp_app_tracker.wp_apt_application_date,wp_app_tracker.wp_apt_user FROM wp_app_tracker WHERE wp_app_tracker.wp_apt_user = '" . $current_user_name . "'";$temp_result = mysqli_query($conn, $query_string);$row_count = mysqli_num_rows($temp_result);$application_row = mysqli_fetch_array($temp_result,MYSQLI_ASSOC);$row_kounter=0;while ( $application_row=mysqli_fetch_array($temp_result, MYSQLI_ASSOC) ) {......\[/code\]The values in $conn, $current_user_name are valid because I do not get any syntactical error.I have echo'd $query_string on the webpage and confirmed that the correct number of records are retrieved but while processing in the loop, the while loop does not process the first row in the array.Can anyone please explain why?Thank you in advanceUttam
 
Top