// Create a table from the rows of data. table_start(); // Create the column headers. $cell[0] = 'Birth ID'; $cell[1] = 'URL'; $cell[2] = 'Last Name'; $cell[3] = 'First Name'; $cell[4] = 'Place'; $cell[5] = 'Year'; $cell[6] = 'Name'; $cell[7] = null; table_row_header($cell); // Output the data records. while ($row = $result->fetch_object()) { $url = 'https://www.novascotiagenealogy.com/ItemView.aspx?ImageFile=' . $row->RegBook . '-' . $row->RegPage . '&Event=birth&ID=' . $row->BirthID; $cell[0] = html_link($row->BirthID, "edit_ns_births_data.php?id={$row->BirthID}"); $cell[1] = html_link('Source', $url); $cell[2] = $row->LastName; $cell[3] = $row->FirstName; $cell[4] = $row->Place; $cell[5] = $row->Year; $cell[6] = $row->name; $cell[7] = pgv_indi_link($row->n_id); table_row($cell); } table_end(); // Generate the page trailer. html_trailer(); ?>
// Create the column headers. $cell[0] = 'Marriage ID'; $cell[1] = 'URL'; $cell[2] = 'NSHVS Groom'; $cell[3] = 'NSHVS Bride'; $cell[4] = 'NSHVS Year'; $cell[5] = 'Groom'; $cell[6] = null; $cell[7] = 'Bride'; $cell[8] = null; table_row_header($cell); // Output the data records. while ($row = $result->fetch_object()) { $url = 'https://www.novascotiagenealogy.com/ItemView.aspx?ImageFile=' . $row->RegBook . '-' . $row->RegPage . '&Event=marriage&ID=' . $row->MarriageID; $cell[0] = html_link($row->MarriageID, "edit_ns_marriages_data.php?id={$row->MarriageID}"); $cell[1] = html_link('Source', $url); $cell[2] = $row->GroomLastName . ', ' . $row->GroomFirstName; $cell[3] = $row->BrideLastName . ', ' . $row->BrideFirstName; $cell[4] = $row->Year; $cell[5] = $row->groom; $cell[6] = pgv_indi_link($row->n_id_g); $cell[7] = $row->bride; $cell[8] = pgv_indi_link($row->n_id_b); table_row($cell); } table_end(); // Generate the page trailer. html_trailer(); ?>