Your SELECT statement is returning way more rows than you expect, I think,
since it will return the number of users times the number of members minus
however many there are that have the same id...
I don't think you wanted that...
I suspect you want a sub-select where you don't get any users who are
members, or maybe no members who are users...
MySQL *might* let you do:
select ... from members where not id in (select id from users)
OTOH, I don't really understand what you are trying to do in the first
place, but I suspect there's a much easier way to do it...
--
WARNING [EMAIL PROTECTED] address is an endangered species -- Use
[EMAIL PROTECTED]
Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm
Volunteer a little time: http://chatmusic.com/volunteer.htm
----- Original Message -----
From: Syaggie <[EMAIL PROTECTED]>
Newsgroups: php.general
To: <[EMAIL PROTECTED]>
Sent: Saturday, September 01, 2001 8:26 AM
Subject: loop? or conditional problem
> Okay the the script is attached below. i am baffled at the problem. as
you
> can see the script does a rather simplistic generation of passwords. it
> then writes them into two files.
>
> the problem is the first time i run (i am running it stand alone) it
works
> fine and the result is two files with 32 entries (and the mysql entries
are
> also correct). the second time i run it. i (there should be 44 new
entries
> make one file with 76 entries and another with 44)
>
> however what i get is a file with 1233 entries and another with 1201.
>
> now i admit the code is not beautiful but my concern is more of what is
> causing this. i have checked the variables both $i and $rows appear fine.
>
> when i look at the text files what i see is it assigns the 44 entries and
> then repeats them. all i can figure is it is the conditional or whiel
loop?
> why does it work perfect the first time??
>
>
> <?php
> mysql_connect("localhost:/var/run/mysql/mysql.sock");
> mysql_select_db("VQRGDATA");
> $letter = array("Gob", "Lol", "woZ", "Kop", "MoS", "tRu", "SAw", "NoR",
> "TEf","TaF", "JoP", "lOg", "tAn", "FiSH", "cAT", "VAn", "bAb", "Mob",
> "KorN", "BeAt", "roSe", "KlaP", "iZ", "GEr", "HaT", "ZaaM", "toAd",
"emU");
> $results = mysql_query("SELECT members.id, members.lname FROM members,
users
> WHERE users.id <> members.id");
> $rows= mysql_num_rows($results);
> if($rows != 0)
> {
> while($info = mysql_fetch_array($results))
> {
> if($info[0] != 0)
> {
> $ids[] = $info[0];
> $lnames[] = $info[1];
> }
> }
> mysql_free_result($results);
> $i=0;
> while($i < $rows-1)
> {
> srand((double) microtime() * 1000000);
> $pass_letter_key = array_rand($letter);
> srand((double) microtime() * 1000000);
> $pass_num1 = mt_rand(0, 26);
> srand((double) microtime() * 1000000);
> $pass_num2 = mt_rand(100, 926);
> $strip = trim($lnames[$i]);
> $lower = strtolower($strip);
> $infochop = substr($lower, -5, 4);
> $username = $infochop.$pass_num2;
> $password = $pass_num1. $letter[$pass_letter_key].$pass_num2;
> $respass = mysql_query("SELECT password FROM users WHERE
> password='$password'");
> $pass_row = mysql_num_rows($respass);
> if(!$pass_row)
> {
> mysql_query("INSERT INTO users(id, username,password) VALUES('$ids[$i]',
> '$username', '$password') ");
> $complete = fopen("complete.txt", "a+");
> $input[] = $ids[$i]."\t".$username."\t".$password."\n";
> fputs($complete, $input[$i]);
> fclose($complete);
> $i++;
> }
> mysql_free_result($respass);
>
> }
> }
> $new = implode("", $input);
> $newtxt = fopen("new.txt", "w");
> fputs($newtxt, $new);
> fclose($newtxt);
> ?>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
