Portal pic

[Blisk]

when I setup a pic to show on portal from album, I get sql error, if I set more than I cathegory.
if it is set 0 or just one of cathegory it works OK.
But when I set 1, 2, 5, 7 cathegory I get sql error.

[oxpus]

Try here to enter one digit for testing.

[AmigaLink]

There is a bug in the SQL-Syntax!

AND pic_cat_id = (1, 2) GROUP BY p.pic_id ORDER BY RAND() LIMIT 1

must be

AND pic_cat_id IN (1, 2) GROUP BY p.pic_id ORDER BY RAND() LIMIT 1

If you look thereafter, consider (1, 2) is a $variable.

[Blisk]

hmm, sorry but where can I fix that?

I did put in just one digit like 2 or 5, it works ok, but when I put 2 or 3 digits then i get sql error.

[oxpus]

Yes, the SQL_Query will still use one digit. Or you change it like AmigaLink named.

[Blisk]

like to change it, but don't know how

[oxpus]

Search in the portal.php for the string and replace the "=" with "in".

[AmigaLink]

If you does not point which we mean.
Attach your portal.php as an zip-file and we made it for you.

[Blisk]

sorry can't find it in portal.php

[ Attachment gelöscht am Fr 20.Mai, 2005 14:07 von AmigaLink ]

[AmigaLink]

An plus-board *grumpf*
There I can understand why you don't come clear. :rolleyes:

Here it is fixed. ^q

[Blisk]

tnx,
it was missunderstanding

[AmigaLink]

Main thing is, it functions now.

[Blisk]

YES it works now
tnx

[AmigaLink]

Fine