How to create a link

[zed420]

Hi All

I wonder if you can help me.  I'm trying to make the table results as a link to a different page but I can't make head or tail of it. Here's my code, I 'm trying to make [itemDes] as a link to a different page, how do I do it  ????

 

function ItemDisplay (){ 

$query = "SELECT * FROM itemtb  ORDER BY id";

$result = mysql_query($query)

or die ("Couldn't execute query for collecting your data.");

 

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

    extract($row);

echo ("<tr align=center>\n");

$a = $ItemType.$id; 

echo "<td>$a</td>";

echo "<td align=center>$row[itemName]</td>\n";

echo "<td align=center>$row[itemDes]</td>\n";

echo "<td align=center>$row[itemPrice]</td>\n";

echo "<td align=center>$row[date]</td>";

echo "</tr>";

}

echo "</table>\n";

echo "</form><br>\n";

}

 

[sasa]

change

echo "<td align=center>$row[itemDes]</td>\n";

to

echo "<td align=center><a href='link_to_diferent_page'>$row[itemDes]</a></td>\n";

[dezkit]

Why does it say

         echo "</form>

 

at the end?

 

 

 

[DeanWhitehouse]

to make the code look nicer and just a helpfull tip, you can have the whole form in one echo instead of seperate lines

[zed420]

to make the code look nicer and just a helpfull tip, you can have the whole form in one echo instead of seperate lines

 

Thanks blue much appreciated.

[zed420]

change

echo "<td align=center>$row[itemDes]</td>\n";

to

echo "<td align=center><a href='link_to_diferent_page'>$row[itemDes]</a></td>\n";

 

It works,  Thanks mate I really thought It'll be much complex than this.  Thanks again

[zed420]

Why does it say

         echo "</form>

 

at the end?

 

 

 

 

It's a mistake, thanks for point it out.