Re: Noob question: Making search results clickable.
| From: | Ashley Sheridan | Date: | Thu, 19 Nov 2009 15:07:42 +0000 |
| Subject: | Re: Noob question: Making search results clickable. | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-299934@lists.php.net to get a copy of this message | ||
On Thu, 2009-11-19 at 10:09 -0500, Paul M Foster wrote:
> 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
>
Gonna go to PHP hell for that faux pas!
Thanks,
Ash
http://www.ashleysheridan.co.uk