Altering exisiting php/mysql data

tenaki

Hi I hope this is the right place as I am getting confused.

I have an existing php/mysql review programme.

One of the fields is configerable and I have it set as an email address, the only problem is you cant click it open up an email client you have to copy and paste it. I want to output the email to a web page with a clickable email addy

Can I use this configerable field and then find it in the php files and add a code snippet there or do I need to alter the sql as well?

Any advice/code to a novice would be appreciated

mrhappiness

let's assume the column in your table holding the mail-adresses is called "various"

$sql='SELECT various FROM table';
$r=mysql_query($sql);
while($row=mysql_fetch_assoc($r))
  echo '<a href="mailto:'.$row['various'].'">'.$row['various'].'</a>';

did you mean it like this?

tenaki

Sorry I had to edit,

Would I then edit the row in sql and insert that

mrhappiness

no, you don't change the existing data, you do it within the script that actually put's out the mail adress as normal text

tenaki

Yes I can see that now thank you.

This is what I have that I think! I need to change the "includes" folder called "functions.php"

Original:

if ( $config_field_5 != "" ){if ( $field_1 == true ){echo "&nbsp;|&nbsp;";}echo "<b>" . $config_field_5 . "</b>";$field_1 = true;}

This is the revised one:

if ( $config_field_5 != "" ){if ( $field_1 == true ){echo '<a href="mailto:'.$row['$config_field_5'].'">'.$row['$config_field_5'].'</a>';}echo "<b>" . $config_field_5 . "</b>";$field_1 = true;}

Would that work?