1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
|
<?php
include("config.inc.php");
$ueber = $_GET["ueber"];
$user = $_SESSION["user"];
$verbindung=mysql_connect($dbhost,$dbuser,$dbpasswd);
$abfrage = "SELECT * FROM bilder WHERE cat='$ueber' AND aktiv='1' ORDER by id DESC";
$ergebnis=mysql_db_query($db,$abfrage,$verbindung);
$num = mysql_num_rows($ergebnis);
$i = 1;
while($i <= $num && $row = mysql_fetch_object($ergebnis))
{
$url = $row->url;
$name = $row->user;
$id = $row->id;
$datum = $row->datum;
$verbindung2=mysql_connect($dbhost,$dbuser,$dbpasswd);
$abfrage2 = "SELECT * FROM online WHERE name='$user'";
$ergebnis2=mysql_db_query($db,$abfrage2,$verbindung2);
while($row2 = mysql_fetch_object($ergebnis2))
{
$out = $row->out;
if($row->out < $datum)
{
$aktiv = "<span style='color: red;'><b>Neu</b></span>";
}
else
{
$aktiv = "";
}
echo "<td align=center>$aktiv<br><a href='?section=download&id=$id'><img src='upload/klein/$id' border='0'></a><br>© by <a href='?section=fotographen2&name=$name'>$name</a></td>";
if (($i%3) == 0)
{
echo "</tr><tr>";
}
$i++;
}
}
?> |