MySQL Inserting email field

tenaki · #1 (**permalink**) 03-14-2004, 09:46 AM

Hi I have a php/mysql database I have added a field for email but it is not clickable.

One of the standard fields is for URLs and this clicks through.

How can I make my email field clickable.

I have limited sql knowledge but I can find my way around using phpMyAdmin

Any ideas?

blastradius · #2 (**permalink**) 03-15-2004, 07:34 PM

Are you wanting to be able output the email to a web page with a clickable email or you wanting to be able to have a clickable email within the gui of an mySQL addon.

I'm not sure of the later might depend on the gui program you downloaded. But the first can be done by putting the email address in a the field.

then write that field into the middle on the your a tag. ie >email me

tenaki · #3 (**permalink**) 03-16-2004, 05:31 AM

Hi yes I want to output the email to a web page

The programme is a review programme and the following is an example

Review
Name joe blog
address blog street
URL. www.blog.com (this clicks through to the website)
email: joeblog@blog.com (this I want clickable)

tenaki · #4 (**permalink**) 03-16-2004, 07:07 AM

Code:

"; if ( $config_field_1 != "" ) { echo "" . $config_field_1 . ""; $field_1 = true; }

Where would the following go?

Code:

<a href=mailto:<?php echo $email ?>>email me

Or am I on the wrong track totally

blastradius · #5 (**permalink**) 03-17-2004, 06:47 PM

I'm not sure of all you are testing for. But lets say $config_field1 is your email field in the database

if ( $config_field_1 != "" );
{echo "<a href=mailto" $config_field_1 ">email me</a>

I use PHP very little so my syntax maybe a little off but the logic is correct

Nargule · #6 (**permalink**) 04-05-2004, 05:49 AM

Quote:

Originally Posted by blastradius

I'm not sure of all you are testing for. But lets say $config_field1 is your email field in the database

Code:

if ( $config_field_1 != "" ); 
    {echo "<a href=mailto" $config_field_1 ">email me</a>

I use PHP very little so my syntax maybe a little off but the logic is correct

Whoa! That syntax threw the forum for a loop.

You ought to be able just to do this:

Code:

if ($config_field_1 != "")
{
  echo "<a href=mailto:$config_field_1>$config_field_1</a>";
  $field_1 = true;
}

PHP will deal with the variable in the double quotes.

p.s. I'm not sure what the if ($config_field_1 != "") is all about, just use if ($config_field_1) instead.

tenaki · #7 (**permalink**) 04-06-2004, 05:45 PM

This is a link to the page which shows the email address as text.

The config_field" is a field that either myself or a member can fill in.

I believe that it is configerable to allow it to show as a search option or not.

I am starting to wonder if it would be better just to make a new field?

http://www.touringandtenting.com/cam...sub_cat_id=153