Thanks. That answer worked. Ron
--
-Original Message-
From: Kesavan Rengarajan
To: ron.pigg...@actsministries.org
Cc: ron.pigg...@actsministries.org ,
php-db@lists.php.net
Subject: Re: [PHP-DB] Re: LEFT JOIN query help
Date: Mon, 19 Jul 2010 08:21:00 +1000
Change 'NOT LIKE' t
Hi everyone!
I'm trying to put together a completely database driven site so I can
learn how to do it...
I've gone to the extent of creating apache rewrite rules to redirect
all non-existent files/folders to my script to see if it exists which
works perfectly.
Where I'm running into tro
Change 'NOT LIKE' to 'NOT IN' in the outer query.
Sent from my iPhone
On 19/07/2010, at 4:15 AM, "Ron Piggott" wrote:
>
> I am still working on this query and wondering if I should be taking a
> different approach --- to use a sub query to figure out which questions
> have been answered and th
I am still working on this query and wondering if I should be taking a
different approach --- to use a sub query to figure out which questions
have been answered and then an "outter" query to not select one of them.
But mySQL is giving me the error that the subquery has more than 1 row ---
I have
I am writing a Bible trivia application. I am trying to write the mySQL
query that will select the next question reference number and the current
question is answered. The value I want to retrieve It is in the field:
`verse_of_the_day_Bible_trivia`.`reference`
I don't think I have my LEFT JOIN'
Thanks, Ron
--
-Original Message-
From: Andrés G. Montañez
To: ron.pigg...@actsministries.org
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] NULL to 0
Date: Sat, 17 Jul 2010 23:20:20 -0300
SELECT
IFNULL(SUM(`my_Bible_trivia_knowledge_questions_answered`.`score`),
0) AS total_s