hyperlink from query result possible?

In a database about houses I want visitors to type in an address,
whereupon they get information about that address. In a lot of cases
the result is a table generated by a query.
Is there a way of constructing an hyperlink from the items in the
table, so that the reader is directed to more information about the
address he wants to know more about?
So, if the resulting table looks like
Item, address, building year
1, Apple street 5, 1603
2. Apple street 8, 1960,
3. Berry road 105, 1750
etc.
and the visitor wants to know more about the house on Berry road, I
can direct him to a page completely devoted to that house.
Onno

Re: hyperlink from query result possible?

Anne Bos wrote:

> In a database about houses I want visitors to type in an address,
> whereupon they get information about that address. In a lot of cases
> the result is a table generated by a query.
> Is there a way of constructing an hyperlink from the items in the
> table, so that the reader is directed to more information about the
> address he wants to know more about?
> So, if the resulting table looks like
> Item, address, building year
> 1, Apple street 5, 1603
> 2. Apple street 8, 1960,
> 3. Berry road 105, 1750
> etc.
> and the visitor wants to know more about the house on Berry road, I
> can direct him to a page completely devoted to that house.
> Onno

Yes, just construct the hyperlink in your php code.

Re: hyperlink from query result possible?

On 5 Jan 2007 03:55:46 -0800 wrote "Captain Paralytic"
:

>
>Anne Bos wrote:
>
>> In a database about houses I want visitors to type in an address,
>> whereupon they get information about that address. In a lot of cases
>> the result is a table generated by a query.
>> Is there a way of constructing an hyperlink from the items in the
>> table, so that the reader is directed to more information about the
>> address he wants to know more about?
>> So, if the resulting table looks like
>> Item, address, building year
>> 1, Apple street 5, 1603
>> 2. Apple street 8, 1960,
>> 3. Berry road 105, 1750
>> etc.
>> and the visitor wants to know more about the house on Berry road, I
>> can direct him to a page completely devoted to that house.
>> Onno
>
>Yes, just construct the hyperlink in your php code.

That php code is
{echo $row[$i];}
I hardly can imagine this works, but I'll try

Re: hyperlink from query result possible?

Anne Bos wrote:
> On 5 Jan 2007 03:55:46 -0800 wrote "Captain Paralytic"
> :
>
>> Anne Bos wrote:
>>
>>> In a database about houses I want visitors to type in an address,
>>> whereupon they get information about that address. In a lot of cases
>>> the result is a table generated by a query.
>>> Is there a way of constructing an hyperlink from the items in the
>>> table, so that the reader is directed to more information about the
>>> address he wants to know more about?
>>> So, if the resulting table looks like
>>> Item, address, building year
>>> 1, Apple street 5, 1603
>>> 2. Apple street 8, 1960,
>>> 3. Berry road 105, 1750
>>> etc.
>>> and the visitor wants to know more about the house on Berry road, I
>>> can direct him to a page completely devoted to that house.
>>> Onno
>> Yes, just construct the hyperlink in your php code.
>
> That php code is
> {echo $row[$i];}
> I hardly can imagine this works, but I'll try

echo "";

You will get the variable in index.php with $_GET['id']

--

//Aho

Re: hyperlink from query result possible?

On Fri, 05 Jan 2007 15:20:35 +0100 wrote "J.O. Aho"
:

>Anne Bos wrote:
>> On 5 Jan 2007 03:55:46 -0800 wrote "Captain Paralytic"
>> :
>>
>>> Anne Bos wrote:
>>>
>>>> In a database about houses I want visitors to type in an address,
>>>> whereupon they get information about that address. In a lot of cases
>>>> the result is a table generated by a query.
>>>> Is there a way of constructing an hyperlink from the items in the
>>>> table, so that the reader is directed to more information about the
>>>> address he wants to know more about?
>>>> So, if the resulting table looks like
>>>> Item, address, building year
>>>> 1, Apple street 5, 1603
>>>> 2. Apple street 8, 1960,
>>>> 3. Berry road 105, 1750
>>>> etc.
>>>> and the visitor wants to know more about the house on Berry road, I
>>>> can direct him to a page completely devoted to that house.
>>>> Onno
>>> Yes, just construct the hyperlink in your php code.
>>
>> That php code is
>> {echo $row[$i];}
>> I hardly can imagine this works, but I'll try
>
>echo "";
>
>You will get the variable in index.php with $_GET['id']

Of course. Thank you.