Adam,
You were right, and I'm proud to say that I came up with the
same answer (basically) as you and then your confirmation of
that answer promped me to try out some coding..
Thought I'd define it here for anyone that is interested in the answer.
Like I said, when they fill out the member join form, I update a
field in the transaction record, so this is all I ended up having to
do, at the top of the script, before anything else happens:
$query = "SELECT * FROM transaction_record
WHERE transaction='$invoice' and username=''
";
$result = safe_query($query);
if(!mysql_num_rows($result)){
// Checking for record that hasn't been updated so if I don't get a
// record that means NO empty record exists with that invoice number
// so either the invoice number doesn't exist, or they have
// already joined so record has values
header ("Location: http : // www . the_web_site . com");
}
Otherwise they just drop through and continue the process of joining..
PLUS, the bonus is that it solved another equally as irritating
problem... Now you can't even go directly to the join page and
join without paying, because the same code eliminates that from happening too..
I love it when a plan comes together...
Now if I can just get that session problem figured out, the site will be good to go..
thanks again for your help.
doug