composing a variable

derksj

i've got this code where $row["strCode"] is a letter from a mysql database

i want to make for the letter A an url.
all the following letters dont have to have an url


<table border=1 width=100%>
<td colspan="2" align=left><strong>Legenda</strong></td></tr>';

$UrlA='<a href=www.test.com>';
$UrlB='<a href=>';
$UrlC='<a href=>';
$UrlD='<a href=>';
$UrlE='<a href=>';
$UrlF='<a href=>';
$UrlG='<a href=>';
$UrlH='<a href=>';
$UrlI='<a href=>';
$UrlJ='<a href=>';
$UrlK='<a href=>';
$UrlL='<a href=>';

$result = mssql_query($sql,$connection);
while ($row = mssql_fetch_array($result)) 
{
echo '<tr>';
echo '<td><p align=center>'.$row["strCode"].'</td>';

$url=$Url.$row["strCode"];

echo '<td><p align=left>'.$url.'.'.$row["strCompetence"].'</a></td>';
echo '</tr>';
}
echo '</table>';

help !!

greetings Jurgen

thorpe

please be more specific.

derksj

when $row["strCode"] = A

then i want under the text

echo '<td><p align=left>'.$row["strCompetence"].'</td>';

an url $UrlA

when $row["strCode"] = B

then i want under the text

echo '<td><p align=left>'.$row["strCompetence"].'</td>';

an url $UrlB

etc.

toxic_brain

u r tying to build variable name at runtime

$url=$Url.$row["strCode"];

i don't think it is possible in php.
array will help here.

change

$UrlA='<a href=www.test.com>';
$UrlB='<a href=>';
$UrlC='<a href=>';
$UrlD='<a href=>';
$UrlE='<a href=>';
$UrlF='<a href=>';
$UrlG='<a href=>';
$UrlH='<a href=>';
$UrlI='<a href=>';
$UrlJ='<a href=>';
$UrlK='<a href=>';
$UrlL='<a href=>';

into

$Url[A]='<a href=www.test.com>'; 
$Url[B]='<a href=>'; 
$Url[C]='<a href=>'; 
-------more-----------

and use later as

echo '<td><p align=center>'.$row["strCode"].'</td>';

$url=$Url[.$row["strCode"]];

echo '<td><p align=left>'.$url.'.'.$row["strCompetence"].'</a></td>';

derksj

works great

thank you very much