use results from db search in new file

[Bazzaah]

Hi

 

I have a small problem and would be grateful for some help please.

 

I've been working on an audio dictionary.

 

The dictionary contains a search function;

 

$result = mysql_query("SELECT word,sentence1 FROM pro_words WHERE word LIKE '%$search%'");

 

The results from the search are displayed as links to a new file.

 

echo '<tr><td align="left"><a href="word.php?w=' . $r['word'] . '">' . $r['word'] . '</a></td></tr>';

 

Is there a way I can get the file word.php to include other information from the database entry, for example sentence1?

 

I've been puzzling over this and haven't found a way to make it work, even though it seems like it should be straightforward.

 

Hope the question is clear and thanks in advance for any help.

[litebearer]

psuedo code

 

start sessions

do the search (presuming only one record returned)

put the results (the field contents) into session variables

link to the new page

---

(new page)

start sessions

get the session variables

display as you choose

 

 

make sense?

 

[Bazzaah]

In principle. yes it does. Thank you.