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
