Fetch Array Problem

[Ukoku]

Sigh. Once again, my code is having problems. It says my argument is invalid on the "while" line. Does anyone catch the problem?

<?
//login info snipped

if(isset($_POST['mybutt'])) {

$user = $POST['user'];
$pass = $POST['pass'];

$test = "SELECT * FROM login WHERE user==$user, pass==$pass";

while ($myrow = mysql_fetch_array($test)) {

printf("%s,%s,%s",$myrow['user'],$myrow['pass'],$myrow['logged']);

}

}

?>

[kilbey1]

Try this out:

//login info snipped 

if(isset($_POST['mybutt'])) { 

$user = $_POST['user']; 
$pass = $_POST['pass']; 

$test = "SELECT * FROM login WHERE user==$user, pass==$pass"; 

 while ($myrow = mysql_fetch_array($test, MYSQL_ASSOC)) { 

      printf("%s,%s,%s",$myrow['user'],$myrow['pass'],$myrow['logged']); 

      } 

 }

[Ukoku]

Adding the MYSQL_ASSOC? Afraid I did, and it still broke. I also noticed that I forgot the "mysql_query" part of that line... but it still doesn't work. The code is now:

$test = mysql_query("SELECT * FROM login WHERE user==$user, pass==$pass");

while ($myrow = mysql_fetch_array($test, MYSQL_ASSOC)) {

printf("%s,%s,%s",$myrow['user'],$myrow['pass'],$myrow['logged']);

}

EDIT: Ohhh... except I notice something else now... let's try this....

EDIT AGAIN: Crap. Nope. Changed the code to this, and still didn't work:

$test = mysql_query("SELECT * FROM login WHERE user==$user, pass==$pass",$db);

And by the way... changing the $POST lines to $GET lines takes away the errors, but instead I get no output - just a blank page. Sheesh.

[kilbey1]

Well, let's see... here's how I did mine:

if (($login) == "yes")  //  if LOGIN button is submitted, do this
{
	$query = "select * from authenticate where username = '" . $_POST['username'] . "' and password = '" . $_POST['password'] . "';";
	$result = mysql_query($query) or die(mysql_error());

if (mysql_num_rows($result) == 1)
{

while($row=mysql_fetch_array($result, MYSQL_ASSOC)) {
		$fullname = "$row[Firstname] $row[Lastname]";
		echo '<input type="hidden" name="username" value="'.$fullname.'">';
	   //echo "$Firstname $Lastname";
       //}
	}

           echo "Hey, here is the authorized content!";

}
}

Dunno if this will help you get the end result you want...

[Ukoku]

....Nope. Didn't work. And now I'm getting "expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING'" yadda yadda....

Now I'm just messing around with the code. Grr.

[kilbey1]

Would you mind posting the error messages you're getting? That's usually a ; missing, or possibly a typo.

Paste the code again so we can see your latest.

[Ukoku]

The original error message was "invalid argument" on the "while" line.

Now I'm not getting any errors... but I'm just getting a blank page. Here's the updated code.

if(isset($_POST['mybutt'])) {

$user = $GET['user'];
$pass = $GET['pass'];

$test = "SELECT * FROM login WHERE user='$user' AND pass='$pass'";

$grr = mysql_query($test,$db);

while ($myrow = mysql_fetch_array($grr)) {

printf("%s,%s,%s",$myrow["user"],$myrow["pass"],$myrow["logged"]);

}

}

[kilbey1]

Instead of echoing out in the WHILE loop, try some test echoes, ie.

echo "Query: " . $test . "<br>";
echo "Result: " . $grr . "<BR>";
echo "User: " . $user . ", Password: " . $pass;

Just to see what you are, or aren't, pulling back.

[Ukoku]

I revceive the following:

Query: SELECT * FROM login WHERE user='' AND pass=''
Result: Resource id #2
User: , Password:

...I'm not getting anything at all. Am I using the wrong kind of quotes or something...? Hnn....

In the end, I'm not going to display this information anyway.... I'm going to display other information if the USER and PASS are valid. Just FIY.

EDIT: ...and the more I play around with it, it seems like it's not getting any input from the Form at all. It should be user='ukoku' or whatever. Grrrrr.

[Ukoku]

Hit me. Quick. I had the variables still set to $GET instead of $POST. Now I'm getting:

Query: SELECT * FROM login WHERE user=='ukoku' AND pass=='password')
Result:
User: ukoku, Password: password

Well. At least that's working. ^_ Thank you.

...I'll probably be back.