Creating dynamic links

Anon

Hi, I have queried my database to find relevant conditions, and these conditions are listed on a web page as necessary. I have used the following code to do this:

$cond_query = "select c.Condition
from Conditions c, Temp t
where c.Condition_no = t.Condition
group by c.Condition_no
order by c.Condition";

$cond_result = mysql_query($cond_query);

$num_results = mysql_num_rows($cond_result);

for ($i=0; $i <$num_results; $i++)
{
$row = mysql_fetch_array($cond_result);
echo "<divalign='left'><p><strong>".($i+1).". </strong>";
echo htmlspecialchars (stripslashes($row["Condition"]));
echo "</p><div>";
}

The trouble I have now is that I need every condition that is echoed to have a link to a page called description.php, where a description will be displayed relevant to the condition selected. The sql statement to get the description is:

$desc_query = "select Description
from Conditions
where Description =
selected link";

What do I need to do to create these links and to complete the sql statement to echo the appropriate condition description.

Please help!!

Thanks, Sarah

Anon

Dynamic linking:

Example.
$query = select * from mytable;
$result = mysql_query($query);
while($data = mysql_fetch_object($result)){

echo "<a href=description.php>$data->FieldName</a>";
}

Then you may use HTTP_GET_VARS, to get the value of search link to transfer to description.php so that you can write your query.

Solomon

Anon

You need some way of uniquely identifying a row in the database, and include that in your first SELECT. Maybe 'Condition' will do; that's a matter between you and your db.

With that unique identifier in hand - I'll call it "id" - the stuff you echo can look like

echo "<div align='left'><p><strong>".($i+1).". </strong>";
echo "<a href='description.php?id=".urlencode($row["id"])."'>"
echo htmlspecialchars (stripslashes($row["Condition"]));
echo "</a></p></div>";

Then on description.php you have a query
"SELECT description from Conditions where id=".$HTTP_GET_VARS['id'];

Anon

Hi again, this has helped a lot, many thanks to both Grumbler and Solomon. One more little piece of help needed though. Grumbler suggested using this sql statement:

"select Description from Conditions
where Condition=".$HTTP_GET_VARS['id'];

This seems to be producing an error though, and i am really unsure as to why. If Grumbler or anyone else could make any suggestions i would be grateful.

Thanks

Anon

Sorry, I actually wrote the statement slightly wrong, here it is again:

"select Description from Conditions
where id=".$HTTP_GET_VARS['id'];

Cheers

Anon

What's the error message? Is it PHP or MySQL that's having trouble?

Anon

It was a problem with the database, but I have it sorted now. Thanks for your help.

Sarah

Anon

You're welcome.