Confirm Registration

"; ///////////////////////////////////////////////////////////////////////////////////////// //database connection ///////////////////////////////////////////////////////////////////////////////////////// $db_name = "workshop2013"; $table_name = "audit2016"; $connection = @odbc_connect ("$db_name", "guppy", "guppy") or die("Couldn't connect."); //lets insert the new row into the database. $sql = "select * from $table_name ORDER BY lastname "; $result = odbc_do($connection, $sql) or die("Couldn't execute query 1."); $num_rows33 = odbc_num_rows($result); while ($row = odbc_fetch_row($result)){ $firstname = odbc_result($result, firstname); $lastname = odbc_result($result, lastname); $state = odbc_result($result, state); $xdate = odbc_result($result, xdate); $current_time=date("n/d/y"); if ($current_time == "$xdate"){ echo "
"; }else{ echo "
"; } $num_rows = $num_rows +1; } echo "
Last Name First Name Jurisdiction
$lastname $firstname $state
$lastname $firstname $state
"; echo "

$num_rows

"; ?>