Ford, Mike wrote:
>> -Original Message-
>> From: Nisse Engström [mailto:news.nospam.0ixbt...@luden.se]
>> Sent: 19 November 2009 14:54
>> To: php-general@lists.php.net
>> Subject: Re: [PHP] Noob question: Making search results clickable.
>>
>>
On Thu, 19 Nov 2009 15:07:42 +, Ashley Sheridan wrote:
> On Thu, 2009-11-19 at 10:09 -0500, Paul M Foster wrote:
>>
>> Ahem. You are correct. I should have escaped the double quotes. I've
>> *never* made this kind of mistake before. ;-}
>
> Gonna go to PHP hell for that faux pas!
I'll see y
On Thu, 19 Nov 2009 17:02:53 -, "Ford, Mike" wrote:
>> -Original Message-
>> From: Nisse Engström [mailto:news.nospam.0ixbt...@luden.se]
>>
>> 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
On Thu, Nov 19, 2009 at 11:46 AM, Paul M Foster wrote:
> On Thu, Nov 19, 2009 at 03:07:42PM +, Ashley Sheridan wrote:
>
>> On Thu, 2009-11-19 at 10:09 -0500, Paul M Foster wrote:
>>
>
>
>
>>
>> Ahem. You are correct. I should have escaped the double quotes. I've
>> *never* made this k
> -Original Message-
> From: Nisse Engström [mailto:news.nospam.0ixbt...@luden.se]
> Sent: 19 November 2009 14:54
> To: php-general@lists.php.net
> Subject: Re: [PHP] Noob question: Making search results clickable.
>
> On Wed, 18 Nov 2009 10:31:59 -0500
On Thu, Nov 19, 2009 at 03:07:42PM +, Ashley Sheridan wrote:
> On Thu, 2009-11-19 at 10:09 -0500, Paul M Foster wrote:
>
>
> Ahem. You are correct. I should have escaped the double quotes. I've
> *never* made this kind of mistake before. ;-}
>
> Paul
>
> --
> Paul M.
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'"
> > >
> >
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.
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 "$row[title]";
Witho
Make sure to reply all...
Paul Jinks wrote:
> Thanks to everyone for replying, it's much appreciated. Thanks
> especially for the final piece of the puzzle, Shawn, I don't think I
> was going to find it on my own - the display I have in mind is a
> little different, but I think I can figure it out
Shawn McKenzie wrote:
Gary Smith wrote:
And changing your query accordingly.
For the first piece Gary has it right, but your query needs to include
the id also.
Yeah, as I mentioned, he'd need to change the query accordingly, either
to select id,title or select *
Cheers,
Gary
-
Gary Smith wrote:
> Paul Jinks wrote:
>> Hi all
>>
>> I'm building a fairly basic php/mySql site but I'm running into
>> problems due to my total lack of experience. I have a database of
>> videos - each has a title, transcript, description and one or more
>> topics. So far I can search the databas
On Wed, Nov 18, 2009 at 03:04:13PM +, Paul Jinks wrote:
> Hi all
>
> I'm building a fairly basic php/mySql site but I'm running into
> problems due to my total lack of experience. I have a database of
> videos - each has a title, transcript, description and one or more
> topics. So far I can
Paul Jinks wrote:
Hi all
I'm building a fairly basic php/mySql site but I'm running into
problems due to my total lack of experience. I have a database of
videos - each has a title, transcript, description and one or more
topics. So far I can search the database by topic (using a drop-down
menu)
Hi all
I'm building a fairly basic php/mySql site but I'm running into
problems due to my total lack of experience. I have a database of
videos - each has a title, transcript, description and one or more
topics. So far I can search the database by topic (using a drop-down
menu), like this:
";
}
15 matches
Mail list logo
