Help Me Pls! :(

Anon

Hello,

I've been coding PHP for a while now and have never run into this problem. PLEASE help me out...I have a pretty good site goin but this code is the 'backbone' of it, and it isn't working!

Here is the problem...

I have a referral system for my site. When sombody signs up their referrer code is entered into the 'referrer' field of my MySQL db. This works fine.

Then when their referrer logs into their account, I execute a PHP script which finds all of the places where their referrer code is in the db and counts them up to give a referral total. This worked fine until last night. For some reason, many of my members reported that their referral totals show '0' when they log-in. Their referral code is still in the db the same number of times as it was last night, but now their stats page reads '0' instead of, say, 17 (if their ref code showed up 17 times in the db).

Do any of you have ANY idea why this would happen?

If I go to my phpMyAdmin page I can manually edit the records so they work. I can just click 'Edit' and then 'Go' on a record, and then my login script will detect the presence of the referrer code. It is the same record as before, but it works after I have "Edited" it (even though I didn't change anything).

PLEASE give me some ideas as why this would happen and hopefully a way to correct it.

I can give you the code I am using if you want, but I think I have explained the problem pretty well.

Thanks so much!
Barry

Anon

What type of field is 'referrer'? You said you are storing a number, is it a integer field or a varchar? It sounds like perhaps the number is being treated as an integer when it is actually stored as a string. Post the code.

Anon

Thanks for the reply...

It is stored as a varchar and the referrer code is just the referrer's email address...

Here is how it is stored...

$sql = "INSERT INTO table (email,password,referrer,flagged,IP) VALUES ('$email','$password','$ref','$flag','$ip')";

$result = mysql_query($sql);

Here is how it is retrieved...

$n=0;

$res=mysql_query("SELECT * FROM table WHERE referrer='$email'",$db);

while($rowb=mysql_fetch_array($res))
{
$r=$rowb['referrer'];
$n++;
}

I took out all of the code that doesn't matter...

Please help me out...

Thanks again,
Barry

Anon

Is it possible that the table I'm looking through is too large? I have 16000 rows in the table I'm looking through. I have another site on the same server using the same script and it is working fine...That table only has 7500 rows...Could this be the problem?

Thanks again,
Barry