[RESOLVED] dynamic link in display.php

StevenB

I am working through a few tutorials. I have managed to create dbupload.php, display.php, and edit.php. I'm now trying to link the display.php to the edit.php dynamicly via the UID field.

Here's my latest failed attempt :

print ("<td>" . $row '<a href="' . $row['http://www.mysite.net/edit.php?<?php UID ?>'] . $row['UID'] . "</a>" . "</td>");

I'm really a noob, hope that makes sense.

Another question I have that will really show my ignorance is "print" or "echo"? How do I determine when to use wich?

Thanks for any help!

Steve

thepeccavi

SEVERAL code errors:

print ('<td>' . $row . '<a href="' . $row['http://www.mysite.net/edit.php?UID'] . $row['UID'] . "</a>" . "</td>");

there tahta shoukld sort it!

thorpe

Surely you dont havea filed in your database called http://www.mysite.net/edit.php?UID.Try...

echo '<td><a href="http://www.mysite.net/edit.php?UID='.$row['UID'].'">'.$row['UID'].'</a></td>';

StevenB

Sorry Thorpe, I haven't tried your suggestion yet. When thepeccavi suggestion didn't work I tried rewritting from another angle and just returned to see your post. After a couple of hundred attempts I came up with this (works beautifuly):

<?php
include 'opendb.php';
$query = mysql_query("SELECT * FROM Users");
mysql_close();
// if > 0 rows are returned
if(mysql_num_rows($query))
{
    while ($row = mysql_fetch_array($query))
    {         //table layout for results
    echo '<a href="' . 'http://www.mysite.net/' . 'edit.php?UID=' . $row['UID'] . '">' . $row['UID'] . '</a>' . '<br />'; 
} 
    }
?>

Very similar to what you suggested, but for some reason if I tried this:

echo '<td><a href="http://www.mysite.net/edit.php?UID='.$row['UID']. etc..

It only linked to http://www.mysite.net/ , strange but true!

Anyway Thanks to everyone for helping out a noob! Will call this one resolved!

Steve