how to make link that pulls spec recor

[kappaluppa]

i made a table with hyperlinks. I want the hyperlink to not only go to another page, but also to get only certain records from a database and displays them on a page.

Will this work?
<a href="../mainlist2.php3?mysql_query("SELECT field1 FROM table WHERE field2 = 'value'"><b>2001 Session Progress</b></a><br>

[Anon]

no, that will not work... you will have to put a while loop in in, to make different variables.. maybe like this (made the field name up..just to make it clear):

<?
$sql=mysql_query("SELECT field1 FROM table WHERE field2 = 'value'")
while ($row=mysql_fetch_array($sql))
{
$name=$row[name];
}
echo"<a href='../mainlist2.php3?$name'>2001 Session Progress</a><br>";
?>

you might give that a try..

[Anon]

I don't think that's going to work as a URL. What I would suggest (note, I'm working with VERY limited experience here), is that you have the query built in to the page the link is going to, and just pass the variable bits via URL.

Ie: <a href="../mainlist2.php?value=variablePassedFromPage">2001 Session Progress</A>

And the query on the page would read something like ...

mysql_query("SELECT field1 FROM table WHERE field2 = '$value'");

I may be missing the subject altogether though.

-9mm-

[amsowe]

I might be missing the general idea,but..
what about sessions?

[[deleted]]

What about them? 🙂