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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
