Hi Ray - quickie - i got the same problem as above with paramrandomString problem i think - may bne due to me making small update to userconfirm page and overwriting what you changed i think - i'm just not sure whether i should be changing the instance on line 39 to lower case or vice versa - i presume its the code here from 39-52 that needs to be in sync
$paramrandomstring_rsVerify = "1";
if (isset($_GET['randomstring'])) {
$paramrandomstring_rsVerify = $_GET['randomstring'];
}
$paramemail_rsVerify = "1";
if (isset($_GET['email'])) {
$paramemail_rsVerify = $_GET['email'];
}
mysql_select_db($database_fhcdbase, $fhcdbase);
$query_rsVerify = sprintf("SELECT * FROM users WHERE UserID = %s AND users.randomString = %s AND users.UserEmail = %s AND users.randomString <> '0'", GetSQLValueString($colname_rsVerify, "int"),GetSQLValueString($paramrandomString_rsVerify, "text"),GetSQLValueString($paramemail_rsVerify, "text"));
$rsVerify = mysql_query($query_rsVerify, $fhcdbase) or die(mysql_error());
$row_rsVerify = mysql_fetch_assoc($rsVerify);
$totalRows_rsVerify = mysql_num_rows($rsVerify);?>
<?php
which lines do i change?!