code to hide email address

[debber]

I created a form that sends the results to MySQL, then displays them on a page.

I am trying to figure out how to write code so that the email address will only be displayed if the user has selected "yes" and have it remain hidden if they select "no". (Like what happens when registering here)

I have tried various things, but being a newbie, I can't get anything to work. Any help is appreciated!

--- part of the form code:

<form method="post" action="<?php echo $PHP_SELF?>">

<input type=hidden name="id" value="<?php echo $row["id"] ?>">
<tr><th align="left">Email:</th><td><input type="Text" name="mail" size="60" maxlength="60" value="<?php echo $row["mail"] ?>"></td></tr>
<tr><th align="left">
Display email address?:</th><td><select name="display" value="<?php echo $row["display"] ?>"><option value="yes">Yes</option>
<option value="no">No</option></select> </td></tr>

----- part of the display code

echo "<tr bgcolor=#ffffff align=left>";
echo "<th>Date</th><td>$row[fdate] $row[half_day] $row[timezone]</td>";
echo "<th>Name</th><td>$row[firstname] $row[lastname] $row[mail]</td>";
echo "</tr>";

Thanks!

debber

[bastien]

to hold the value of send/don't send...

then when calling the data associated with the user check for this variable and set the email accordingly

<?

//get user info

$sql="select * from user_table where id=$userID";

$result=mysql_query($sql);

while ($row=mysql_fetch_array)){
//assign values to easy to use variables
$name=$row['name'];
$email=$row['mail'];
$send_email=$row['display'];

[b]//check the value of the display column in the table

//if YES then show the users email else show nothing[/b]
if ($send_email=="Yes"){
$the_email=$email;
}else{
$the_email="";
}

echo "<tr bgcolor=#ffffff align=left><th>Date</th> <td>$row [fdate] $row[half_day] $row[timezone]</td>
<th>Name</th><td>$row[firstname] $row[lastname] $the_email</td>
</tr>";

?>

hth

[debber]

Thanks for taking the time to help, but now I am more confused.

Besides getting parse errors, I don't really understand what's happening.

My code has a total of 2 variables- 1 variable and 1 variable with 2 values:

$row["mail"]
$row["display"] <option value="yes"><option value="no">

The solution introduces 5 new variables and I am not sure how they relate to the above variables or if they are entirely separate:

$name=$row['name'];
$email=$row['email'];
$send_email=$row['send_email'];

if ($send_email=="Y"){
$the_email=$email;
}else{
$the_email="";

//rest of code to send email and set values...

Huh?

Thanks again!

Debber

[debber]

FYI: All I needed to do to make it work was:

if ($row[display]=='no')

{
$row[mail]=$row["nbsp;"];
}

The simpler the better

😉

[jerdo]

That's essentially what bastien told you to do, he just included surrounding code so you wouldn't get too confused by the answer.

[Pl_yer]

I will explain it without code. It works this way

Put the email in a variable
$temp_email=$row['send_email'];

IF the user chooses "YES", his email may be shown.
--> display the email ($temp_email)
ELSE user choosed "NO"
--> put nothing in the temp variable: $temp_email="";
--> Display $temp_email

I hope you get it now???

:confused: 

greetz
<$Player>