Help again

[aladdin1]

Hello,

I did build this querry:

$sql = "SELECT * FROM idx_link WHERE suspended=0 and category_id=76 ORDER BY RAND() limit 1";
$result = mysql_query($sql);

And it works, I can display 1 random link from category # 76. How would I do it if I wanted to display 1 random link but this random link would be chosen from several categories, lets say that this 1 link would randomly chosen from category # 1 OR category # 2 OR category # 3

[inspireme]

no expert in myswl but i think you can jsut say WHERE this OR this OR this

[esm]

...you can jsut say WHERE this OR this OR this

that is OK for a very small number of categories ( say, 4 or 5 ) but EXTREMELY inefficient for a large number of categories. that is what dody did with the categories and bogged everything down.

aladdin, I'll send you some code.



.