If Statement

Anon

Im trying to create a link from a if statement within a table but it dosent like it any Ideas. I have clients on the database as an integra 1 or 0

<td width=\"70\">
if ($myrow["Member"]) {
echo "<a href=\"client.php3?id=" . $myrow["ID"] . "\">visit</a>";
else {
echo "<a href=\"non_client.php3?id=" . $myrow["ID"] . "\">visit</a></td></tr>";
}</td>

Thanks

Anon

You're missing a closing curly bracket on the if(){} statement...

a
d
a
m

Anon

I have put this but still dosen't work

<td width=\"70\">
if ($myrow["Member"]) {echo "<a href=\"client.php3?id=" . $myrow["ID"] . "\">visit</a>"};
else {echo "<a href=\"non_client.php3?id=" . $myrow["ID"] . "\">visit</a>"}</td></tr>";}</td>

Where am I going wrong

Anon

As far as I can see you have some mistakes:
1. There's no <? and ?> to mark the PHP code, so maybe it's not parsing the PHP code in it or you are having errors trying to parse <td width=\"70\">
and </td> ... maybe is a typo in the way you wrote the code in your message.

There's a semicolon on the wrong place and another missing things, the code should read:

If the name of your script is .html

echo "<TR>";
echo "<td width='70'>";
if ($myrow["Member"]) {
echo "<a href='client.php3?id=".$myrow['ID'] . "'>visit</a>";
}
else {
echo "<a href='non_client.php3?id=" . $myrow['ID'] . "'>visit</a>";
}
echo "</td></tr>";

A slimer way to write it would be without {}:

echo "<TR><TD WIDTH='70'>";
if ($myrow["Member"]) echo "<a href='client.php3?id=".$myrow['ID']."'>visit</a>";
else echo "<a href='non_client.php3?id=".$myrow['ID']."'>visit</a>";
echo "</td></tr>";

Hope it helps

Mr Aghhh wrote:

I have put this but still dosen't work

Where am I going wrong

Anon

No here it is in full

And yes its within <?php ?> tags and also contains the database tags etc etc

echo("<table width=\"700\" border=\"0\" align=\"center\">
<tr>
<td width=\"100\">" . $myrow["area"] . "</td>
<td width=\"150\">" . $myrow["name"] . "</td>
<td width=\"250\">" . $myrow["text"] . "</td>
<td width=\"70\">
if ($myrow["Member"]) echo "<a href='client.php3?id=".$myrow['ID']."'>visit</a>";
else echo "<a href='non_client.php3?id=".$myrow['ID']."'>visit</a>";</td>
</tr></table>");
}
mysql_free_result($result);

Its not passing the IF statemenbt at all ????

Anon

Try this:
echo("<table width=\"700\" border=\"0\" align=\"center\">");
print "<tr>";
print "<td width=\"100\">" . $myrow["area"] . "</td>";
print "<td width=\"150\">" . $myrow["name"] . "</td>";
print "<td width=\"250\">" . $myrow["text"] . "</td>";
print "<td width=\"70\">";

if ($myrow["Member"]) {
echo "<a href='client.php3?id=".$myrow['ID']."'>visit</a>";
}

else { echo "<a href='non_client.php3?id=".$myrow['ID']."'>visit</a>";</td>
</tr></table>");
}

mysql_free_result($result);