Здравейте, искам да попитам как мога да направя така, че примерно съм на определена снимка и като натисна бутона "Следваща" да отиде на следващата снимка качена от този потребител на когото гледам снимките.
Ето какво се помъчих аз :
Ето какво се помъчих аз :
Код:
$user = $_GET['user'];
$picid = $_GET['id'];
$sql = "SELECT * FROM pictures WHERE user = '$id' AND id = '$picid' ORDER BY 'id'";
$result = mysql_query($sql) or die(mysql_error());
$pic = mysql_fetch_array($result);
//Date Fix
$date_out=date('l d, F Y, G:i:s ч.',$pic['date']);
$array1=array("Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday");
$array2=array("Пон", "Вто", "Ср", "Чет", "Пет", "Съб", "Нед");
$array3=array("January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");
$array4=array("Ян", "Фев", "Март", "Април", "Май", "Юни", "Юли", "Авг", "Сеп", "Окт", "Ноем", "Дек");
$date1=str_replace($array1,$array2,$date_out);
$date2=str_replace($array3,$array4,$date1);
//Word Wrap Replace
$describe = $pic['describe'];
$describe = wordwrap($describe, 73, "<br />\n", true);
$describe = str_replace(":)","<img class='emote' src='images/emote/smile.gif' border='0'>",$describe);
$describe = str_replace(":D","<img class='emote' src='images/emote/bigsmile.gif' border='0'>",$describe);
$describe = str_replace("(angel)","<img class='emote' src='images/emote/angel.gif' border='0'>",$describe);
$describe = str_replace(":@","<img class='emote' src='images/emote/angry.gif' border='0'>",$describe);
$describe = str_replace("(bandit)","<img class='emote' src='images/emote/bandit.gif' border='0'>",$describe);
$describe = str_replace("(beer)","<img class='emote' src='images/emote/beer.gif' border='0'>",$describe);
$describe = str_replace("(bow)","<img class='emote' src='images/emote/bow.gif' border='0'>",$describe);
$describe = str_replace("(u)","<img class='emote' src='images/emote/broken.gif' border='0'>",$describe);
$describe = str_replace("(U)","<img class='emote' src='images/emote/broken.gif' border='0'>",$describe);
$describe = str_replace("(bug)","<img class='emote' src='images/emote/bug.gif' border='0'>",$describe);
$describe = str_replace("(cake)","<img class='emote' src='images/emote/cake.gif' border='0'>",$describe);
$describe = str_replace("(^)","<img class='emote' src='images/emote/cake.gif' border='0'>",$describe);
$describe = str_replace("(call)","<img class='emote' src='images/emote/call.gif' border='0'>",$describe);
$describe = str_replace("(cash)","<img class='emote' src='images/emote/cash.gif' border='0'>",$describe);
$describe = str_replace("(chuckle)","<img class='emote' src='images/emote/chuckle.gif' border='0'>",$describe);
$describe = str_replace("(clap)","<img class='emote' src='images/emote/clap.gif' border='0'>",$describe);
$describe = str_replace("(coffee)","<img class='emote' src='images/emote/coffee.gif' border='0'>",$describe);
$describe = str_replace("8-)","<img class='emote' src='images/emote/cool.gif' border='0'>",$describe);
$describe = str_replace(";(","<img class='emote' src='images/emote/cry.gif' border='0'>",$describe);
$describe = str_replace("(dance)","<img class='emote' src='images/emote/dance.gif' border='0'>",$describe);
$describe = str_replace("(devil)","<img class='emote' src='images/emote/devil.gif' border='0'>",$describe);
$describe = str_replace("(doh)","<img class='emote' src='images/emote/doh.gif' border='0'>",$describe);
$describe = str_replace("(drink)","<img class='emote' src='images/emote/drink.gif' border='0'>",$describe);
$describe = str_replace("(drunk)","<img class='emote' src='images/emote/drunk.gif' border='0'>",$describe);
$describe = str_replace("|(","<img class='emote' src='images/emote/dull.gif' border='0'>",$describe);
$describe = str_replace("(emo)","<img class='emote' src='images/emote/emo.gif' border='0'>",$describe);
$describe = str_replace("(envy)","<img class='emote' src='images/emote/envy.gif' border='0'>",$describe);
$describe = str_replace("]:)","<img class='emote' src='images/emote/evil.gif' border='0'>",$describe);
$describe = str_replace("(finger)","<img class='emote' src='images/emote/finger.gif' border='0'>",$describe);
$describe = str_replace("(flex)","<img class='emote' src='images/emote/flex.gif' border='0'>",$describe);
$describe = str_replace("(flower)","<img class='emote' src='images/emote/flower.gif' border='0'>",$describe);
$describe = str_replace("(fubar)","<img class='emote' src='images/emote/fubar.gif' border='0'>",$describe);
$describe = str_replace("(handshake)","<img class='emote' src='images/emote/handshake.gif' border='0'>",$describe);
$describe = str_replace("(happy)","<img class='emote' src='images/emote/happy.gif' border='0'>",$describe);
$describe = str_replace("(headbang)","<img class='emote' src='images/emote/headbang.gif' border='0'>",$describe);
$describe = str_replace("(h)","<img class='emote' src='images/emote/heart.gif' border='0'>",$describe);
$describe = str_replace("(H)","<img class='emote' src='images/emote/fubar.gif' border='0'>",$describe);
$describe = str_replace("(heidy)","<img class='emote' src='images/emote/heidy.gif' border='0'>",$describe);
$describe = str_replace("(wave)","<img class='emote' src='images/emote/hi.gif' border='0'>",$describe);
$describe = str_replace("(hug)","<img class='emote' src='images/emote/hug.gif' border='0'>",$describe);
$describe = str_replace("(inlove)","<img class='emote' src='images/emote/inlove.gif' border='0'>",$describe);
$describe = str_replace(":X","<img class='emote' src='images/emote/lipssealed.gif' border='0'>",$describe);
$describe = str_replace(":x","<img class='emote' src='images/emote/lipssealed.gif' border='0'>",$describe);
$describe = str_replace("(mail)","<img class='emote' src='images/emote/mail.gif' border='0'>",$describe);
$describe = str_replace("(makeup)","<img class='emote' src='images/emote/makeup.gif' border='0'>",$describe);
$describe = str_replace("(mm)","<img class='emote' src='images/emote/mmm.gif' border='0'>",$describe);
$describe = str_replace("(mooning)","<img class='emote' src='images/emote/mooning.gif' border='0'>",$describe);
$describe = str_replace("(movie)","<img class='emote' src='images/emote/movie.gif' border='0'>",$describe);
$describe = str_replace("(~)","<img class='emote' src='images/emote/movie.gif' border='0'>",$describe);
$describe = str_replace("(music)","<img class='emote' src='images/emote/music.gif' border='0'>",$describe);
$describe = str_replace("(myspace)","<img class='emote' src='images/emote/myspace.gif' border='0'>",$describe);
$describe = str_replace("(my)","<img class='emote' src='images/emote/myspace.gif' border='0'>",$describe);
$describe = str_replace("8-|","<img class='emote' src='images/emote/nerd.gif' border='0'>",$describe);
$describe = str_replace("(ninja)","<img class='emote' src='images/emote/ninja.gif' border='0'>",$describe);
$describe = str_replace("(N)","<img class='emote' src='images/emote/no.gif' border='0'>",$describe);
$describe = str_replace("(nod)","<img class='emote' src='images/emote/nod.gif' border='0'>",$describe);
$describe = str_replace("(party)","<img class='emote' src='images/emote/party.gif' border='0'>",$describe);
$describe = str_replace("(phone)","<img class='emote' src='images/emote/phone.gif' border='0'>",$describe);
$describe = str_replace("(pizza)","<img class='emote' src='images/emote/pizza.gif' border='0'>",$describe);
$describe = str_replace("(poolparty)","<img class='emote' src='images/emote/poolparty.gif' border='0'>",$describe);
$describe = str_replace("(puke)","<img class='emote' src='images/emote/puke.gif' border='0'>",$describe);
$describe = str_replace("(punch)","<img class='emote' src='images/emote/punch.gif' border='0'>",$describe);
$describe = str_replace("(rain)","<img class='emote' src='images/emote/rain.gif' border='0'>",$describe);
$describe = str_replace("(rock)","<img class='emote' src='images/emote/rock.gif' border='0'>",$describe);
$describe = str_replace("(rofl)","<img class='emote' src='images/emote/rofl.gif' border='0'>",$describe);
$describe = str_replace(":(","<img class='emote' src='images/emote/sadsmile.gif' border='0'>",$describe);
$describe = str_replace("(shake)","<img class='emote' src='images/emote/shake.gif' border='0'>",$describe);
$describe = str_replace("(skype)","<img class='emote' src='images/emote/skype.gif' border='0'>",$describe);
$describe = str_replace("(sleep)","<img class='emote' src='images/emote/sleep.gif' border='0'>",$describe);
$describe = str_replace("(smirk)","<img class='emote' src='images/emote/smirk.gif' border='0'>",$describe);
$describe = str_replace("(smoke)","<img class='emote' src='images/emote/smoke.gif' border='0'>",$describe);
$describe = str_replace(":|","<img class='emote' src='images/emote/speechless.gif' border='0'>",$describe);
$describe = str_replace("(star)","<img class='emote' src='images/emote/star.gif' border='0'>",$describe);
$describe = str_replace("(sun)","<img class='emote' src='images/emote/sun.gif' border='0'>",$describe);
$describe = str_replace(":O","<img class='emote' src='images/emote/surprised.gif' border='0'>",$describe);
$describe = str_replace(":o","<img class='emote' src='images/emote/surprised.gif' border='0'>",$describe);
$describe = str_replace("(swear)","<img class='emote' src='images/emote/swear.gif' border='0'>",$describe);
$describe = str_replace("(sweat)","<img class='emote' src='images/emote/sweating.gif' border='0'>",$describe);
$describe = str_replace("(talk)","<img class='emote' src='images/emote/talking.gif' border='0'>",$describe);
$describe = str_replace("(think)","<img class='emote' src='images/emote/think.gif' border='0'>",$describe);
$describe = str_replace(":?","<img class='emote' src='images/emote/think.gif' border='0'>",$describe);
$describe = str_replace("(time)","<img class='emote' src='images/emote/time.gif' border='0'>",$describe);
$describe = str_replace("(tmi)","<img class='emote' src='images/emote/tmi.gif' border='0'>",$describe);
$describe = str_replace("(toivo)","<img class='emote' src='images/emote/toivo.gif' border='0'>",$describe);
$describe = str_replace(":P","<img class='emote' src='images/emote/tongue.gif' border='0'>",$describe);
$describe = str_replace("(wait)","<img class='emote' src='images/emote/wait.gif' border='0'>",$describe);
$describe = str_replace("(wasntme)","<img class='emote' src='images/emote/wasntme.gif' border='0'>",$describe);
$describe = str_replace("(whew)","<img class='emote' src='images/emote/whew.gif' border='0'>",$describe);
$describe = str_replace(";)","<img class='emote' src='images/emote/wink.gif' border='0'>",$describe);
$describe = str_replace(":^)","<img class='emote' src='images/emote/wonder.gif' border='0'>",$describe);
$describe = str_replace(":S","<img class='emote' src='images/emote/worried.gif' border='0'>",$describe);
$describe = str_replace(":s","<img class='emote' src='images/emote/worried.gif' border='0'>",$describe);
$describe = str_replace("(yawn)","<img class='emote' src='images/emote/yawn.gif' border='0'>",$describe);
$describe = str_replace("(Y)","<img class='emote' src='images/emote/yes.gif' border='0'>",$describe);
//Next & Previsious
$next = $picid + 1;
$prev = $picid - 1;
if($user != $pic['user'])
{
echo "<span class='alert'>Тази снимка не принадлежи на този потребител !</span>";
}
else
{
echo '<font style="text-align:right;"><b>Добавена '.$date2.'</b></font>
<a class="piclink" style="margin: 0px 0px 0px 130px;" href="photo.php?user='.$user.'&id='.$prev.'"><b>Предишна</b></a>
<a class="piclink" href="photo.php?user='.$user.'&id='.$next.'"><b>Следваща</b></a>
<br /><br />';
echo '<a href="photo.php?user='.$user.'&id='.$next.'"><img src="images/users/photo/'.$pic['photo'].'" width="560" height="460" border="0"/></a><br /><br />';
if ($pic['describe'] == NULL)
{
}
else
{
echo '<span class="quotes_right"></span><b>'.$describe.'</b><span class="quotes_left"></span>';
}
}
}