Help with <a href . . . </a>

[Rob (SA)]

Hi FOlks,

I have this script which deos not work properly when inserting the <a href . . tag

echo '</td>
<td bgcolor="#FFFFFF"><font style="font-size:10px" color="#00008B" face="Arial">';
echo '<option value="'.$row['surname'].', '.$row['name'].'">'.$row['surname'].', '.$row['name'].'</option>';

echo '</td><td align="center" bgcolor="#FFFFFF"><font style="font-size:10px" color="#FF0000" face="Arial">';
echo <a href=$row['email']</a>;

Which is in need of attention.

I would like to know how I can get it to work on the two lines reflected above?

Regards
Rob 

[bluewalrus]

Don't use echos for html...

</td>
<td bgcolor="#FFFFFF"><font style="font-size:10px" color="#00008B" face="Arial">';
<option value="<?php echo $row['surname'].', '.$row['name']; ?>"> <?php echo $row['surname'].', '.$row['name'] ;?></option>
</td><td align="center" bgcolor="#FFFFFF"><font style="font-size:10px" color="#FF0000" face="Arial">
<a href="<?php echo $row['email']; ?>"></a>;

[Rob (SA)]

Hi,

It didnt like the replacement.

Offers a blank screen

[bluewalrus]

</td>
<td bgcolor="#FFFFFF"><font style="font-size:10px" color="#00008B" face="Arial">';
<option value="<?php echo "$row['surname'], $row['name']"; ?>"> <?php echo "$row['surname'], $row['name']" ;?></option>
</td><td align="center" bgcolor="#FFFFFF"><font style="font-size:10px" color="#FF0000" face="Arial">
<a href="<?php echo $row['email']; ?>"><?php echo $row['email']; ?></a>

How about this? Is the database being executed?

[Rob (SA)]

Hi,

Here is the balance of the script.

Can be veiwed at this link

<?php

$connect = mysql_connect("localhost", "e*****", "H********") or

die ("Hey loser, check your server connection.");

mysql_select_db("*****_Members");

$query1="select * from _Form_Nr_2";

$result=mysql_query($query1) or die(mysql_error());

?>
<!--------THIS SECTION CHANGES WHAT THE TABLE LOOKS LIKE------------->

<table border=2 width="85%" bordercolor="#D3E2FE" bordercolorlight="#FFFFFF" bordercolordark="#AFBCDB" style="font-size:12px" cellspacing=0>

<caption><b><font style="font-size:14px" color="#00008B" face="Arial">
MEMBERSHIP DETAILS</font><b><caption>

<tr>

<th bgcolor="#D6D6D8"><b><font style="font-size:11px" color="#00008B" face="Arial">CELL NUMBER</font></b></th>

<th bgcolor="#D6D6D8"><b><font style="font-size:11px" color="#00008B" face="Arial">FULL SURNAME</font></b></th>

<th bgcolor="#D6D6D8"><b><font style="font-size:11px" color="#00008B" face="Arial">EMAIL</font></b></th>



</tr>

<?php

while($row=mysql_fetch_array($result)){


echo '</td><td align="center" bgcolor="#FFFFFF"><font style="font-size:10px" color="#00008B" face="Arial">';
echo $row['cell_phone'];

echo '</td>
<td bgcolor="#FFFFFF"><font style="font-size:10px" color="#00008B" face="Arial">';
echo '<option value="'.$row['surname'].', '.$row['name'].'">'.$row['surname'].', '.$row['name'].'</option>';

echo '</td><td align="center" bgcolor="#FFFFFF"><font style="font-size:10px" color="#FF0000" face="Arial">';
echo $row['email'];

echo "</td></tr>";

if(!isset($counter[$firstNAsAString]))
$counter[$firstNAsAString] = 0;
else
$counter[$firstNAsAString]++;
$last_surname = $row['surname'];

$i++;
echo'</td></tr>';

}

echo "</table>";

?>

[bluewalrus]

How about this

