Hi.
On Tue, Oct 02, 2001 at 01:02:19PM +0100, [EMAIL PROTECTED] wrote:
Hi there. I have problems with mySQL
What I would like to do is:
I have a statement
SELECT a.id AS ID, IDmark, IDrecipe, ocenjevalec, ocena,
ROUND(AVG(ocena),1) as povprecje, COUNT(*) as all, IF (ID=ocenjevalec,
Hi there. I have problems with mySQL
What I would like to do is:
I have a statement
SELECT a.id AS ID, IDmark, IDrecipe, ocenjevalec, ocena,
ROUND(AVG(ocena),1) as povprecje, COUNT(*) as all, IF (ID=ocenjevalec,
'yes', 'no') as zeocenil
FROM ocenerecepti, obiskovalci
WHERE IDrecept = 1365