Jump to content

dlan1

New Members
  • Posts

    5
  • Joined

  • Last visited

Profile Information

  • Gender
    Not Telling

dlan1's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Ok, sorry, I guess I didn't understand what was being said about white spaces, and yes that was the problem. As I went back and looked at the file I dumped and there they were. I didn't mean to be a thick head. Thanks for putting up with me. Don...
  2. I've tried cut and paste, I've tried typing the email into the myphpAdmin statement. Nothing works. It seems that your saying what I've got should work. I think my next step is file a ticket with BlueHost.com (they host the site) and see if the problem is with something on their end. Thanks for your time... Don
  3. Anybody have any thoughts on this? I've been playing with this for days now and I keep coming up with the same results. I created a new DB dumped the table from the old one and inserted it into new DB Tried query directly in phpMyadim SQL using the statment SELECT email_address FROM users WHERE email_address = 'me@you.com' where 'me@you' is replaced with emails cut directly from a browse listing. Again some emails will show a result and some will show zero return. It makes no sense to me and I'm out of ideas or things to try.
  4. This started when I received an email saying that someone could not log-in. They were a message Account not active. I looked in DB file and it should have been ok.. FYI, the site is ohioeuchre.com I've been testing using a page that just lists all members. If I select using 'userID' it will show the complete list. however if I Cut+P directly from a membership list, ( using the WHERE email_address statement ) sometimes it will work and somedtimes not. This page and the actual that is used in the membership program(chenckuser.php) both do the same thing. some thing will work some won't. I may have been wrong with the 74 number. This morming I found some higher records that it would find.. The php error log show nothing This is the test page: <?php // Connection to the database include 'inc/db_connect.php'; //$sql="SELECT * FROM users ORDER BY userid"; $sql="SELECT * FROM users WHERE email_address = 'me@you.com' "; $result=mysql_query($sql); // Start of html that is displayed ?> <div align="center"> <div id="textbox"> <h2>OhioEuchre.Com Membership List</h2><br> <table border="1" cellpadding="3" cellspacing="1"> <?$num = 0;?> <tr bgcolor="<?=(++$num%2==0 ? "#E6D78E" : "#dcc55d")?>"> <td align="center" width="20"><strong>Count</strong></td> <td align="center" width="20"><strong>ID #</strong></td> <td align="center" width="60"><strong> First Name</strong></td> <td align="center" width="120"><strong>Email</strong></td> <td align="center" width="20"><strong>Zip Code</strong></td> <td align="center" width="20"><strong>Activated</strong></td> <td align="center" width="20"><strong>Password</strong></td> </tr> <?php $Count = 1; while($rows=mysql_fetch_array($result)){ ?> <tr bgcolor="<?=(++$num%2==0 ? "#E6D78E" : "#dcc55d")?>"> <td align="center"><? echo $Count++; ?></td> <td align="center"><? echo $rows['userid']; ?></td> <td align="left"><? echo $rows['first_name']; ?></td> <td align="center"><? echo $rows['email_address']; ?></td> <td align="center"><? echo $rows['zipcode']; ?></td> <td align="center"><? echo $rows['activated']; ?></td> <td align="center"><? echo $rows['password']; ?></td> </tr> <?php } ?> </table> END OF TEST PAGE.................
  5. I am using a simple membership on my site. I'm a cut and paste expert not a programer. I was able to get it working, It worked fine till I got over 100 members. Now it is only finding the first 74 So if I use; $sql="SELECT * FROM users WHERE email_address = 'me@you.com' "; It will only find me@you.com if it is one of the first 74 records. I'm sure there is something I don't know that is causeing the problem, Just don't know what. If someone could point me to the right direction I'd be greatfull. Thanks, Don.. MySQL 5.5CREATE TABLE IF NOT EXISTS `users` ( `userid` int(10) NOT NULL AUTO_INCREMENT, `first_name` varchar(25) NOT NULL DEFAULT '', `last_name` varchar(25) NOT NULL DEFAULT '', `email_address` varchar(45) NOT NULL, `password` varchar(10) NOT NULL DEFAULT '', `zipcode` varchar(11) NOT NULL, `user_level` enum('0','1','2','3') NOT NULL DEFAULT '0', `signup_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_login` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `activated` enum('0','1') NOT NULL DEFAULT '0', `userIP` varchar(20) NOT NULL, PRIMARY KEY (`userid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Membership Information' AUTO_INCREMENT=115 ;
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.