check the ID column agains the directoryid session variable.
Thank You.
I am unsure how to edit the recordset on the verifiy listing page and add an additional where clause to check the ID column against the directoryid session variable.
I think I am doing it somewhat as it passes the correct user id and content into the form. But I am not understanding how this works.
I am working on the attached accounts/verifyListingFW.php file
Line # 4
Line #59
<?php
$Paramid_WADAtbl_directorylistings = "-1";
if (isset($_GET['id'])) {
$Paramid_WADAtbl_directorylistings = $_GET['id'];
}
mysql_select_db($database_community, $community);
$query_WADAtbl_directorylistings = sprintf("SELECT id, businessname, firstname, lastname, email, city, fldstate, userid, userpassword, verifieddate FROM tbl_directorylistings WHERE id = %s", GetSQLValueString($Paramid_WADAtbl_directorylistings, "-1"));
$WADAtbl_directorylistings = mysql_query($query_WADAtbl_directorylistings, $community) or die(mysql_error());
$row_WADAtbl_directorylistings = mysql_fetch_assoc($WADAtbl_directorylistings);
$totalRows_WADAtbl_directorylistings = mysql_num_rows($WADAtbl_directorylistings);
?>