[DetroitGuy]

Alright. Having a problem here.

On one page, I am polling my database for an email address and adding it to a hidden form field:

PHP Code:

<form name=\"approve\" method=\"post\" action=\"next.php\">

<input name=\"email\" type=\"hidden\" value=\"$qry[email]\">

<input name=\"id\" type=\"hidden\" value=\"$qry[id]\">

<input type=\"submit\" name=\"Submit\" value=\"Submit\">

</form> 

On the next page, I am trying to process it.

PHP Code:

$query = mysql_db_query($database, "SELECT * FROM $table WHERE email = '".$_POST['email']."' & id = '".$_POST['id']."'");

$qry = mysql_fetch_array($query); 

As you can see from the above, I am generating the form based on the contents of the database. The problem is that when I get to the second page, the only email address that is showing up is the first email address on the list.

For instance, as there were three forms generated:

email: john@doe.com - id: 1
email: jane@doe.com - id: 2
email: joe@doe.com - id: 1

I am only getting the first email address. Where the second email address should be, it's returning nothing. Where the third email address should be, I am getting the first email again.

Anyone know what's going wrong?

Thanks in advance.

NOTE: In the first code snippet, the first \ is missing although I have it in the code. Odd.

[Keith]

Probably not a solution, but in your query statement, & should be && or AND.

[DetroitGuy]

Oh my goodness. I swear that it is always those things that I miss. That was it exactly. Thanks Keith. I need to start looking more carfully before I post.