'$then' group by pix order by id DESC"; //query
// where user != 'NULL' and user != '' and date > '$then'
$ord=new Split($sql,15);
if($ord->error!="")
{
die("ERROR" . $ord->error);
}
$rows=$ord->display($ppage);
$pages=$ord->total(); //get the total no of pages
?>
Newly Added Pictures (Last 7 Days)
Help us out by uploading your favorite pictures! BackstageRock.com is for fans, by fans!
| Pix |
Artists |
Movie/Show |
User |
Date |
";
include("ti4uconf.php");
// Database Info //
///////////////////
$dbhost="$host";
$dbuser="$user";
$dbpass="$passwd";
$db="$db";
$conn = mysql_pconnect("$dbhost", "$dbuser", "$dbpass");
if (!$conn) {
echo "Unable to connect to DB: " . mysql_error();
exit;
}
if (!mysql_select_db("$db")) {
echo "Unable to select mydbname: " . mysql_error();
exit;
}
while($myrow=mysql_fetch_row($rows))
{
$add++;
if($add == '5'){
echo"| ";
include('banners/rec.dat');
echo" | "; }
$id=$myrow[0];
$pix=$myrow[1];
$idols=$myrow[2];
$moves=$myrow[3];
$user=$myrow[5];
$date=$myrow[4];
$srch3= "Select dir from idols where id='$idols'";
$result5 = mysql_query($srch3);
while ($row2 = mysql_fetch_assoc($result5)) {
$dir="".$row2["dir"]."";
}
$srch= "Select name from movies where id='$moves'";
$result3 = mysql_query($srch);
while ($row = mysql_fetch_assoc($result3)) {
$movies="".$row["name"]."";
}
echo"
 |
";
// GET FROM DB
$srch2= "Select idols from pix where pix='$pix' and date='$date'";
$result2 = mysql_query($srch2);
while ($row3 = mysql_fetch_assoc($result2)) {
$idol="".$row3["idols"]."";
$srch3= "Select name,dir from idols where id='$idol'";
$result5 = mysql_query($srch3);
while ($row2 = mysql_fetch_assoc($result5)) {
$name="".$row2["name"]."";
$dir="".$row2["dir"]."";
echo" $name
";
}
}
if($user == "NULL"){ $user="Webby"; }
echo" |
$movies
|
$user | ";
$date2=date('m-d-Y', $date);
echo"$date2 | ";
}
echo " | Page: ";
if(($ppage=="")||($ppage<="0") )
{
$ppage=1; //as default if the requested page is less than 0 the first page is printed
}
if($ppage > $pages)
{
$ppage=$pages; //if the requested page is greater than total pages the last page is shown
}
if($ppage>1)
{
$backpage=$ppage-1;
printf("<< ");
}
for($j=1;$j<=$pages;$j++)
{
if($j==$ppage)
{
echo "$j ";
if($j == 30 or $j == 59 or $j == 88 or $j == 113 or $j == 135 or $j == 157 or $j == 179 or $j == 201 or $j == 223 or $j == 245 or $j == 267){ echo"
"; }
}
else
{
printf("$j ");
if($j == 30 or $j == 59 or $j == 88 or $j == 113 or $j == 135 or $j == 157 or $j == 179 or $j == 201 or $j == 223 or $j == 245 or $j == 267){ echo"
"; }
}
}
if($ppage<$pages)
{
$nextpage=$ppage+1;
printf(">> ");
}
?>
|
|
|