Problem with links help pls

rutra

Hi there🙂

I have a site with links to galleries which shows randomly after reloading. I have 120 links one after one, it use one database and everything is correct.
Right now i would like to add pictures among them, like:
40 links in two columns then pictures, then again 40 links.
How should i do it to not have two times the same link ?
Is it possible?
Help me pls

thx rutra

scoppc

I dont get what exactly your problem is. Are you saying that you want to separate 120 links (+pictures) into several pages with 40 links(+pictures) each?

rutra

not on the same page
before i had page with links to another pages, 120 links in one column. And i had a database of 300 links, script always showed random 120 of 300.
now i want to change layout of that page like: 2 columns with 20 links each, below some other things like pictures, and below again
2 columns with 20 links each
and i would like it takes random links from the same database.
do you know what i mean?

rutra

superwormy

If I understand you correctly... you're saying you want to run two queries to select two sets of random things, but you dont want any repeats. Correct?

In that case, record the IDs of the ones you select in the first query, and use them as ID NOT IN ( comma, seperated, list, of, IDs, from, first, random, selection ) in your query.

rutra

i don't know about php too much , just guy write this to me has no other idea like make to database and divide my links
i'll show you that code to desribe what it is:
<?
//poczatek skryptu z linkami
$ile = 100;
$file = file("linki.txt");
for($i=0;$i<$ile;$i++)
{
srand((double)microtime()*1000000);
$link = $file[array_rand($file)];
$sp = explode("||", $link);
if($sp[0]<>"")
{
echo "".$sp[0]." <a href=\"".$sp[1]."\">".$sp[2]."</a><br>";
}
}
//koniec skryptu z linkami
?>