Re: Noob question: Making search results clickable.
| From: | Paul M Foster | Date: | Thu, 19 Nov 2009 15:09:57 +0000 |
| Subject: | Re: Noob question: Making search results clickable. | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-299932@lists.php.net to get a copy of this message | ||
On Thu, Nov 19, 2009 at 03:53:55PM +0100, Nisse Engström wrote:
> On Wed, 18 Nov 2009 10:31:59 -0500, Paul M Foster wrote:
>
> > Replace your query with:
> >
> > "SELECT title, id FROM videos WHERE topid1 = '$topic'"
> >
> > or whatever index you have to select a particular video from your table.
> >
> > Replace your echo statement above with:
> >
> > echo "<a
> > href="video_display.php?video_id=$row[id]">$row[title]</a>";
>
> Without actually checking, I don't think "$row[...]"
> is going to work in double quoted strings. I'm pretty
> sure it needs to be in braces. You also need to escape
> the double quotes and put the array indexes in single
> quotes:
>
> echo "<a
>
> href=\"video_display.php?video_id={$row['id']}\">{$row['title']}</a>";
>
Ahem. You are correct. I should have escaped the double quotes. I've
*never* made this kind of mistake before. ;-}
Paul
--
Paul M. Foster