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 Wed, 18 Nov 2009 10:31:59 -0500, Paul M Foster 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
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
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
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:
snip
Ahem. You are correct. I should have escaped the double quotes. I've
*never* made this kind of mistake before. ;-}
Paul
--
Paul M.
-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, Paul M Foster wrote:
Replace your
On Thu, Nov 19, 2009 at 11:46 AM, Paul M Foster pa...@quillandmouse.com 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:
snip
Ahem. You are correct. I should have escaped the double quotes. I've
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. You also need
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 you both
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
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
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 database by topic
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
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.
14 matches
Mail list logo