<?php
$connect = mysql_connect("localhost", "e*****", "H********") or
die ("Hey loser, check your server connection.");
mysql_select_db("*****_Members");
$query1="select * from _Form_Nr_2";
$result=mysql_query($query1) or die(mysql_error());
?>
<style type="text/css">
.result_cell{
font-size:10px;
color:#00008B;
font-family:Arial, Helvetica, sans-serif;
}
.head_cell{
background:#D6D6D8;
font-weight:bold;
color:#00008B;
font-family:Arial, Helvetica, sans-serif;
font-size:11px;
}
h1{ 
color:#00008B;
font-family:Arial, Helvetica, sans-serif;
font-size:14px;
}
.c_align{
text-align:center;
}
.back_color {
background:#FFFFFF;
}
.cell_other{
font-size:10px;
color:#FF0000;
font-family:Arial, Helvetica, sans-serif;
}
</style>
<!--------THIS SECTION CHANGES WHAT THE TABLE LOOKS LIKE------------->
<table border=2 width="85%" bordercolor="#D3E2FE" bordercolorlight="#FFFFFF" bordercolordark="#AFBCDB" style="font-size:12px;" cellspacing=0>
<span class="heading">MEMBERSHIP DETAILS</span>
<tr>
<th class="head_cell">CELL NUMBER</th>
<th class="head_cell">FULL SURNAME</th>
<th class="head_cell">EMAIL</th>
</tr>
<?php
while($row=mysql_fetch_array($result)) {
    ?>
    <tr>
    <td class="result_cell c_align">
    <?php echo $row['cell_phone'];?>
    </td>
    <td class="cell_other c_align back_color">
    <option value="<?php echo $row['surname'] . ', ' . $row['name'];?>"><?php echo $row['surname'] . ', ' . $row['name'];?></option>
    </td>
    <td>
    <?php echo $row['email'];?>
    </td></tr>
    <?php
    if(!isset($counter[$firstNAsAString])) {
        $counter[$firstNAsAString] = 0;
    } else {
        $counter[$firstNAsAString]++;
        $last_surname = $row['surname'];
        $i++;
        ?></td></tr>
    <?php
    }
}
?>
</table>

[Rob (SA)]

Thanks will give it a look and get back to you later

Regards
Rob

[Rob (SA)]

Hi,

I have made the changes - we have changed the fonts and colours but not got the effect of <a href . . . .</a>

in that it does not underline the text

result can be seen at www.gnjgf.co.za/stevie/players.php

[boogyman]

don't use tables for layout, see http://howtocreate.co.uk for more information

[bluewalrus]

Oh, haha forgot about that, the link code wasnt in your reposted code. Try this one though:

<?php
$connect = mysql_connect("localhost", "e*****", "H********") or
die ("Hey loser, check your server connection.");
mysql_select_db("*****_Members");
$query1="select * from _Form_Nr_2";
$result=mysql_query($query1) or die(mysql_error());
?>
<style type="text/css">
.result_cell{
font-size:10px;
color:#00008B;
font-family:Arial, Helvetica, sans-serif;
}
.head_cell{
background:#D6D6D8;
font-weight:bold;
color:#00008B;
font-family:Arial, Helvetica, sans-serif;
font-size:11px;
}
h1{ 
color:#00008B;
font-family:Arial, Helvetica, sans-serif;
font-size:14px;
}
.c_align{
text-align:center;
}
.back_color {
background:#FFFFFF;
}
.cell_other{
font-size:10px;
color:#FF0000;
font-family:Arial, Helvetica, sans-serif;
}
</style>
<!--------THIS SECTION CHANGES WHAT THE TABLE LOOKS LIKE------------->
<table border=2 width="85%" bordercolor="#D3E2FE" bordercolorlight="#FFFFFF" bordercolordark="#AFBCDB" style="font-size:12px;" cellspacing=0>
<span class="heading">MEMBERSHIP DETAILS</span>
<tr>
<th class="head_cell">CELL NUMBER</th>
<th class="head_cell">FULL SURNAME</th>
<th class="head_cell">EMAIL</th>
</tr>
<?php
while($row=mysql_fetch_array($result)) {
    ?>
    <tr>
    <td class="result_cell c_align">
    <?php echo $row['cell_phone'];?>
    </td>
    <td class="cell_other c_align back_color">
    <option value="<?php echo $row['surname'] . ', ' . $row['name'];?>"><?php echo $row['surname'] . ', ' . $row['name'];?></option>
    </td>
    <td>
    <a href="mailtto:<?php echo $row['email'];?>"><?php echo $row['email'];?></a>
    </td></tr>
    <?php
    if(!isset($counter[$firstNAsAString])) {
        $counter[$firstNAsAString] = 0;
    } else {
        $counter[$firstNAsAString]++;
        $last_surname = $row['surname'];
        $i++;
        ?></td></tr>
    <?php
    }
}
?>
</table>